Re: [sqlalchemy] What about bit fields / bit masks?

2015-08-31 Thread Jonathan Vanasco
postgres wise: I use an INT field to store bitwise data. I wrote a class that declares enumerated sets and manages the the bitwise operations, then serializes it to an int. I use an @property to deserialize reads and manually serialize the writes (not enough time/need to integrate with

Re: [sqlalchemy] Re: how to set assocation proxy pattern with automap

2015-08-31 Thread yoch . melka
Great thanks ! There is something I still doesn't understand with automap_base : some relationships are created only after the first query call (which takes much more time to terminate). For instance : >>> from dbaccess import *# import engine, models, etc. >>>

Re: [sqlalchemy] Re: how to set assocation proxy pattern with automap

2015-08-31 Thread Mike Bayer
On 8/31/15 3:39 PM, yoch.me...@gmail.com wrote: Great thanks ! There is something I still doesn't understand with automap_base : some relationships are created only after the first query call (which takes much more time to terminate). call configure_mappers() after you call

Re: [sqlalchemy] Re: how to set assocation proxy pattern with automap

2015-08-31 Thread yoch . melka
Thank you very much, it work fine now. Le lundi 31 août 2015 23:03:17 UTC+3, Michael Bayer a écrit : > > > > On 8/31/15 3:39 PM, yoch@gmail.com wrote: > > Great thanks ! > > > There is something I still doesn't understand with automap_base : some > relationships are created only after the

[sqlalchemy] MySql+oursql error on Time columns

2015-08-31 Thread Massi
Hi everyone, I'm trying to use oursql module with sqlalchemy (0.9.10) for managing a table with TIME columns, but I'm encountering an error, here a code snippet showing the problem: import sqlalchemy from sqlalchemy import select, create_engine, MetaData, Table, Column import datetime engine

Re: [sqlalchemy] Referring to __tablename__ as defined by a mixin's delarative_attr

2015-08-31 Thread rob
Thanks On Sunday, August 30, 2015 at 10:28:58 PM UTC-5, Michael Bayer wrote: > > > > On 8/30/15 1:58 PM, r...@rosenfeld.to wrote: > > Hi All, > > I'm trying to replace string definitions prgrammatically where possible. > I have the following working: > > from sqlalchemy import Column > from

Re: [sqlalchemy] Re: how to set assocation proxy pattern with automap

2015-08-31 Thread yoch . melka
Thank you very much. Le lundi 31 août 2015 06:17:37 UTC+3, Michael Bayer a écrit : > > > > On 8/29/15 2:27 PM, yoch@gmail.com wrote: > > Thanks for the reply. > > Le vendredi 28 août 2015 18:52:37 UTC+3, Michael Bayer a écrit : > > > > On 8/28/15 3:51 AM, yoch@gmail.com wrote: > >

Re: [sqlalchemy] Re: how to set assocation proxy pattern with automap

2015-08-31 Thread Mike Bayer
On 8/31/15 8:23 AM, yoch.me...@gmail.com wrote: Thank you very much. Le lundi 31 août 2015 06:17:37 UTC+3, Michael Bayer a écrit : On 8/29/15 2:27 PM, yoch@gmail.com wrote: Thanks for the reply. Le vendredi 28 août 2015 18:52:37 UTC+3, Michael Bayer a écrit :

Re: [sqlalchemy] MySql+oursql error on Time columns

2015-08-31 Thread Mike Bayer
On 8/31/15 6:56 AM, Massi wrote: Hi everyone, I'm trying to use oursql module with sqlalchemy (0.9.10) for managing a table with TIME columns, but I'm encountering an error, here a code snippet showing the problem: import sqlalchemy from sqlalchemy import select, create_engine, MetaData,