Re: [sqlalchemy] issue with joineload and multiple relationships to the same table

2017-04-21 Thread Jonathan Vanasco
Thanks. That's exactly it. It makes perfect sense why it just happens to work when I join one bar onto this, but not two. FYI, I'm not seeing a comma on the simple join - but it's still a bad query that illustrates the problem as Bar doesn't get joined in: SELECT foo.id AS foo_id FROM foo

Re: [sqlalchemy] issue with joineload and multiple relationships to the same table

2017-04-21 Thread mike bayer
On 04/20/2017 09:12 PM, Jonathan Vanasco wrote: i have roughly the following model: Widget > Widget2Foo > Foo > Foo2Bar > Bar wherein `Foo` has multiple relationships to `Bar` (via a filter ) the setup works for lazyloading and subqueryloading, but I can't do multiple joinedloads: eg:

[sqlalchemy] issue with joineload and multiple relationships to the same table

2017-04-20 Thread Jonathan Vanasco
i have roughly the following model: Widget > Widget2Foo > Foo > Foo2Bar > Bar wherein `Foo` has multiple relationships to `Bar` (via a filter ) the setup works for lazyloading and subqueryloading, but I can't do multiple joinedloads: eg: lazyloading and this subquery works: query =