X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Frun%2F12pg.tl;h=ee3e819d99df65ec23d266036c087be9a18c8a31;hb=fc22fbac7c99f1ee8a52e529a6ce4ee35fd5d4a9;hp=5ffef5c4be8c80924fcc3ed3470ce79a044a3939;hpb=1346e22d4899edf837c77312259c3ebaaf71f602;p=dbsrgits%2FDBIx-Class.git diff --git a/t/run/12pg.tl b/t/run/12pg.tl index 5ffef5c..ee3e819 100644 --- a/t/run/12pg.tl +++ b/t/run/12pg.tl @@ -8,7 +8,7 @@ my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_PG_${_}" } qw/DSN USER PASS/}; plan skip_all, 'Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test' . ' (note: creates and drops a table named artist!)' unless ($dsn && $user); -plan tests => 3; +plan tests => 4; DBICTest::Schema->compose_connection('PgTest' => $dsn, $user, $pass); @@ -30,22 +30,30 @@ my $test_type_info = { 'artistid' => { 'data_type' => 'integer', 'is_nullable' => 0, - 'size' => 4 + 'size' => 4, }, 'name' => { 'data_type' => 'character varying', 'is_nullable' => 1, - 'size' => 255 + 'size' => 255, + 'default_value' => undef, }, 'charfield' => { 'data_type' => 'character', 'is_nullable' => 1, - 'size' => 10 + 'size' => 10, + 'default_value' => undef, }, }; + my $type_info = PgTest->schema->storage->columns_info_for('artist'); -is_deeply($type_info, $test_type_info, 'columns_info_for - column data types'); +my $artistid_defval = delete $type_info->{artistid}->{default_value}; +like($artistid_defval, + qr/^nextval\('public\.artist_artistid_seq'::(?:text|regclass)\)/, + 'columns_info_for - sequence matches Pg get_autoinc_seq expectations'); +is_deeply($type_info, $test_type_info, + 'columns_info_for - column data types'); $dbh->do("DROP TABLE artist;");