1 package DBIx::Class::Schema::Loader::DBI::SQLite;
5 use base 'DBIx::Class::Schema::Loader::DBI::Component::QuotedDefault';
7 use DBIx::Class::Schema::Loader::Table ();
9 our $VERSION = '0.07022';
13 DBIx::Class::Schema::Loader::DBI::SQLite - DBIx::Class::Schema::Loader::DBI SQLite Implementation.
17 See L<DBIx::Class::Schema::Loader> and L<DBIx::Class::Schema::Loader::Base>.
23 SQLite will fail all further commands on a connection if the underlying schema
24 has been modified. Therefore, any runtime changes requiring C<rescan> also
25 require us to re-connect to the database. The C<rescan> method here handles
26 that reconnection for you, but beware that this must occur for any other open
27 sqlite connections as well.
34 $self->next::method(@_);
36 if (not defined $self->preserve_case) {
37 $self->preserve_case(0);
40 if ($self->db_schema) {
42 db_schema is not supported on SQLite, the option is implemented only for qualify_objects testing.
44 if ($self->db_schema->[0] eq '%') {
45 $self->db_schema(undef);
51 my ($self, $schema) = @_;
53 $schema->storage->disconnect if $schema->storage;
54 $self->next::method($schema);
57 sub _columns_info_for {
61 my $result = $self->next::method(@_);
63 local $self->dbh->{FetchHashKeyName} = 'NAME_lc';
65 my $sth = $self->dbh->prepare(
66 "pragma table_info(" . $self->dbh->quote_identifier($table) . ")"
69 my $cols = $sth->fetchall_hashref('name');
71 # copy and case according to preserve_case mode
72 # no need to check for collisions, SQLite does not allow them
74 while (my ($col, $info) = each %$cols) {
75 $cols{ $self->_lc($col) } = $info;
78 my ($num_pk, $pk_col) = (0);
79 # SQLite doesn't give us the info we need to do this nicely :(
80 # If there is exactly one column marked PK, and its type is integer,
81 # set it is_auto_increment. This isn't 100%, but it's better than the
83 while (my ($col_name, $info) = each %$result) {
84 if ($cols{$col_name}{pk}) {
86 if (lc($cols{$col_name}{type}) eq 'integer') {
92 while (my ($col, $info) = each %$result) {
93 if ((eval { ${ $info->{default_value} } }||'') eq 'CURRENT_TIMESTAMP') {
94 ${ $info->{default_value} } = 'current_timestamp';
96 if ($num_pk == 1 and defined $pk_col and $pk_col eq $col) {
97 $info->{is_auto_increment} = 1;
105 my ($self, $table) = @_;
107 my $sth = $self->dbh->prepare(
108 "pragma foreign_key_list(" . $self->dbh->quote_identifier($table) . ")"
113 while (my $fk = $sth->fetchrow_hashref) {
114 my $rel = $rels[ $fk->{id} ] ||= {
116 remote_columns => undef,
117 remote_table => DBIx::Class::Schema::Loader::Table->new(
119 name => $fk->{table},
120 ($self->db_schema ? (
121 schema => $self->db_schema->[0],
127 push @{ $rel->{local_columns} }, $self->_lc($fk->{from});
128 push @{ $rel->{remote_columns} }, $self->_lc($fk->{to}) if defined $fk->{to};
129 warn "This is supposed to be the same rel but remote_table changed from ",
130 $rel->{remote_table}->name, " to ", $fk->{table}
131 if $rel->{remote_table}->name ne $fk->{table};
137 sub _table_uniq_info {
138 my ($self, $table) = @_;
140 my $sth = $self->dbh->prepare(
141 "pragma index_list(" . $self->dbh->quote($table) . ")"
146 while (my $idx = $sth->fetchrow_hashref) {
147 next unless $idx->{unique};
149 my $name = $idx->{name};
151 my $get_idx_sth = $self->dbh->prepare("pragma index_info(" . $self->dbh->quote($name) . ")");
152 $get_idx_sth->execute;
154 while (my $idx_row = $get_idx_sth->fetchrow_hashref) {
155 push @cols, $self->_lc($idx_row->{name});
157 $get_idx_sth->finish;
159 # Rename because SQLite complains about sqlite_ prefixes on identifiers
160 # and ignores constraint names in DDL.
161 $name = (join '_', @cols) . '_unique';
163 push @uniqs, [ $name => \@cols ];
170 my ($self, $opts) = @_;
172 my $sth = $self->dbh->prepare("SELECT * FROM sqlite_master");
175 while ( my $row = $sth->fetchrow_hashref ) {
176 next unless $row->{type} =~ /^(?:table|view)\z/i;
177 next if $row->{tbl_name} =~ /^sqlite_/;
178 push @tables, DBIx::Class::Schema::Loader::Table->new(
180 name => $row->{tbl_name},
181 ($self->db_schema ? (
182 schema => $self->db_schema->[0],
183 ignore_schema => 1, # for qualify_objects tests
188 return $self->_filter_tables(\@tables, $opts);
193 L<DBIx::Class::Schema::Loader>, L<DBIx::Class::Schema::Loader::Base>,
194 L<DBIx::Class::Schema::Loader::DBI>
198 See L<DBIx::Class::Schema::Loader/AUTHOR> and L<DBIx::Class::Schema::Loader/CONTRIBUTORS>.
202 This library is free software; you can redistribute it and/or modify it under
203 the same terms as Perl itself.