Re: [sqlalchemy] Re: Transaction isolation level support?

2010-12-14 Thread Rhett Garber
Coincidentally I've been dealing with issue lately as I've tried to further integrate sqlalchemy into a legacy code base and replace our existing database abstraction. In MySQL at least, there is a concept of session isolation level and transaction isolation level. Meaning you can set the

[sqlalchemy] Connection initialization

2010-06-25 Thread Rhett Garber
When we make a new connection to the database (MySQL in this case), it appears that the dialect has some initialization functions than run several queries: connection duration rows query primary_slave/tid=92761174.014ms 1'SELECT DATABASE()'

Re: [sqlalchemy] Custom ORM attributes to provide on-the-fly data conversion

2010-04-21 Thread Rhett Garber
On Wed, Apr 21, 2010 at 6:35 AM, Michael Bayer mike...@zzzcomputing.com wrote: Rhett Garber wrote: This would be much easier, I could potentially be what we go with. I think this is similar to my 'original implementation' I just found the syntax to be a bit bothersome since the person

Re: [sqlalchemy] Custom ORM attributes to provide on-the-fly data conversion

2010-04-20 Thread Rhett Garber
On Tue, Apr 20, 2010 at 4:32 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Apr 20, 2010, at 7:06 PM, Rhett wrote: I've run into some difficulty getting the ORM to fit into an existing code base with some, I suppose, non-standard conventions. One of the conventions is to not allow