3 # Test for Dumper producer
6 use File::Temp 'tempfile';
11 use Test::SQL::Translator qw(maybe_plan);
12 use Symbol qw(gensym);
13 use Text::ParseWords qw(shellwords);
19 'SQL::Translator::Parser::SQLite',
20 'SQL::Translator::Producer::Dumper'
24 my $db_user = 'nomar';
25 my $db_pass = 'gos0X!';
26 my $dsn = 'dbi:SQLite:dbname=/tmp/foo';
27 my $file = "$Bin/data/sqlite/create.sql";
28 my $t = SQL::Translator->new(
35 db_password => $db_pass,
40 my $output = $t->translate( $file );
41 ok( $output, 'Got dumper script' );
43 like( $output, qr{DBI->connect\(\s*'$dsn',\s*'$db_user',\s*'$db_pass',},
44 'Script contains correct DSN, db user and password' );
46 like( $output, qr/table_name\s*=>\s*'person',/, 'Found "person" table' );
47 unlike( $output, qr/table_name\s*=>\s*'pet',/, 'Skipped "pet" table' );
49 my ( $fh, $filename ) = tempfile( 'XXXXXXXX' );
52 close $fh or die "Can't close file '$filename': $!";
55 my $pid = open3( undef, $out, undef, $^X, shellwords($ENV{HARNESS_PERL_SWITCHES}||''), '-cw', $filename );
56 my $res = do { local $/; <$out> };
59 like( $res, qr/syntax OK/, 'Generated script syntax is OK' );