[ACCEPTED]-SQLAlchemy Automap does not create class for tables without primary key-sqlalchemy

Accepted answer

Score: 51

Figured it out by combing through the reference/reframing 5 the problem.

In case it helps someone else 4 -

Because SQLAlchemy ORM is based on an identity 3 map model, one cannot map (or automap) a 2 table that does not have a primary key. An 1 arbitrary primary key should be specified.

http://docs.sqlalchemy.org/en/latest/faq/ormconfiguration.html#how-do-i-map-a-table-that-has-no-primary-key

Source: stackoverflow.com

How to find out if a lazy relation isn't loaded yet, with SQLAlchemy?

How to discover table properties from SQLAlchemy mapped object

How to construct a slightly more complex filter using "or_" or "and_" in SQLAlchemy

Creating a tree from self referential tables in SQLalchemy

Setting delete-orphan on SQLAlchemy relationship causes AssertionError: This AttributeImpl is not configured to track parents

SQLAlchemy alphabetical ordering query

Can SQLAlchemy events be used to update a denormalized data cache?

How to apply Column defaults before a commit in sqlalchemy

Can SQLAlchemy automatically create relationships from a database schema?

Generic way to get primary key from declaratively defined instance in SQLAlchemy

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.