I am having problems getting a list of table classes
using automap_base when the table has a composite primary key.
Not sure if this is the intended behaviour.
When I try to get the list tables classes using automap_base,
I only get tables 'a' and 'b' below and not table 'ab'.
This is using sqlalchemy 1.2.15.
This example was tested with sqlite3 but I get the same issue with Postgres
Here is the schema:
CREATE TABLE a (
id INTEGER,
PRIMARY KEY(id)
);
CREATE TABLE b (
id INTEGER,
PRIMARY KEY(id)
);
CREATE TABLE ab (
a_id INTEGER NOT NULL,
b_id INTEGER NOT NULL,
FOREIGN KEY(a_id) REFERENCES a(id),
FOREIGN KEY(b_id) REFERENCES b(id),
PRIMARY KEY (a_id, b_id)
);
Base = automap_base()
engine = create_engine("sqlite:///mydb.db")
Base.prepare(engine, reflect=True)
print ('classes {}'.format(Base.classes.keys()))
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
