Re: [sqlalchemy] Reflection overhead

2011-06-18 Thread Tomasz Jezierski - Tefnet
Dnia 2011-06-17, piÄ… o godzinie 22:47 -0400, Mark Erbaugh pisze: Is there overhead associated with reflection? When SA is used in a stateless web server, I think it would have to do the reflection every time a new page is served. Is there a way to create and reuse a snapshot of the

[sqlalchemy] Autocreate parent while inserting child

2011-06-18 Thread Fayaz Yusuf Khan
Hi, I'm a SQLA and MySQL noob. I have a many to one relationship somewhat similar to this: class Parent(Base): ... name = Column(String, primary_key=True) class Child(Base): ... parent = Column(String, ForeignKey('Parent.name')) And I'm trying to do this: session.add(Child(...,

Re: [sqlalchemy] Reflection overhead

2011-06-18 Thread Michael Bayer
reflection is not a fast process at all since it aims to be comprehensive. The MetaData, Table and everything related is pickleable for the purpose of apps that want to cache the results of reflection in a file, to be pulled out later. On Jun 17, 2011, at 10:47 PM, Mark Erbaugh wrote: Is

[sqlalchemy] Re: Conditional insert in one transaction

2011-06-18 Thread Eric Ongerth
Just curious and learning here -- There are two separate issues here, aren't there? (1.) Atomicity of the transaction, taken care of by the above discussion, and (2.) what if there was a need to have it be not only atomic but consume as little time as possible between the read and write, let's

Re: [sqlalchemy] Reflection overhead

2011-06-18 Thread Mark Erbaugh
On Jun 18, 2011, at 6:37 AM, Tomasz Jezierski - Tefnet wrote: How about: http://code.google.com/p/sqlautocode/ ? Thanks for the pointer. That's just the kind of module I was looking for. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

Re: [sqlalchemy] Reflection overhead

2011-06-18 Thread Mark Erbaugh
On Jun 18, 2011, at 10:37 AM, Michael Bayer wrote: reflection is not a fast process at all since it aims to be comprehensive. The MetaData, Table and everything related is pickleable for the purpose of apps that want to cache the results of reflection in a file, to be pulled out later.

[sqlalchemy] Sqlite date field

2011-06-18 Thread Mark Erbaugh
I have a legacy database where dates are stored in the format mm/dd/ (i.e. 06/18/2011). Is it possible to adapte the Sqlalchemy DATE() type to use this format? If not, is is possible to create a new class to handle this format? Thanks, Mark -- You received this message because you are