Re: [sqlalchemy] ORM and table with no primary key

2016-10-17 Thread Seth P
On Monday, October 17, 2016 at 3:58:36 PM UTC-4, Mike Bayer wrote: > > that error is there right now because we don't emit the "col IS NULL" > SQL within that section of the persistence code. > > took me a long time to find the history on this because I thought it had > been discussed but looks

Re: [sqlalchemy] ORM and table with no primary key

2016-10-17 Thread Mike Bayer
On 10/17/2016 03:36 PM, Seth P wrote: I realize that the orm really wants/needs a table to have a primary key: http://docs.sqlalchemy.org/en/rel_1_1/faq/ormconfiguration.html?#how-do-i-map-a-table-that-has-no-primary-key Alas I have to deal with an existing table with no primary key. That

[sqlalchemy] ORM and table with no primary key

2016-10-17 Thread Seth P
I realize that the orm really wants/needs a table to have a primary key: http://docs.sqlalchemy.org/en/rel_1_1/faq/ormconfiguration.html?#how-do-i-map-a-table-that-has-no-primary-key Alas I have to deal with an existing table with no primary key. That said, it does have a unique constraint on a