move backcompat into Compat.pm and apply the role to Object.pm

[dbsrgits/SQL-Translator-2.0-ish.git] / lib / SQL / Translator / Parser / DDL / SQLite.pm

diff --git a/lib/SQL/Translator/Parser/DDL/SQLite.pm b/lib/SQL/Translator/Parser/DDL/SQLite.pm
index 26db707..786813a 100644 (file)
--- a/lib/SQL/Translator/Parser/DDL/SQLite.pm
+++ b/lib/SQL/Translator/Parser/DDL/SQLite.pm
@@ -28,7 +28,7 @@ role SQL::Translator::Parser::DDL::SQLite {
     
         unless (defined $parser) {
             return $translator->error("Error instantiating Parse::RecDescent ".
-                "instance: Bad grammer");
+                "instance: Bad grammar");
         }
     
         my $result = $parser->startrule($data);
@@ -37,7 +37,7 @@ role SQL::Translator::Parser::DDL::SQLite {
         my $schema = $translator->schema;
         my @tables = 
             map   { $_->[1] }
-#            sort  { $a->[0] <=> $b->[0] } 
+            sort  { $a->[0] <=> $b->[0] }
             map   { [ $result->{'tables'}{ $_ }->{'order'}, $_ ] }
             keys %{ $result->{'tables'} };
     
@@ -91,7 +91,7 @@ role SQL::Translator::Parser::DDL::SQLite {
                     $constraint = ForeignKey->new({ name => $cdata->{name} || 'foreign_key',
                                                     table => $table,
                                                     reference_table => $cdata->{reference_table},
-                                                    reference_columns => $cdata->{reference_fields},
+                                                    reference_columns => ref $cdata->{reference_fields} ? $cdata->{reference_fields} : [ $cdata->{reference_fields} ],
                                                     on_delete => $cdata->{on_delete} || $cdata->{on_delete_do},
                                                     on_update => $cdata->{on_update} || $cdata->{on_update_do} });
                     $table->get_column($_)->is_foreign_key(1) for @{$cdata->{fields}};
@@ -101,20 +101,6 @@ role SQL::Translator::Parser::DDL::SQLite {
                     $constraint->add_column($table->get_column($_)) for @{$cdata->{fields}};
                 }
                 $table->add_constraint($constraint);
-=cut
-                my $constraint = Constraint->new({
-                    name             => $cdata->{'name'},
-                    type             => $cdata->{'type'},
-                    columns          => $cdata->{'fields'},
-                    reference_table  => $cdata->{'reference_table'},
-                    reference_fields => $cdata->{'reference_fields'},
-                    match_type       => $cdata->{'match_type'} || '',
-                    on_delete        => $cdata->{'on_delete'} || $cdata->{'on_delete_do'},
-                    on_update        => $cdata->{'on_update'} || $cdata->{'on_update_do'},
-                    table            => $table,
-                });
-                $table->add_constraint($constraint);
-=cut
             }
         }