[sqlalchemy] Re: SQL Expression lang; change table in from clause after query construction; copying queries; printing queries with filled params

2010-08-04 Thread Gregg Lind
Thanks for the advice! One minor nit. At least in my experience, str(bound query) doesn't fill the params, or do quoting properly. Here is a demonstration: fake_table = Table( 'faketable', metadata, Column('ts',Integer, index=True, nullable=False),

Re: [sqlalchemy] Re: SQL Expression lang; change table in from clause after query construction; copying queries; printing queries with filled params

2010-08-04 Thread Michael Bayer
On Aug 4, 2010, at 1:26 PM, Gregg Lind wrote: Thanks for the advice! One minor nit. At least in my experience, str(bound query) doesn't fill the params, or do quoting properly. Here is a demonstration: fake_table = Table( 'faketable', metadata, Column('ts',Integer,

[sqlalchemy] Re: SQL Expression lang; change table in from clause after query construction; copying queries; printing queries with filled params

2010-08-04 Thread Gregg Lind
Thank you for the more detailed explanation! I will do some experiments with it! Gregg On Aug 4, 12:39 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Aug 4, 2010, at 1:26 PM, Gregg Lind wrote: Thanks for the advice! One minor nit.  At least in my experience, str(bound query)