X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI%2FSQLite.pm;h=9ebeede1f3ed979865c8a661fe1dd1fac2841b51;hb=bc1cb85e84e6a30c75763edd478378a68009c722;hp=24a2ba190fbad9b10c05510ed29120d2c4ccb279;hpb=26da4cc31819b6644891dd1c6da9bc7c9d5b40b9;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/DBI/SQLite.pm b/lib/DBIx/Class/Schema/Loader/DBI/SQLite.pm index 24a2ba1..9ebeede 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI/SQLite.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI/SQLite.pm @@ -10,38 +10,38 @@ use Carp::Clan qw/^DBIx::Class/; use Text::Balanced qw( extract_bracketed ); use Class::C3; -our $VERSION = '0.05003'; +our $VERSION = '0.07000'; =head1 NAME DBIx::Class::Schema::Loader::DBI::SQLite - DBIx::Class::Schema::Loader::DBI SQLite Implementation. -=head1 SYNOPSIS - - package My::Schema; - use base qw/DBIx::Class::Schema::Loader/; - - __PACKAGE__->loader_options( debug => 1 ); - - 1; - =head1 DESCRIPTION -See L. +See L and L. =head1 METHODS =head2 rescan -SQLite will fail all further commands on a connection if the -underlying schema has been modified. Therefore, any runtime -changes requiring C also require us to re-connect -to the database. The C method here handles that -reconnection for you, but beware that this must occur for -any other open sqlite connections as well. +SQLite will fail all further commands on a connection if the underlying schema +has been modified. Therefore, any runtime changes requiring C also +require us to re-connect to the database. The C method here handles +that reconnection for you, but beware that this must occur for any other open +sqlite connections as well. =cut +sub _setup { + my $self = shift; + + $self->next::method(@_); + + if (not defined $self->preserve_case) { + $self->preserve_case(0); + } +} + sub rescan { my ($self, $schema) = @_; @@ -91,14 +91,14 @@ sub _table_fk_info { my $rel = $rels[ $fk->{id} ] ||= { local_columns => [], remote_columns => undef, - remote_table => lc $fk->{table} + remote_table => $fk->{table} }; - push @{ $rel->{local_columns} }, lc $fk->{from}; - push @{ $rel->{remote_columns} }, lc $fk->{to} if defined $fk->{to}; + push @{ $rel->{local_columns} }, $self->_lc($fk->{from}); + push @{ $rel->{remote_columns} }, $self->_lc($fk->{to}) if defined $fk->{to}; warn "This is supposed to be the same rel but remote_table changed from ", $rel->{remote_table}, " to ", $fk->{table} - if $rel->{remote_table} ne lc $fk->{table}; + if $rel->{remote_table} ne $fk->{table}; } $sth->finish; return \@rels; @@ -122,7 +122,7 @@ sub _table_uniq_info { $get_idx_sth->execute; my @cols; while (my $idx_row = $get_idx_sth->fetchrow_hashref) { - push @cols, lc $idx_row->{name}; + push @cols, $self->_lc($idx_row->{name}); } $get_idx_sth->finish; push @uniqs, [ $name => \@cols ]; @@ -132,7 +132,7 @@ sub _table_uniq_info { } sub _tables_list { - my $self = shift; + my ($self, $opts) = @_; my $dbh = $self->schema->storage->dbh; my $sth = $dbh->prepare("SELECT * FROM sqlite_master"); @@ -144,7 +144,7 @@ sub _tables_list { push @tables, $row->{tbl_name}; } $sth->finish; - return $self->_filter_tables(@tables); + return $self->_filter_tables(\@tables, $opts); } =head1 SEE ALSO