Applied patch sent in by Daniel Westermann-Clark on Oct 11 2006.
[dbsrgits/SQL-Translator.git] / t / 31dumper.t
index de39d5d..2a813b8 100644 (file)
@@ -4,15 +4,19 @@
 
 use strict;
 use Config;
-use FindBin qw/$Bin/;
-use Test::More;
 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);
 
 BEGIN {
     maybe_plan(
         5, 
+        'DBI',
         'SQL::Translator::Parser::SQLite',
         'SQL::Translator::Producer::Dumper'
     );
@@ -44,8 +48,12 @@ print $fh $output;
 close $fh or die "Can't close file '$filename': $!";
 
 my $perl = $Config{'perlpath'};
-my $cmd  = "$perl -cw $filename";
-my $res  = `$cmd 2>&1`;
+open( NULL, ">", File::Spec->devnull );
+my $pid = open3( gensym, \*NULL, \*PH, "$perl -cw $filename" );
+my $res;
+while( <PH> ) { $res .= $_;  }
+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',},