4 use Test::More qw(no_plan);
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 my $schema = NoSequence->connect( $dsn, $user, $pass );
22 $schema->storage->dbh->{Warn} = 0;
23 $schema->storage->ensure_connected;
24 $schema->storage->_use_insert_returning(0);
26 my $dir = "t/sql"; # tempdir(CLEANUP => 0);
27 $schema->create_ddl_dir( ['PostgreSQL'], 0.1, $dir );
28 $schema->deploy( { add_drop_table => 1, add_drop_view => 1 } );
31 $schema->source('Mesclun'),
32 'DBIx::Class::ResultSource::View',
36 my ( $bowl_of_salad, $bowl_of_salad1 );
39 $bowl_of_salad = $schema->resultset('Mesclun')
40 ->create( { acidity => 4, spiciness => '10', fresh => 0 } );
42 "I can call a create on a view mesclun";
45 $bowl_of_salad1 = $schema->resultset('Salad')->create( { fresh => 1 } );
47 "I can do it for the other view, too";