[sqlalchemy] Re: Saved Queries (or text representation of the SQL)

2009-10-23 Thread jeff
I would like to save a number of these in a database so size is important (the serialized select() was somewhat large...) so I would like to get the string representation of the raw SQL directly useable by sqlalchemy if possible. As I have in my examples, the str(select) doesn't seem directly

[sqlalchemy] Re: Saved Queries (or text representation of the SQL)

2009-10-23 Thread Mike Conley
On Fri, Oct 23, 2009 at 12:45 PM, jeff jeff.sie...@seagate.com wrote: I would like to save a number of these in a database so size is important (the serialized select() was somewhat large...) so I would like to get the string representation of the raw SQL directly useable by sqlalchemy if

[sqlalchemy] Re: Saved Queries (or text representation of the SQL)

2009-10-23 Thread Michael Bayer
jeff wrote: I would like to save a number of these in a database so size is important (the serialized select() was somewhat large...) using serializer() ? really? if you do a naive dumps() with plain pickle, yes the serialize would be huge. so I would like to get the string

[sqlalchemy] Re: Saved Queries (or text representation of the SQL)

2009-10-23 Thread Mike Conley
On Fri, Oct 23, 2009 at 1:47 PM, Michael Bayer mike...@zzzcomputing.comwrote: Much easier to use serializer. I agree with that. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this

[sqlalchemy] Re: Saved Queries (or text representation of the SQL)

2009-10-22 Thread Michael Bayer
On Oct 22, 2009, at 6:33 PM, jeff wrote: I would like to allow user's to save favorite queries in my Python app. Is there a way to find out the SQL statement as a string that can be then reused (e.g. Engine.execute(text(savedQueryText) ) )? Or is there another solution to this need?