SQLAlchemy doesn't seem to generate "INTEGER PRIMARY KEY AUTOINCREMENT" column in sqlite, even though the Column has autoincrement=True. According to sqlite website[1], if the AUTOINCREMENT keyword is set, it will use an actual sequence, otherwise it will just grab the largest id + 1. The later behavior caused one of our unit test to fail, and due to our unfamiliarity with SA/sqlite, we spent hours to uncover the cause of the problem. It will be great if SA can set the AUTOINCREMENT keyword in sqlite if the autoincrement argument is set to True.
Regards, Yap [1] http://www.sqlite.org/autoinc.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---