CC: | rporres [...] qindel.com |
Subject: | SQLite Generator does not correctly handle AUTOINCREMENT in primary keys |
SQLite generator doesn't do anything with autoincrement in primary keys.
Trying to generate a table with this code:
my $table = SQL::Translator::Schema::Table->new(
name => 'foo_auto_increment',
);
$table->add_field(
name => 'id',
data_type => 'integer',
is_nullable => 0,
is_auto_increment => 1,
);
$table->primary_key('id');
would create an "id" row such as
"id" INTEGER PRIMARY KEY NOT NULL
instead of
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
as expected.
The difference of each is well explained in SQLite docs:
http://www.sqlite.org/autoinc.html
There's a pull request in GitHub:
https://github.com/dbsrgits/sql-translator/pull/26
Best Regards,
Rafael Porres
PS. Thanks a lot for the __AWESOME__ work in SQL::Translator. It's been extremely helpful.