[sqlalchemy] Re: Unnecessary join in eager one-to-many backref

2009-08-04 Thread Martin Stein
On Aug 3, 5:07 pm, Michael Bayer mike...@zzzcomputing.com wrote: Ok that's kind of interesting.   as a general rule, the ORM doesn't like to make assumptions.  such as here, there is a lazyloader on User.keywords, which says query for these Keyword objects, without any knowledge of what

[sqlalchemy] Re: Unnecessary join in eager one-to-many backref

2009-08-03 Thread Michael Bayer
Martin Stein wrote: Hi everybody, In my db-setup, there is a one-to-many relationship with a backref that is configured for eager loading (not the relation but the backref!). When I access the child objects of the parent object, the query from sqlalchemy joins back to the parent object (due