there is append_from()
joins know how to find their components that are already in the
selectable and replace them.
On Mar 5, 2007, at 4:38 PM, Dennis wrote:
I'm playing around with dynamically building a query. I can append
columns, where clauses, from objects etc... but what about the
Actually, I'm still having a problem because the primary object is
already a join and the next object that I append gets listed twice.
Example
sel=select([a,b], from_obj=[a.outerjoin(b)])
sel.append( a.outerjoin(c,somecriteriaforthejoin))
str(sel)
SELECT ,,, FROM a LEFT OUTER JOIN b ON , a
I did find a slight hack:
query.append_from (
query.froms._list[0].outerjoin( etc ... ) )
-Dennis
On Mar 5, 3:54 pm, Dennis [EMAIL PROTECTED] wrote:
Actually, I'm still having a problem because the primary object is
already a join and the next object that I append gets listed twice.