[sqlalchemy] expressing an inferred relationship

2014-10-27 Thread Jonathan Vanasco
I've been staring at this a few hours, and can't figure out how to adapt a join/query into a relationship. The archives and docs don't seem to help much. It seems reminiscent to an earlier question by Simon King ( https://groups.google.com/d/topic/sqlalchemy/OtI4Z8v7gRs/discussion ) and some

[sqlalchemy] Status of column comment support (mainly interested in MySQL)

2014-10-27 Thread Jacek Szpot
Hey list, What's the state of support for column comments? I was only able to dig out one mention of this — from 2009 [1] — and the docs only seem to mention this in the description of the `Column.doc` attribute. [2] I'd be interested in helping out with this one, if possible. Just let me know

Re: [sqlalchemy] Obtaining the SQL query for a lazy load programmatically

2014-10-27 Thread Michael Bayer
> On Oct 27, 2014, at 1:17 PM, Peter Waller wrote: > > I observe that the query for a lazy load is generated here: > > https://bitbucket.org/zzzeek/sqlalchemy/src/e1d1d999c9a688f4c8dbbe885438c63d6ef494c6/lib/sqlalchemy/orm/strategies.py?at=master#cl-551 > >

[sqlalchemy] Obtaining the SQL query for a lazy load programmatically

2014-10-27 Thread Peter Waller
I observe that the query for a lazy load is generated here: https://bitbucket.org/zzzeek/sqlalchemy/src/e1d1d999c9a688f4c8dbbe885438c63d6ef494c6/lib/sqlalchemy/orm/strategies.py?at=master#cl-551 I would like to run queries through an EXPLAIN QUERY PLAN or an ANALYZE programmatically for many prop

Re: [sqlalchemy] Windowed Queries breaking after a commit and emitting many, many Selects.

2014-10-27 Thread James Meneghello
Using a scoped session with a session generator and I didn't want expire_on_commit to be False for everything, so setting it using the Session constructor wouldn't work properly. If a session was created prior to the one that needed that flag, it'd give me a ProtocolError since it couldn't chan