Re: [sqlalchemy] Possible to pass array of (table, conditions) to join() like where()/select() ?

Thanks! On Friday, September 16, 2022 at 10:53:59 AM UTC-7 Mike Bayer wrote: > > > On Fri, Sep 16, 2022, at 12:10 PM, mkmo...@gmail.com wrote: > > I use the following pattern in my REST APIs, building up the select, > joins, where conditions, group bys, order bys, depending on the query >

Re: [sqlalchemy] Possible to pass array of (table, conditions) to join() like where()/select() ?

On Fri, Sep 16, 2022, at 12:10 PM, mkmo...@gmail.com wrote: > I use the following pattern in my REST APIs, building up the select, joins, > where conditions, group bys, order bys, depending on the query parameters > passed in by the user: > > selects = [Foo] > joins = [(Bar, Foo.c.id

[sqlalchemy] Possible to pass array of (table, conditions) to join() like where()/select() ?

I use the following pattern in my REST APIs, building up the select, joins, where conditions, group bys, order bys, depending on the query parameters passed in by the user: selects = [Foo] joins = [(Bar, Foo.c.id == Bar.c.foo_id)] where_conditions = [Foo.c.id == request.args['pk']]