X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI%2FSQLite.pm;h=b7532643c2c0572ed7201309f6da42f0a1907864;hb=e42ec4ef998118c71f8bd66e765f597a6f74dd39;hp=3998fe8ce2db1268a7598abdc50d6fa2beca19ab;hpb=78b7ccaaaff070d6053dda2843007369d7501662;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 3998fe8..b753264 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI/SQLite.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI/SQLite.pm @@ -2,12 +2,15 @@ package DBIx::Class::Schema::Loader::DBI::SQLite; use strict; use warnings; -use base qw/DBIx::Class::Schema::Loader::DBI/; +use base qw/ + DBIx::Class::Schema::Loader::DBI::Component::QuotedDefault + DBIx::Class::Schema::Loader::DBI +/; use Carp::Clan qw/^DBIx::Class/; use Text::Balanced qw( extract_bracketed ); use Class::C3; -our $VERSION = '0.04999_01'; +our $VERSION = '0.05003'; =head1 NAME @@ -63,7 +66,7 @@ sub _sqlite_parse_table { $sth->finish; # Cut "CREATE TABLE ( )" blabla... - $sql =~ /^[\w\s']+\((.*)\)$/si; + $sql =~ /^[\w\s"]+\((.*)\)$/si; my $cols = $1; # strip single-line comments @@ -116,7 +119,7 @@ sub _sqlite_parse_table { $auto_inc{lc $1} = 1; } - next if $col !~ /^(.*\S)\s+REFERENCES\s+(\w+) (?: \s* \( (.*) \) )? /ix; + next if $col !~ /^(.*\S)\s+REFERENCES\s+(\w+) (?: \s* \( (.*) \) )? /six; my ($cols, $f_table, $f_cols) = ($1, $2, $3); @@ -125,7 +128,7 @@ sub _sqlite_parse_table { $cols =~ s/\s*\)$//; } else { # Inline - $cols =~ s/\s+.*$//; + $cols =~ s/\s+.*$//s; } my @cols = map { s/\s*//g; lc $_ } split(/\s*,\s*/,$cols); @@ -146,13 +149,19 @@ sub _sqlite_parse_table { return { rels => \@rels, uniqs => \@uniqs, auto_inc => \%auto_inc }; } -sub _column_is_auto_increment { +sub _extra_column_info { my ($self, $table, $col_name, $sth, $col_num) = @_; - + ($table, $col_name) = @{$table}{qw/TABLE_NAME COLUMN_NAME/} if ref $table; + my %extra_info; + $self->{_sqlite_parse_data}->{$table} ||= $self->_sqlite_parse_table($table); - return $self->{_sqlite_parse_data}->{$table}->{auto_inc}->{$col_name}; + if ($self->{_sqlite_parse_data}->{$table}->{auto_inc}->{$col_name}) { + $extra_info{is_auto_increment} = 1; + } + + return \%extra_info; } sub _table_fk_info { @@ -194,6 +203,15 @@ sub _tables_list { L, L, L +=head1 AUTHOR + +See L and L. + +=head1 LICENSE + +This library is free software; you can redistribute it and/or modify it under +the same terms as Perl itself. + =cut 1;