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