Re: [sqlalchemy] advices

2013-03-19 Thread Julien Cigar
On 03/18/2013 18:47, Michael Bayer wrote: On Mar 15, 2013, at 3:19 PM, Julien Cigar jci...@ulb.ac.be wrote: On 03/14/2013 19:56, Michael Bayer wrote: On Mar 12, 2013, at 5:13 AM, Julien Cigar jci...@ulb.ac.be wrote: Hello, I have written a CMS which is, among other, based on the joined

Re: [sqlalchemy] column_property for correlated subquery

2013-03-19 Thread Michael Bayer
I think we need to just get column_property to work as a string with declarative. Sent from my iPhone On Mar 19, 2013, at 6:10 AM, millerdev miller...@gmail.com wrote: __declare_last__ works. Thanks Mike. Would it make sense to add a property decorator similar to @declared_attr (maybe

[sqlalchemy] capture SQL without executing

2013-03-19 Thread Catherine Devlin
Hi! I'm looking for a way to capture the text of SQL that SQLAlchemy is prepared to execute, without actually executing the SQL. There has to be a way, right? Why (#1): I'm working on a DDL-generating tool for DBAs who no-way-no-how will let some Python tool change their database directly. Why

Re: [sqlalchemy] capture SQL without executing

2013-03-19 Thread Michael Bayer
On Mar 19, 2013, at 6:46 PM, Catherine Devlin catherine.dev...@gmail.com wrote: Hi! I'm looking for a way to capture the text of SQL that SQLAlchemy is prepared to execute, without actually executing the SQL. There has to be a way, right? Why (#1): I'm working on a DDL-generating tool