SQLAlchemy: Reflect and Automap Tables with Composite Primary Key

Asked Apr 17 '18 at 01:06

Active Jul 02 '18 at 19:08

Viewed 501 times

I'm trying to reflect and automap some tables in sqlalchemy that have composite primary keys from an Oracle db. When I run

metadata = MetaData()
metadata.reflect(bind=engine, schema='USER')
Base = automap_base(metadata=metadata)
Base.prepare()
print(list(Base.classes))

I get a list of the tables that have primary keys in the database, and not the ones that don't. I know that you can manually map tables with composite primary keys (http://docs.sqlalchemy.org/en/latest/faq/ormconfiguration.html), but is there a way to feed the two keys that make up the composite primary key to the reflection for automapping?

edited Apr 17 '18 at 02:27

asked Apr 17 '18 at 01:06

Austin Mckay

I am also keen to know the answer here. – Sledge Jul 26 '18 at 14:50
Now, this composite primary key is supported in Automap Base. I evaluated by print(list(Base.classes)) and it was able to map it. – Mohit Kumar Aug 12 '20 at 03:14

SQLAlchemy: Reflect and Automap Tables with Composite Primary Key

0 Answers0