X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FStorage%2FDBI%2FSQLite.pm;h=95122b1edabfe13453d82f7d5e93273dc2453518;hb=f200d74b;hp=15dcc014a10d44672ef7c88239f6b062bb44861e;hpb=b06b20f52e603a12e463eba4a0b4200fcd85f3e9;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Storage/DBI/SQLite.pm b/lib/DBIx/Class/Storage/DBI/SQLite.pm index 15dcc01..95122b1 100644 --- a/lib/DBIx/Class/Storage/DBI/SQLite.pm +++ b/lib/DBIx/Class/Storage/DBI/SQLite.pm @@ -2,12 +2,14 @@ package DBIx::Class::Storage::DBI::SQLite; use strict; use warnings; + +use base qw/DBIx::Class::Storage::DBI/; +use mro 'c3'; + use POSIX 'strftime'; use File::Copy; use File::Spec; -use base qw/DBIx::Class::Storage::DBI::MultiDistinctEmulation/; - sub _dbh_last_insert_id { my ($self, $dbh, $source, $col) = @_; $dbh->func('last_insert_rowid'); @@ -19,7 +21,7 @@ sub backup $dir ||= './'; ## Where is the db file? - my $dsn = $self->connect_info()->[0]; + my $dsn = $self->_dbi_connect_info()->[0]; my $dbname = $1 if($dsn =~ /dbname=([^;]+)/); if(!$dbname) @@ -33,7 +35,7 @@ sub backup # my $dbfile = file($dbname); my ($vol, $dbdir, $file) = File::Spec->splitpath($dbname); # my $file = $dbfile->basename(); - $file = strftime("%y%m%d%h%M%s", localtime()) . $file; + $file = strftime("%Y-%m-%d-%H_%M_%S", localtime()) . $file; $file = "B$file" while(-f $file); mkdir($dir) unless -f $dir; @@ -45,17 +47,34 @@ sub backup return $backupfile; } +sub deployment_statements { + my $self = shift;; + my ($schema, $type, $version, $dir, $sqltargs, @rest) = @_; + + $sqltargs ||= {}; + + my $sqlite_version = $self->_get_dbh->{sqlite_version}; + + # numify, SQLT does a numeric comparison + $sqlite_version =~ s/^(\d+) \. (\d+) (?: \. (\d+))? .*/${1}.${2}/x; + + $sqltargs->{producer_args}{sqlite_version} = $sqlite_version; + + $self->next::method($schema, $type, $version, $dir, $sqltargs, @rest); +} + +sub datetime_parser_type { return "DateTime::Format::SQLite"; } 1; =head1 NAME -DBIx::Class::PK::Auto::SQLite - Automatic primary key class for SQLite +DBIx::Class::Storage::DBI::SQLite - Automatic primary key class for SQLite =head1 SYNOPSIS # In your table classes - __PACKAGE__->load_components(qw/PK::Auto Core/); + use base 'DBIx::Class::Core'; __PACKAGE__->set_primary_key('id'); =head1 DESCRIPTION