5 use Test::More tests => 5;
13 my ( $dsn, $user, $pass )
14 = @ENV{ map {"DBICTEST_PG_${_}"} qw/DSN USER PASS/ };
16 plan skip_all => <<'EOM' unless $dsn && $user;
17 Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
18 ( NOTE: This test drops and creates some tables.')
21 dies_ok { LoadTest->source('Foo')->view_definition }
22 "Can't generate view def without connected schema";
24 my $schema = LoadTest->connect( $dsn, $user, $pass );
25 $schema->storage->ensure_connected;
26 $schema->storage->dbh->{Warn} = 0;
28 my $dir = "t/sql"; # tempdir(CLEANUP => 0);
30 lives_ok { $schema->create_ddl_dir( ['PostgreSQL'], 0.1, $dir ) }
31 "It's OK to create_ddl_dir";
33 $schema->deploy( { add_drop_table => 1, add_drop_view => 1, } );
35 "It's also OK to deploy the schema";
38 $schema->source('Bar'),
39 'DBIx::Class::ResultSource::View',
43 my $sqlt_object = $schema->{sqlt};
46 [ map { $_->name } $sqlt_object->get_views ],
52 "SQLT view order triumphantly matches our order."