See L<DBIx::Class::Schema::Loader::Base>.
+=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<rescan> also require us to re-connect
+to the database. The C<rescan> method here handles that
+reconnection for you, but beware that this must occur for
+any other open sqlite connections as well.
+
=cut
+sub rescan {
+ my ($self, $schema) = @_;
+
+ $schema->storage->disconnect if $schema->storage;
+ $self->next::method($schema);
+}
+
# XXX this really needs a re-factor
sub _sqlite_parse_table {
my ($self, $table) = @_;
# Grab reference
chomp $col;
- if($col =~ /^(.*)\s+UNIQUE/) {
+ if($col =~ /^(.*)\s+UNIQUE/i) {
my $colname = $1;
$colname =~ s/\s+.*$//;
push(@uniqs, [ "${colname}_unique" => [ lc $colname ] ]);
}
- elsif($col =~/^\s*UNIQUE\s*\(\s*(.*)\)/) {
+ elsif($col =~/^\s*UNIQUE\s*\(\s*(.*)\)/i) {
my $cols = $1;
$cols =~ s/\s+$//;
my @cols = map { lc } split(/\s*,\s*/, $cols);
next unless lc( $row->{type} ) eq 'table';
push @tables, $row->{tbl_name};
}
+ $sth->finish;
return @tables;
}