X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FDBI.pm;h=0eef7aad8ad6946fe9ce5aaa91e3795954681b54;hb=df956aad09bce14245ebcbd13063ca2119b6c042;hp=a9d716182dfe67ad7ea073666c3c4d59b2188d34;hpb=f30ddf1578c8c2995ee6bdd5286b1060a7a9b5ad;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/DBI.pm b/lib/DBIx/Class/Schema/Loader/DBI.pm index a9d7161..0eef7aa 100644 --- a/lib/DBIx/Class/Schema/Loader/DBI.pm +++ b/lib/DBIx/Class/Schema/Loader/DBI.pm @@ -284,10 +284,10 @@ sub _columns_info_for { my $sth = $dbh->column_info( undef, $self->db_schema, $table, '%' ); while ( my $info = $sth->fetchrow_hashref() ){ my $column_info = {}; - $column_info->{data_type} = $info->{TYPE_NAME}; - $column_info->{size} = $info->{COLUMN_SIZE}; + $column_info->{data_type} = $info->{TYPE_NAME}; + $column_info->{size} = $info->{COLUMN_SIZE} if defined $info->{COLUMN_SIZE}; $column_info->{is_nullable} = $info->{NULLABLE} ? 1 : 0; - $column_info->{default_value} = $info->{COLUMN_DEF}; + $column_info->{default_value} = $info->{COLUMN_DEF} if defined $info->{COLUMN_DEF}; my $col_name = $info->{COLUMN_NAME}; $col_name =~ s/^\"(.*)\"$/$1/; @@ -310,7 +310,7 @@ sub _columns_info_for { for my $i ( 0 .. $#columns ){ my $column_info = {}; $column_info->{data_type} = $sth->{TYPE}->[$i]; - $column_info->{size} = $sth->{PRECISION}->[$i]; + $column_info->{size} = $sth->{PRECISION}->[$i] if $sth->{PRECISION}->[$i]; $column_info->{is_nullable} = $sth->{NULLABLE}->[$i] ? 1 : 0; if ($column_info->{data_type} =~ m/^(.*?)\((.*?)\)$/) {