some details here: http://www.sqlalchemy.org/docs/reference/dialects/sqlite.html#auto-incrementing-beahvior
basically SQLite can't autoincrement with a composite PK. On Feb 22, 2010, at 11:40 AM, chicklin wrote: > I'm using sqlite and defining my tables using declaritive_base and I > have a composite primary key on one table. I need to specify that one > of the columns (an Integer) generate the id's automatically. > autoincrement=True does not work for sqlite and I don't know where to > define sqlite_autoincrement=True when using declaritive_base. All the > examples and documentation show it as an argument to Table(). Any > ideas? Thanks in advance. > >>>> sqlalchemy.__version__ > '0.6beta1' > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
