[sqlalchemy] Join multiple tables with association tables

2021-08-09 Thread 'timbecks' via sqlalchemy
I am trying to figure out the correct join query setup within SQLAlchemy, but I can't seem to get my head around it. I have the following table setup (simplified, I left out the non-essential fields): [image: Unbenannt.png] [image: Unbenannt2.png] The facts are associated to info, info is

[sqlalchemy] Join multiple tables with association tables

2021-08-09 Thread 'timbecks' via sqlalchemy
I am trying to figure out the correct join query setup within SQLAlchemy, but I can't seem to get my head around it. I have the following table setup (simplified, I left out the non-essential fields): ```pyhton "facts_info", Base.metadata, sqlColumn("fact_id", Integer,

[sqlalchemy] Join multiple tables with association tables

2021-08-09 Thread 'timbecks' via sqlalchemy
I am trying to figure out the correct join query setup within SQLAlchemy, but I can't seem to get my head around it. I have the following table setup (simplified, I left out the non-essential fields): ```pyhton "facts_info", Base.metadata, sqlColumn("fact_id", Integer,