Re: [sqlalchemy] Make a copy of a select

2011-09-09 Thread Torsten Landschoff
On Tue, 2011-09-06 at 10:03 -0400, Michael Bayer wrote: the generative method on Select is select_from(): http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=select_from#sqlalchemy.sql.expression.Select.select_from Thanks. The documentation on that methods says: return a new

Re: [sqlalchemy] Make a copy of a select

2011-09-09 Thread Michael Bayer
On Sep 9, 2011, at 6:48 AM, Torsten Landschoff wrote: On Tue, 2011-09-06 at 10:03 -0400, Michael Bayer wrote: the generative method on Select is select_from(): http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=select_from#sqlalchemy.sql.expression.Select.select_from

[sqlalchemy] Make a copy of a select

2011-09-06 Thread Torsten Landschoff
Hello *, (Using SQLAlchemy 0.6.8, but planning to move to 0.7 soon) I am trying to build queries dynamically and I have to add joins on the primary table to be able to create my where-clauses. To add the join clause on my instance of Select, I found this discussion:

Re: [sqlalchemy] Make a copy of a select

2011-09-06 Thread Michael Bayer
the generative method on Select is select_from(): http://www.sqlalchemy.org/docs/core/expression_api.html?highlight=select_from#sqlalchemy.sql.expression.Select.select_from Copying a select() is best performed via myselect._generate(). its a shallow copy and the select() tries to make sure it