1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
#!/usr/bin/perl
# vim: set ft=perl:
# Test for Dumper producer
use strict;
use File::Temp 'tempfile';
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'
);
}
my $db_user = 'nomar';
my $db_pass = 'gos0X!';
my $dsn = 'dbi:SQLite:dbname=/tmp/foo';
my $file = "$Bin/data/sqlite/create.sql";
my $t = SQL::Translator->new(
from => 'SQLite',
to => 'Dumper',
producer_args => {
skip => 'pet',
skiplike => '',
db_user => $db_user,
db_password => $db_pass,
dsn => $dsn,
}
);
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 $out;
my $pid = open3( undef, $out, undef, $^X, '-cw', $filename );
my $res = do { local $/; <$out> };
waitpid($pid, 0);
like( $res, qr/syntax OK/, 'Generated script syntax is OK' );
unlink $filename;
|
