X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI%2Fmysql.pm;h=6e9554f967015055e9d399f3a48d82927020cb98;hb=c697835eacc34e76036a6e91cc4b0bc1ccd05f69;hp=1eb9107255b990f3775516bec01e90d52068f706;hpb=33aa346253f9628fea4a9ac427048b544cd91463;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/DBI/mysql.pm b/lib/DBIx/Class/Schema/Loader/DBI/mysql.pm index 1eb9107..6e9554f 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI/mysql.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI/mysql.pm @@ -4,9 +4,9 @@ use strict; use warnings; use base 'DBIx::Class::Schema::Loader::DBI'; use Carp::Clan qw/^DBIx::Class/; -use Class::C3; +use mro 'c3'; -our $VERSION = '0.07000'; +our $VERSION = '0.07005'; =head1 NAME @@ -145,6 +145,7 @@ sub _columns_info_for { $info->{data_type} = 'double precision'; } + # information_schema is available in 5.0+ my ($precision, $scale, $column_type, $default) = eval { $dbh->selectrow_array(<<'EOF', {}, $table, $col) }; SELECT numeric_precision, numeric_scale, column_type, column_default FROM information_schema.columns @@ -175,6 +176,11 @@ EOF delete $info->{size}; } } + elsif ($info->{data_type} =~ /^(?:date(?:time)?|timestamp)\z/) { + if (not (defined $self->datetime_undef_if_invalid && $self->datetime_undef_if_invalid == 0)) { + $info->{datetime_undef_if_invalid} = 1; + } + } # Sometimes apparently there's a bug where default_value gets set to '' # for things that don't actually have or support that default (like ints.) @@ -217,6 +223,15 @@ sub _extra_column_info { return \%extra_info; } +sub _dbh_column_info { + my $self = shift; + + local $SIG{__WARN__} = sub { warn @_ + unless $_[0] =~ /^column_info: unrecognized column type/ }; + + $self->next::method(@_); +} + =head1 SEE ALSO L, L,