Re: [sqlalchemy] Reflected Table FK

2020-12-31 Thread Matthew Graham
and foreign key > constraints in an abstract sense I would want it to assume composite in all > cases. > > > > On Thu, Dec 31, 2020, at 3:53 PM, Matthew Graham wrote: > > Are you saying with the multiple foreign keys that for each key, multiple > columns can be used? I am awa

Re: [sqlalchemy] Reflected Table FK

2020-12-31 Thread Matthew Graham
Are you saying with the multiple foreign keys that for each key, multiple columns can be used? I am aware that if you had table A and it had columns B_id and C_id that B_id may be a fk to B and C_id may be a reign key to C, but are you essentially saying there is an equivalence to a "composite"

[sqlalchemy] Reflected Table FK

2020-12-31 Thread Matthew Graham
Hi I am new to SQLAlchemy, I am trying to extract from reflected tables: 1. the column name of the current table 2. the referred table name and 3. the column name of the referred table now I can manage to do this using (and for sake only using first forein key) *metadata =