[sqlalchemy] three primary keys on association object

2010-03-05 Thread Sebastian Elsner
Hello, I have an association object declaratively with three primary keys, but on insert, the first (id) is not autoincremented. Please see test the code below from sqlalchemy import create_engine, Column,Integer, String, ForeignKey from sqlalchemy.ext.declarative import

Re: [sqlalchemy] three primary keys on association object

2010-03-05 Thread Michael Bayer
Sebastian Elsner wrote: Hello, I have an association object declaratively with three primary keys, but on insert, the first (id) is not autoincremented. Please see test the code below known sqlite limitation, described at

Re: [sqlalchemy] three primary keys on association object

2010-03-05 Thread Michael Bayer
Michael Bayer wrote: Sebastian Elsner wrote: Hello, I have an association object declaratively with three primary keys, but on insert, the first (id) is not autoincremented. Please see test the code below known sqlite limitation, described at

Re: [sqlalchemy] three primary keys on association object

2010-03-05 Thread Sebastian Elsner
Oh, thanks for the pointer. There's so much to read and learn being new to SQLAlchemy... Sorry for bugging. On Fri, 05 Mar 2010 15:49:03 +0100, Michael Bayer mike...@zzzcomputing.com wrote: Sebastian Elsner wrote: Hello, I have an association object declaratively with three primary