Re: Autoincrement support for Sqlite3

On Fri, 27 Sep 2013 19:42:52 +0300, Victor <[email protected]> wrote:

> Hi,
>
> Thanks a lot for creating such a wonderful and useful library.
>
> However, lack of autoincrement fields support for Sqlite3 databases is very inconvenient.
>
> I wanted to share a patch (partially it was submitted before) that makes it possible to work with autoincrement fields in Sqlite3 with clsql.
>
> Additional modifications might be necessary, but this patch at least makes it possible to insert objects into the database.
>
> I hope that CLSQL will have a full support for autoincrement fields in the Sqlite3 databases.


These modifications are not enough: the way how CLSQL creates tables is also important as it does not work with Sqlite3 when there are Autoincrement fields.

The problem is that CLSQL tries to define primary keys also in the end of the columns list as a kind of constraints.

Thanks,
Victor