5 use Test::More qw/no_plan/;
11 use SQL::Translator::Utils qw/ddl_parser_instance/;
14 ### Set $ENV{SQLTTEST_RT_DEBUG} = 1 for more output
16 # What tests to run - parser/producer name, and optional args
20 req => 'XML::LibXML 1.69',
41 producer_args => { mysql_version => 5 },
42 parser_args => { mysql_parser_version => 5 },
47 producer_args => { mysql_version => '5.1' },
48 parser_args => { mysql_parser_version => '5.1' },
51 engine => 'PostgreSQL',
56 engine => 'SQLServer',
65 todo => 'Needs volunteers',
71 todo => 'Needs volunteers',
77 todo => 'Needs volunteers',
80 # There is no Access producer
83 # producer_args => {},
89 # This data file has the right mix of table/view/procedure/trigger
90 # definitions, and lists enough quirks to trip up most combos
91 my $base_file = "$Bin/data/roundtrip_autogen.yaml";
92 open (my $base_fh, '<', $base_file) or die "$base_file: $!";
94 my $base_t = SQL::Translator->new;
95 $base_t->$_ (1) for qw/add_drop_table no_comments/;
97 my $base_schema = $base_t->translate (
99 data => do { local $/; <$base_fh>; },
100 ) or die $base_t->error;
103 #assume there is at least one table
105 XML => qr/<tables>\s*<table/,
106 YAML => qr/\A---\n.+tables\:/s,
107 SQL => qr/^\s*CREATE TABLE/m,
110 for my $args (@$plan) {
112 $args->{name} ||= $args->{engine};
114 my @req = ref $args->{req} ? @{$args->{req}} : $args->{req}||();
118 push @missing, $_ if ($@);
121 skip sprintf ('Need %s for %s roundtrip test',
122 join (', ', @missing),
127 use_ok("SQL::Translator::Producer::$args->{engine}");
128 use_ok("SQL::Translator::Parser::$args->{engine}");
130 ok(ddl_parser_instance($args->{engine}), 'Got proper parser instance')
131 unless $args->{no_grammar};
134 local $TODO = $args->{todo} if $args->{todo};
137 # silence PR::D from spewing on STDERR
138 local $::RD_ERRORS = 0 if $args->{todo};
139 local $::RD_WARN = 0 if $args->{todo};
140 local $::RD_HINT = 0 if $args->{todo};
143 sub { check_roundtrip ($args, $base_schema) },
144 "Round trip for $args->{name} did not throw an exception",
151 sub check_roundtrip {
152 my ($args, $base_schema) = @_;
153 my $base_t = $base_schema->translator;
155 # create some output from the submitted schema
156 my $base_out = $base_t->translate (
157 data => $base_schema,
158 producer => $args->{engine},
159 producer_args => $args->{producer_args},
164 $string_re->{$args->{engine}} || $string_re->{SQL},
165 "Received some meaningful output from the first $args->{name} production",
167 diag ( _gen_diag ($base_t->error) );
172 my $parser_t = SQL::Translator->new;
173 $parser_t->$_ (1) for qw/add_drop_table no_comments/;
174 my $mid_schema = $parser_t->translate (
176 parser => $args->{engine},
177 parser_args => $args->{parser_args},
180 isa_ok ($mid_schema, 'SQL::Translator::Schema', "First $args->{name} parser pass produced a schema:")
182 diag (_gen_diag ( $parser_t->error, $base_out ) );
184 note join ("\n" . ( '=' x 76) . "\n",
186 (join ("\n", map { ++$i . ":\t$_" } split /\n/, $base_out) ),
192 # schemas should be comparable at least as far as table/field numbers go
194 _get_table_info ($mid_schema->get_tables),
195 _get_table_info ($base_schema->get_tables),
196 "Schema tables generally match afer $args->{name} parser trip",
199 # and produce sql once again
201 # Producing a schema with a Translator different from the one the schema was generated
202 # from does not work. This is arguably a bug, 61translator_agnostic.t works with that
203 # my $producer_t = SQL::Translator->new;
204 # $producer_t->$_ (1) for qw/add_drop_table no_comments/;
206 # my $rt_sql = $producer_t->translate (
207 # data => $mid_schema,
208 # producer => $args->{engine},
209 # producer_args => $args->{producer_args},
212 my $rt_out = $parser_t->translate (
214 producer => $args->{engine},
215 producer_args => $args->{producer_args},
220 $string_re->{$args->{engine}} || $string_re->{SQL},
221 "Received some meaningful output from the second $args->{name} production",
223 diag ( _gen_diag ( $parser_t->error ) );
227 # the two sql strings should be identical
228 my $msg = "$args->{name} SQL roundtrip successful - SQL statements match";
229 $ENV{SQLTTEST_RT_DEBUG}
230 ? eq_or_diff ($rt_out, $base_out, $msg)
231 : ok ($rt_out eq $base_out, $msg)
235 sub _get_table_info {
240 for my $t (@tables) {
244 map { $_->name } ($t->get_fields),
252 # takes an error string and an optional output block
253 # returns the string conctenated with a line-numbered block for
256 my ($err, $out) = @_;
258 return 'Unknown error' unless $err;
261 if ($out and $ENV{SQLTTEST_RT_DEBUG}) {
263 for (split /\n/, $out) {
264 push @lines, sprintf ('%03d: %s',
270 return "$err\n\n" . join ("\n", @lines);