use FindBin qw/$Bin/;
use SQL::Translator;
+use SQL::Translator::Utils qw/ddl_parser_instance/;
### Set $ENV{SQLTTEST_RT_DEBUG} = 1 for more output
{
engine => 'XML',
req => 'XML::LibXML 1.69',
+ no_grammar => 1,
},
{
engine => 'YAML',
+ no_grammar => 1,
},
{
parser_args => {},
},
-# {
-# engine => 'Oracle',
-# producer_args => {},
-# parser_args => {},
-# todo => 'Needs volunteers',
-# },
-# {
-# engine => 'Sybase',
-# producer_args => {},
-# parser_args => {},
-# todo => 'Needs volunteers',
-# },
-# {
-# engine => 'DB2',
-# producer_args => {},
-# parser_args => {},
-# todo => 'Needs volunteers',
-# },
+ {
+ engine => 'Oracle',
+ producer_args => {},
+ parser_args => {},
+ todo => 'Needs volunteers',
+ },
+ {
+ engine => 'Sybase',
+ producer_args => {},
+ parser_args => {},
+ todo => 'Needs volunteers',
+ },
+ {
+ engine => 'DB2',
+ producer_args => {},
+ parser_args => {},
+ todo => 'Needs volunteers',
+ },
# There is no Access producer
# {
);
}
+ use_ok("SQL::Translator::Producer::$args->{engine}");
+ use_ok("SQL::Translator::Parser::$args->{engine}");
+
+ ok(ddl_parser_instance($args->{engine}), 'Got proper parser instance')
+ unless $args->{no_grammar};
+
TODO: {
local $TODO = $args->{todo} if $args->{todo};
+ no warnings 'once';
+ # silence PR::D from spewing on STDERR
+ local $::RD_ERRORS = 0 if $args->{todo};
+ local $::RD_WARN = 0 if $args->{todo};
+ local $::RD_HINT = 0 if $args->{todo};
+
lives_ok (
sub { check_roundtrip ($args, $base_schema) },
"Round trip for $args->{name} did not throw an exception",
isa_ok ($mid_schema, 'SQL::Translator::Schema', "First $args->{name} parser pass produced a schema:")
or do {
diag (_gen_diag ( $parser_t->error, $base_out ) );
+ my $i;
+ note join ("\n" . ( '=' x 76) . "\n",
+ 'Unparseable DDL:',
+ (join ("\n", map { ++$i . ":\t$_" } split /\n/, $base_out) ),
+ ''
+ );
return;
};
# the two sql strings should be identical
my $msg = "$args->{name} SQL roundtrip successful - SQL statements match";
- $ENV{SQLTTEST_RT_DEBUG} #stringify below because IO::Scalar does not behave nice
- ? eq_or_diff ("$rt_out", "$base_out", $msg)
- : ok ("$rt_out" eq "$base_out", $msg)
+ $ENV{SQLTTEST_RT_DEBUG}
+ ? eq_or_diff ($rt_out, $base_out, $msg)
+ : ok ($rt_out eq $base_out, $msg)
;
}