Added support for proper enums under pg (as of 8.3), with pg version check, and defer...

[dbsrgits/SQL-Translator.git] / lib / SQL / Translator / Schema / Table.pm

diff --git a/lib/SQL/Translator/Schema/Table.pm b/lib/SQL/Translator/Schema/Table.pm
index d14e7aa..feb0014 100644 (file)
--- a/lib/SQL/Translator/Schema/Table.pm
+++ b/lib/SQL/Translator/Schema/Table.pm
@@ -1,7 +1,7 @@
 package SQL::Translator::Schema::Table;
 
 # ----------------------------------------------------------------------
-# $Id: Table.pm,v 1.34 2005-07-15 23:36:13 duality72 Exp $
+# $Id: Table.pm,v 1.37 2007-10-24 10:55:44 schiffbruechige Exp $
 # ----------------------------------------------------------------------
 # Copyright (C) 2002-4 SQLFairy Authors
 #
@@ -51,8 +51,7 @@ use base 'SQL::Translator::Schema::Object';
 
 use vars qw( $VERSION $FIELD_ORDER );
 
-$VERSION = sprintf "%d.%02d", q$Revision: 1.34 $ =~ /(\d+)\.(\d+)/;
-
+$VERSION = sprintf "%d.%02d", q$Revision: 1.27 $ =~ /(\d+)\.(\d+)/;
 
 # Stringify to our name, being careful not to pass any args through so we don't
 # accidentally set it to undef. We also have to tweak bool so the object is
@@ -238,7 +237,9 @@ C<SQL::Translator::Schema::Index> object.
         $index = $index_class->new( \%args ) or return 
             $self->error( $index_class->error );
     }
-
+    foreach my $ex_index ($self->get_indices) {
+       return if ($ex_index->equals($index));
+    }
     push @{ $self->{'indices'} }, $index;
     return $index;
 }
@@ -494,7 +495,7 @@ Returns a field by the name provided.
     if ( $case_insensitive ) {
        $field_name = uc($field_name);
        foreach my $field ( keys %{$self->{fields}} ) {
-               return $self->{fields}{$field_name} if $field_name eq uc($field);
+               return $self->{fields}{$field} if $field_name eq uc($field);
        }
        return $self->error(qq[Field "$field_name" does not exist]);
     }
@@ -924,9 +925,10 @@ Determines if this table is the same as another
 
     my $self = shift;
     my $other = shift;
+    my $case_insensitive = shift;
     
     return 0 unless $self->SUPER::equals($other);
-    return 0 unless $self->name eq $other->name;
+    return 0 unless $case_insensitive ? uc($self->name) eq uc($other->name) : $self->name eq $other->name;
     return 0 unless $self->_compare_objects(scalar $self->options, scalar $other->options);
     return 0 unless $self->_compare_objects(scalar $self->extra, scalar $other->extra);
 
@@ -934,8 +936,8 @@ Determines if this table is the same as another
     # Go through our fields
     my %checkedFields;
     foreach my $field ( $self->get_fields ) {
-       my $otherField = $other->get_field($field->name);
-       return 0 unless $field->equals($otherField);
+       my $otherField = $other->get_field($field->name, $case_insensitive);
+       return 0 unless $field->equals($otherField, $case_insensitive);
        $checkedFields{$field->name} = 1;
     }
     # Go through the other table's fields
@@ -950,7 +952,7 @@ Determines if this table is the same as another
 CONSTRAINT:
     foreach my $constraint ( $self->get_constraints ) {
        foreach my $otherConstraint ( $other->get_constraints ) {
-               if ( $constraint->equals($otherConstraint) ) {
+               if ( $constraint->equals($otherConstraint, $case_insensitive) ) {
                        $checkedConstraints{$otherConstraint} = 1;
                        next CONSTRAINT;
                }
@@ -962,7 +964,7 @@ CONSTRAINT2:
     foreach my $otherConstraint ( $other->get_constraints ) {
        next if $checkedFields{$otherConstraint};
        foreach my $constraint ( $self->get_constraints ) {
-               if ( $otherConstraint->equals($constraint) ) {
+               if ( $otherConstraint->equals($constraint, $case_insensitive) ) {
                        next CONSTRAINT2;
                }
        }
@@ -975,7 +977,7 @@ CONSTRAINT2:
 INDEX:
     foreach my $index ( $self->get_indices ) {
        foreach my $otherIndex ( $other->get_indices ) {
-               if ( $index->equals($otherIndex) ) {
+               if ( $index->equals($otherIndex, $case_insensitive) ) {
                        $checkedIndices{$otherIndex} = 1;
                        next INDEX;
                }
@@ -987,7 +989,7 @@ INDEX2:
     foreach my $otherIndex ( $other->get_indices ) {
        next if $checkedIndices{$otherIndex};
        foreach my $index ( $self->get_indices ) {
-               if ( $otherIndex->equals($index) ) {
+               if ( $otherIndex->equals($index, $case_insensitive) ) {
                        next INDEX2;
                }
        }