7 use Test::SQL::Translator qw(maybe_plan);
13 'SQL::Translator::Parser::SQLite',
14 'SQL::Translator::Producer::YAML');
17 my $sqlt_version = $SQL::Translator::VERSION;
201 - update pet set name=name
203 database_event: insert
208 perform_action_when: after
215 select pr.person_id, pr.name as person_name, pt.name as pet_name
216 from person pr, pet pt
217 where person.person_id=pet.pet_id
223 parser_type: SQL::Translator::Parser::SQLite
225 producer_type: SQL::Translator::Producer::YAML
228 version: $sqlt_version
231 my $file = "$Bin/data/sqlite/create.sql";
232 open FH, "<$file" or die "Can't read '$file': $!\n";
235 my $tr = SQL::Translator->new(
244 ok( $out = $tr->translate, 'Translate SQLite to YAML' );
245 eq_or_diff( $out, $yaml, 'YAML matches expected' );