Some changes that should have been applied a while back.
[dbsrgits/SQL-Translator.git] / t / 24yaml.t
index cf24d00..fc5ab6d 100644 (file)
@@ -14,8 +14,9 @@ BEGIN {
         'SQL::Translator::Producer::YAML');
 }
 
-my $yaml = <<'YAML';
---- #YAML:1.0
+my $sqlt_version = $SQL::Translator::VERSION;
+my $yaml = <<YAML;
+---
 schema:
   procedures: {}
   tables:
@@ -218,7 +219,7 @@ schema:
           where  person.person_id=pet.pet_id
 translator:
   add_drop_table: 0
-  filename: '/work/sqlfairy/sqlfairy/t/data/sqlite/create.sql'
+  filename: ~
   no_comments: 0
   parser_args: {}
   parser_type: SQL::Translator::Parser::SQLite
@@ -226,13 +227,17 @@ translator:
   producer_type: SQL::Translator::Producer::YAML
   show_warnings: 0
   trace: 0
-  version: 0.05
+  version: $sqlt_version
 YAML
 
-my $tr = SQL::Translator->new(
+my $file = "$Bin/data/sqlite/create.sql";
+open FH, "<$file" or die "Can't read '$file': $!\n";
+local $/;
+my $data = <FH>;
+my $tr   = SQL::Translator->new(
     parser   => 'SQLite',
     producer => 'YAML',
-    filename => "$Bin/data/sqlite/create.sql",
+    data     => $data,
 );
 
 my $out;