Re: [sqlalchemy] contains_eager across multiple relationships using aliases

2012-01-28 Thread Justin Thiessen
On Friday, January 20, 2012 9:17:53 PM UTC-8, Michael Bayer wrote: > > > On Jan 20, 2012, at 6:59 PM, Justin Thiessen wrote: > > joins> > > contains_eager(User.job, alias=job_alias) > contains_eager(User.job, Job.desk, alias=desk_alias) > > both are needed since the User->job->desk load can't

Re: [sqlalchemy] contains_eager across multiple relationships using aliases

2012-01-20 Thread Michael Bayer
On Jan 20, 2012, at 6:59 PM, Justin Thiessen wrote: > Hi, > > I'm trying to use the 'contains_eager' option but experiencing some > difficulty figuring out how to make it generate what I need. > > Short background: > > The code is part of an automated search-generation algorithm that takes >

[sqlalchemy] contains_eager across multiple relationships using aliases

2012-01-20 Thread Justin Thiessen
Hi, I'm trying to use the 'contains_eager' option but experiencing some difficulty figuring out how to make it generate what I need. Short background: The code is part of an automated search-generation algorithm that takes kw=val constructs (such as user.name='bob', user.job.title='engineer',