X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F31dumper.t;h=927c82d200d57d5c6313142a20035948fcf4860c;hb=dd7dcde649077c79ecb908bcb472f2039cc0436b;hp=1f42e138de1a87c815f11cabb961352ec666a39e;hpb=d2f0a9f6eb0de6fbed1e4c19ab70e00ebe8b3abf;p=dbsrgits%2FSQL-Translator.git diff --git a/t/31dumper.t b/t/31dumper.t index 1f42e13..927c82d 100644 --- a/t/31dumper.t +++ b/t/31dumper.t @@ -3,19 +3,18 @@ # Test for Dumper producer use strict; -use Config; use File::Temp 'tempfile'; -use File::Spec; use FindBin qw/$Bin/; use IPC::Open3; use SQL::Translator; use Test::More; use Test::SQL::Translator qw(maybe_plan); use Symbol qw(gensym); +use Text::ParseWords qw(shellwords); BEGIN { maybe_plan( - 5, + 5, 'DBI', 'SQL::Translator::Parser::SQLite', 'SQL::Translator::Producer::Dumper' @@ -39,27 +38,24 @@ my $t = SQL::Translator->new( ); my $output = $t->translate( $file ); - ok( $output, 'Got dumper script' ); +like( $output, qr{DBI->connect\(\s*'$dsn',\s*'$db_user',\s*'$db_pass',}, + 'Script contains correct DSN, db user and password' ); + +like( $output, qr/table_name\s*=>\s*'person',/, 'Found "person" table' ); +unlike( $output, qr/table_name\s*=>\s*'pet',/, 'Skipped "pet" table' ); + my ( $fh, $filename ) = tempfile( 'XXXXXXXX' ); print $fh $output; close $fh or die "Can't close file '$filename': $!"; -my $perl = $Config{'perlpath'}; -open( NULL, ">", File::Spec->devnull ); -my $pid = open3( gensym, ">&NULL", \*PH, "$perl -cw $filename" ); -my $res; -while( ) { $res .= $_; } +my $out; +my $pid = open3( undef, $out, undef, $^X, shellwords($ENV{HARNESS_PERL_SWITCHES}||''), '-cw', $filename ); +my $res = do { local $/; <$out> }; waitpid($pid, 0); like( $res, qr/syntax OK/, 'Generated script syntax is OK' ); -like( $output, qr{DBI->connect\(\s*'$dsn',\s*'$db_user',\s*'$db_pass',}, - 'Script contains correct DSN, db user and password' ); - -like( $output, qr/table_name\s*=>\s*'person',/, 'Found "person" table' ); -unlike( $output, qr/table_name\s*=>\s*'pet',/, 'Skipped "pet" table' ); - unlink $filename;