[sqlalchemy] Re: joining to child, and using child in relation

2009-01-29 Thread GHZ
Tested with trunk. Works, thanks. On Jan 29, 6:42 am, Michael Bayer mike...@zzzcomputing.com wrote: OK, well that was painful but we are stronger for the effort, thanks   for bringing up the issue.  r5740 of trunk will allow your original   mapper(A.join(B))-mapper(B) to configure properly.

[sqlalchemy] Re: joining to child, and using child in relation

2009-01-28 Thread Michael Bayer
a join is of the form: table1.join(table2, onclause) such as subscriber_table.join(address_table, and_(address_table.c.subscriber_id==subscriber.c.id, address_table.c.type=='MAIN')) but unfortunately current relation() code does not support a join of X/ Y to Y, unless the join of

[sqlalchemy] Re: joining to child, and using child in relation

2009-01-28 Thread Michael Bayer
OK, well that was painful but we are stronger for the effort, thanks for bringing up the issue. r5740 of trunk will allow your original mapper(A.join(B))-mapper(B) to configure properly. On Jan 28, 2009, at 11:28 PM, Michael Bayer wrote: a join is of the form: table1.join(table2,