3 use dbixcsl_common_tests;
6 my $dsn = $ENV{DBICTEST_PG_DSN} || '';
7 my $user = $ENV{DBICTEST_PG_USER} || '';
8 my $password = $ENV{DBICTEST_PG_PASS} || '';
10 my $tester = dbixcsl_common_tests->new(
12 auto_inc_pk => 'SERIAL NOT NULL PRIMARY KEY',
15 password => $password,
19 CREATE TABLE pg_loader_test1 (
20 id SERIAL NOT NULL PRIMARY KEY,
25 COMMENT ON TABLE pg_loader_test1 IS 'The Table'
28 COMMENT ON COLUMN pg_loader_test1.value IS 'The Column'
31 drop => [ qw/ pg_loader_test1 / ],
34 my ($schema, $monikers, $classes) = @_;
36 my $class = $classes->{pg_loader_test1};
37 my $filename = $schema->_loader->_get_dump_filename($class);
40 local ($/, @ARGV) = (undef, $filename);
44 like $code, qr/^=head1 NAME\n\n^$class - The Table\n\n^=cut\n/m,
47 like $code, qr/^=head2 value\n\nThe Column\n\n/m,
53 if( !$dsn || !$user ) {
54 $tester->skip_tests('You need to set the DBICTEST_PG_DSN, _USER, and _PASS environment variables');