package SQL::Translator::Schema::Table;
# ----------------------------------------------------------------------
-# $Id: Table.pm,v 1.34 2005-07-15 23:36:13 duality72 Exp $
-# ----------------------------------------------------------------------
-# Copyright (C) 2002-4 SQLFairy Authors
+# Copyright (C) 2002-2009 SQLFairy Authors
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License as
use base 'SQL::Translator::Schema::Object';
-use vars qw( $VERSION $FIELD_ORDER );
-
-$VERSION = sprintf "%d.%02d", q$Revision: 1.34 $ =~ /(\d+)\.(\d+)/;
+use vars qw( $VERSION );
+$VERSION = '1.59';
# 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
=cut
+sub new {
+ my $class = shift;
+ my $self = $class->SUPER::new (@_)
+ or return;
+
+ $self->{_order} = { map { $_ => 0 } qw/
+ field
+ /};
+
+ return $self;
+}
+
+
+
# ----------------------------------------------------------------------
sub add_constraint {
$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;
}
$self->error( $field_class->error );
}
- $field->order( ++$FIELD_ORDER );
+ $field->order( ++$self->{_order}{field} );
# We know we have a name as the Field->new above errors if none given.
my $field_name = $field->name;
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]);
}
=head2 field_names
Read-only method to return a list or array ref of the field names. Returns undef
-or an empty list if the table has no fields set. Usefull if you want to
+or an empty list if the table has no fields set. Useful if you want to
avoid the overload magic of the Field objects returned by the get_fields method.
my @names = $constraint->field_names;
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);
# 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
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;
}
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;
}
}
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;
}
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;
}
}
=head1 AUTHORS
-Ken Y. Clark E<lt>kclark@cpan.orgE<gt>,
+Ken Youens-Clark E<lt>kclark@cpan.orgE<gt>,
Allen Day E<lt>allenday@ucla.eduE<gt>.
=cut