1 package DBIx::Class::Schema::Loader::DBI::SQLite;
6 DBIx::Class::Schema::Loader::DBI::Component::QuotedDefault
7 DBIx::Class::Schema::Loader::DBI
9 use Carp::Clan qw/^DBIx::Class/;
10 use Text::Balanced qw( extract_bracketed );
13 our $VERSION = '0.05003';
17 DBIx::Class::Schema::Loader::DBI::SQLite - DBIx::Class::Schema::Loader::DBI SQLite Implementation.
22 use base qw/DBIx::Class::Schema::Loader/;
24 __PACKAGE__->loader_options( debug => 1 );
30 See L<DBIx::Class::Schema::Loader::Base>.
36 SQLite will fail all further commands on a connection if the
37 underlying schema has been modified. Therefore, any runtime
38 changes requiring C<rescan> also require us to re-connect
39 to the database. The C<rescan> method here handles that
40 reconnection for you, but beware that this must occur for
41 any other open sqlite connections as well.
46 my ($self, $schema) = @_;
48 $schema->storage->disconnect if $schema->storage;
49 $self->next::method($schema);
52 sub _extra_column_info {
53 my ($self, $table, $col_name, $sth, $col_num) = @_;
54 ($table, $col_name) = @{$table}{qw/TABLE_NAME COLUMN_NAME/} if ref $table;
57 my $dbh = $self->schema->storage->dbh;
58 my $has_autoinc = eval {
59 my $get_seq = $self->{_cache}->{sqlite_sequence}
60 ||= $dbh->prepare(q{SELECT count(*) FROM sqlite_sequence WHERE name = ?});
61 $get_seq->execute($table);
62 my ($ret) = $get_seq->fetchrow_array;
67 if (!$@ && $has_autoinc) {
68 my $sth = $dbh->prepare(
69 "pragma table_info(" . $dbh->quote_identifier($table) . ")"
72 my $cols = $sth->fetchall_hashref('name');
73 if ($cols->{$col_name}{pk}) {
74 $extra_info{is_auto_increment} = 1;
82 my ($self, $table) = @_;
84 my $dbh = $self->schema->storage->dbh;
85 my $sth = $dbh->prepare(
86 "pragma foreign_key_list(" . $dbh->quote_identifier($table) . ")"
91 while (my $fk = $sth->fetchrow_hashref) {
92 my $rel = $rels[ $fk->{id} ] ||= {
94 remote_columns => undef,
95 remote_table => lc $fk->{table}
98 push @{ $rel->{local_columns} }, lc $fk->{from};
99 push @{ $rel->{remote_columns} }, lc $fk->{to} if defined $fk->{to};
100 warn "This is supposed to be the same rel but remote_table changed from ",
101 $rel->{remote_table}, " to ", $fk->{table}
102 if $rel->{remote_table} ne lc $fk->{table};
108 sub _table_uniq_info {
109 my ($self, $table) = @_;
111 my $dbh = $self->schema->storage->dbh;
112 my $sth = $dbh->prepare(
113 "pragma index_list(" . $dbh->quote($table) . ")"
118 while (my $idx = $sth->fetchrow_hashref) {
119 next unless $idx->{unique};
120 my $name = $idx->{name};
122 my $get_idx_sth = $dbh->prepare("pragma index_info(" . $dbh->quote($name) . ")");
123 $get_idx_sth->execute;
125 while (my $idx_row = $get_idx_sth->fetchrow_hashref) {
126 push @cols, lc $idx_row->{name};
128 $get_idx_sth->finish;
129 push @uniqs, [ $name => \@cols ];
138 my $dbh = $self->schema->storage->dbh;
139 my $sth = $dbh->prepare("SELECT * FROM sqlite_master");
142 while ( my $row = $sth->fetchrow_hashref ) {
143 next unless lc( $row->{type} ) eq 'table';
144 next if $row->{tbl_name} =~ /^sqlite_/;
145 push @tables, $row->{tbl_name};
153 L<DBIx::Class::Schema::Loader>, L<DBIx::Class::Schema::Loader::Base>,
154 L<DBIx::Class::Schema::Loader::DBI>
158 See L<DBIx::Class::Schema::Loader/AUTHOR> and L<DBIx::Class::Schema::Loader/CONTRIBUTORS>.
162 This library is free software; you can redistribute it and/or modify it under
163 the same terms as Perl itself.