7 use Test::SQL::Translator;
9 use SQL::Translator::Diff;
11 maybe_plan(10, 'DBD::Pg', 'Test::PostgreSQL');
13 my ( $pgsql, $dbh , $ddl, $ret );
16 $pgsql = Test::PostgreSQL->new() or plan skip_all => $Test::PostgreSQL::errstr;
17 $dbh = DBI->connect($pgsql->dsn,'','', { RaiseError => 1 }) or plan skip_all => $DBI::errstr;
20 my $source_ddl = <<DDL;
22 pk SERIAL PRIMARY KEY,
27 ok( $ret = $dbh->do($source_ddl), "create table" );
29 ok( $ret = $dbh->do(q| INSERT INTO foo (bar) VALUES ('buzz') |), "insert data" );
31 cmp_ok( $ret, '==', 1, "one row inserted" );
33 my $target_ddl = <<DDL;
35 pk SERIAL PRIMARY KEY,
40 my $source_sqlt = SQL::Translator->new(
42 parser => 'SQL::Translator::Parser::PostgreSQL',
43 )->translate(\$source_ddl);
45 my $target_sqlt = SQL::Translator->new(
47 parser => 'SQL::Translator::Parser::PostgreSQL',
48 )->translate(\$target_ddl);
50 my $table = $target_sqlt->get_table('fluff');
51 $table->extra( renamed_from => 'foo' );
52 my $field = $table->get_field('biff');
53 $field->extra( renamed_from => 'bar' );
55 my @diff = SQL::Translator::Diff->new({
56 output_db => 'PostgreSQL',
57 source_schema => $source_sqlt,
58 target_schema => $target_sqlt,
59 })->compute_differences->produce_diff_sql;
61 foreach my $line (@diff) {
63 next if $line =~ /^--/;
64 ok( $dbh->do($line), "$line" );
67 ok ( $ret = $dbh->selectall_arrayref(q(SELECT biff FROM fluff), { Slice => {} }), "query DB for data" );
69 cmp_ok( scalar(@$ret), '==', 1, "Got 1 row");
71 cmp_ok( $ret->[0]->{biff}, 'eq', 'buzz', "col biff has value buzz" );