NAME

DBIx::Migration::Directories::Database::SQLite2 - Handle quirks with DBD::SQLite2

SYNOPSIS

my $dbh = DBIx::Transaction->connect('DBI:SQLite2:my_database');

my $migration = DBIx::Migration::Directories->new(
  dbh     => $dbh,
  schema  => 'MySchema',
  ...
);

DESCRIPTION

The following methods had to be written differently so that they behave properly under SQLite2:

sql_table_exists($table)

See "sql_table_exists" in DBIx::Migration::Directories::Base.

SQLite2 does not support the SQL standard "information_schema". This sql_table_exists method instead uses SQLite2's custom "sqlite_master" meta-table to verify the existance of a table.

sql_insert_migration_schema_log()

See "sql_insert_migration_schema_log" in DBIx::Migration::Directories::Base.

SQLite2 does not supply a now() function to retrieve the current time, so this query has been modified to compensate.

AUTHOR

Tyler "Crackerjack" MacDonald <japh@crackerjack.net>

LICENSE

Copyright 2009 Tyler "Crackerjack" MacDonald <japh@crackerjack.net>

This is free software; You may distribute it under the same terms as perl itself.

SEE ALSO

DBIx::Migration::Directories, DBD::mysql