Re: [sqlalchemy] Re: SQLAlchemy join/has query with example code

2021-02-07 Thread Mike Bayer
On Sat, Feb 6, 2021, at 8:56 AM, Chris Simpson wrote: > After posting, I have arrived at *a* solution (which might be awful) Please > let me know if this is a bad approach or I'm following the api correctly: > > I have converted this SQL query: > > SELECT COUNT(*) > FROM person > JOIN

[sqlalchemy] Relationship with 2 intermediary tables

2021-02-07 Thread Dane K Barney
I am trying to create a relationship from one table to another, which involves two intermediary tables. I *think* I need to use the secondaryjoin + secondary arguments to relationship(). But after studying the documentation for a long time, I can't get my head around how these arguments are