Recently I had a fairly complex SQL query I wanted to write out using
SQLAlchemy.
I ended up implementing it using select() so what I end up doing looks
something like:
parent=my_table.alias('parent')
child=my_table.alias('child')
j=parent.outerjoin(child, <condition>)
my_qry=select([my_table], from_obj[j])
Then later on I do:
session.query(MyObj).from_statement(my_qry.where(parent.c.foo==bar)).all()
Is there any reason why I shouldn't just keep my_qry instantiated and
use it as needed, or should I re-construct it for each query?
--
David Gardner
Pipeline Tools Programmer, "Sid the Science Kid"
Jim Henson Creature Shop
[email protected]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
