X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Frun%2F12pg.tl;h=ee3e819d99df65ec23d266036c087be9a18c8a31;hb=5faa95affd5bb016d0fa81f7f99411ce4db5ff08;hp=22c4008a859eb040ba89a5bc72aebd4c5e82483a;hpb=103e3e038c76f0665051b5f9aeabee2e888c8a15;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/run/12pg.tl b/t/run/12pg.tl index 22c4008..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); @@ -16,7 +16,7 @@ my $dbh = PgTest->schema->storage->dbh; $dbh->do("CREATE TABLE artist (artistid serial PRIMARY KEY, name VARCHAR(255), charfield CHAR(10));"); -PgTest::Artist->load_components('PK::Auto::Pg'); +PgTest::Artist->load_components('PK::Auto'); my $new = PgTest::Artist->create({ name => 'foo' }); @@ -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;");