[sqlalchemy] innerjoin and eagerloading

2010-05-26 Thread David Gardner
I have a users table, with a lazy=False, innerjoin=True relation to the preferences table (these could probably be the same table but they are separate for historical reasons). One of the gotchas that I am running into is when I do an outerjoin on to the user's table, it effectively becomes

Re: [sqlalchemy] innerjoin and eagerloading

2010-05-26 Thread Michael Bayer
On May 26, 2010, at 1:39 PM, David Gardner wrote: I have a users table, with a lazy=False, innerjoin=True relation to the preferences table (these could probably be the same table but they are separate for historical reasons). One of the gotchas that I am running into is when I do an

[sqlalchemy] innerjoin for eagerloading

2010-02-01 Thread Kent
For performance reasons, I'd like eagerloading to do inner joins where possible. I found ticket 1544 http://www.sqlalchemy.org/trac/ticket/1544 addresses exactly this concern, and I've patched the option for innerjoin=True. This works, thank you. I wanted to point out, however, that the orm