use strict;
use warnings;
use lib 't/lib';
-use Test::More qw(no_plan);
+use Test::More tests => 4;
use Test::Exception;
-use Devel::Dwarn;
+use CafeInsertion;
BEGIN {
- use_ok 'Cafe';
$ENV{DBIC_TRACE} = 0;
}
-my $schema = Cafe->connect( 'dbi:Pg:dbname=test', 'postgres', '' );
-$schema->storage->dbh->{Warn} = 0;
+my ( $dsn, $user, $pass )
+ = @ENV{ map {"DBICTEST_PG_${_}"} qw/DSN USER PASS/ };
+plan skip_all => <<'EOM' unless $dsn && $user;
+Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
+( NOTE: This test drops and creates some tables.')
+EOM
+
+my $schema = CafeInsertion->connect( $dsn, $user, $pass );
$schema->storage->ensure_connected;
$schema->storage->_use_insert_returning(0);
+$schema->storage->dbh->{Warn} = 0;
my $dir = "t/sql"; # tempdir(CLEANUP => 0);
$schema->create_ddl_dir( ['PostgreSQL'], 0.1, $dir );
my ( $drink, $drink1 );
lives_ok {
- $drink = $schema->resultset('Sumatra')
- ->create( { sweetness => 4, aroma => 'earthy', flavor => 'great' } );
+ $drink = $schema->resultset('Sumatra')->create(
+ { sweetness => 4,
+ fat_free => 1,
+ aroma => 'earthy',
+ flavor => 'great'
+ }
+ );
}
"I can call a create on a view sumatra";
}
"I can do it for the other view, too";
+my $sqlt_object = $schema->{sqlt};
+is_deeply(
+ [ map { $_->name } $sqlt_object->get_views ],
+ [ qw/
+ coffee
+ sumatra
+ /
+ ],
+ "SQLT view order triumphantly matches our order."
+);