[sqlalchemy] Re: Complicated relations

2009-09-01 Thread Michael Bayer
Conor wrote: Hello: I am trying to build a complicated relation, but am having trouble due to the following: * there are multiple intermediate tables involved * the relation requires EXISTS clauses as the join condition between several of these tables My model is shown below. The

[sqlalchemy] Re: Complicated relations

2009-09-01 Thread Conor
On Sep 1, 12:13 pm, Michael Bayer mike...@zzzcomputing.com wrote: [...] have you considered the advice athttp://www.sqlalchemy.org/docs/05/mappers.html#building-query-enabled... ?    an embedded EXISTS subquery in a relation() doesn't seem like something that should be emitted implicitly -

[sqlalchemy] Re: Complicated relations

2009-09-01 Thread Michael Bayer
Conor wrote: On Sep 1, 12:13 pm, Michael Bayer mike...@zzzcomputing.com wrote: [...] have you considered the advice athttp://www.sqlalchemy.org/docs/05/mappers.html#building-query-enabled... ?    an embedded EXISTS subquery in a relation() doesn't seem like something that should be emitted