package SQL::Translator::Schema::Table;
# ----------------------------------------------------------------------
-# $Id: Table.pm,v 1.15 2003-08-29 05:38:56 allenday Exp $
+# $Id: Table.pm,v 1.21 2003-09-25 17:28:37 allenday Exp $
# ----------------------------------------------------------------------
# Copyright (C) 2003 Ken Y. Clark <kclark@cpan.org>
#
use SQL::Translator::Schema::Constraint;
use SQL::Translator::Schema::Field;
use SQL::Translator::Schema::Index;
+use Data::Dumper;
use base 'Class::Base';
use vars qw( $VERSION $FIELD_ORDER );
-$VERSION = sprintf "%d.%02d", q$Revision: 1.15 $ =~ /(\d+)\.(\d+)/;
+$VERSION = sprintf "%d.%02d", q$Revision: 1.21 $ =~ /(\d+)\.(\d+)/;
# ----------------------------------------------------------------------
sub init {
Add a constraint to the table. Returns the newly created
C<SQL::Translator::Schema::Constraint> object.
- my $c1 = $table->add_constraint(
- name => 'pk',
- type => PRIMARY_KEY,
- fields => [ 'foo_id' ],
+ my $c1 = $table->add_constraint(
+ name => 'pk',
+ type => PRIMARY_KEY,
+ fields => [ 'foo_id' ],
);
my $c2 = SQL::Translator::Schema::Constraint->new( name => 'uniq' );
Add an index to the table. Returns the newly created
C<SQL::Translator::Schema::Index> object.
- my $i1 = $table->add_index(
+ my $i1 = $table->add_index(
name => 'name',
fields => [ 'name' ],
type => 'normal',
required. If you try to create a field with the same name as an
existing field, you will get an error and the field will not be created.
- my $f1 = $table->add_field(
+ my $f1 = $table->add_field(
name => 'foo_id',
data_type => 'integer',
size => 11,
);
- my $f2 = SQL::Translator::Schema::Field->new(
+ my $f2 = SQL::Translator::Schema::Field->new(
name => 'name',
table => $table,
);
- $f2 = $table->add_field( $field2 ) or die $table->error;
+ $f2 = $table->add_field( $field2 ) or die $table->error;
=cut
my $field_name = $field->name or return $self->error('No name');
if ( exists $self->{'fields'}{ $field_name } ) {
- return $self->error(qq[Can\'t create field: "$field_name" exists]);
+ return $self->error(qq[Can't create field: "$field_name" exists]);
}
else {
$self->{'fields'}{ $field_name } = $field;
return 1;
}
-sub is_data {
- my $self = shift;
- return $self->{'is_data'} if defined $self->{'is_data'};
+# ----------------------------------------------------------------------
+sub is_trivial_link {
+
+=pod
+
+=head2 is_data
- $self->{'is_data'} = 0;
+=cut
- foreach my $field ($self->get_fields){
- if(!$field->is_primary_key or !$field->is_foreign_key){
- $self->{'is_data'} = 1;
- return $self->{'is_data'}
+ my $self = shift;
+ return 0 if $self->is_data;
+ return $self->{'is_trivial_link'} if defined $self->{'is_trivial_link'};
+
+ $self->{'is_trivial_link'} = 1;
+
+ my %fk = ();
+
+ foreach my $field ( $self->get_fields ) {
+ next unless $field->is_foreign_key;
+ $fk{$field->foreign_key_reference->reference_table}++;
}
- }
- return $self->{'is_data'};
+ foreach my $referenced (keys %fk){
+ if($fk{$referenced} > 1){
+ $self->{'is_trivial_link'} = 0;
+ last;
+ }
+
+ return $self->{'is_trivial_link'};
+
+}
+
+sub is_data {
+
+=pod
+
+=head2 is_data
+
+=cut
+
+ my $self = shift;
+ return $self->{'is_data'} if defined $self->{'is_data'};
+
+ $self->{'is_data'} = 0;
+
+ foreach my $field ( $self->get_fields ) {
+ if ( !$field->is_primary_key and !$field->is_foreign_key ) {
+ $self->{'is_data'} = 1;
+ return $self->{'is_data'};
+ }
+ }
+
+ return $self->{'is_data'};
}
+# ----------------------------------------------------------------------
sub can_link {
=pod
=cut
- my($self,$table1,$table2) = @_;
+ my ( $self, $table1, $table2 ) = @_;
- #get tables in abc order
- ($table1,$table2) = sort {$a->name cmp $b->name} ($table1,$table2);
+ return $self->{'can_link'}{ $table1->name }{ $table2->name }
+ if defined $self->{'can_link'}{ $table1->name }{ $table2->name };
- return $self->{'can_link'}{$table1->name}{$table2->name} if defined $self->{'can_link'}{$table1->name}{$table2->name};
+ if ( $self->is_data == 1 ) {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } = [0];
+ $self->{'can_link'}{ $table2->name }{ $table1->name } = [0];
+ return $self->{'can_link'}{ $table1->name }{ $table2->name };
+ }
- if($self->is_data == 1){
- $self->{'can_link'}{$table1->name}{$table2->name} = 0;
- return $self->{'can_link'}{$table1->name}{$table2->name};
- }
+ my %fk = ();
- my %fk = ();
+ foreach my $field ( $self->get_fields ) {
+ if ( $field->is_foreign_key ) {
+ push @{ $fk{ $field->foreign_key_reference->reference_table } },
+ $field->foreign_key_reference;
+ }
+ }
- foreach my $field ($self->get_fields){
- #if the table has non-key fields, it can't be a link
- if(!$field->is_primary_key or !$field->is_foreign_key){
- $self->{'can_link'}{$table1->name}{$table2->name} = 0;
- return $self->{'can_link'}{$table1->name}{$table2->name};
+ if ( !defined( $fk{ $table1->name } ) or !defined( $fk{ $table2->name } ) )
+ {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } = [0];
+ $self->{'can_link'}{ $table2->name }{ $table1->name } = [0];
+ return $self->{'can_link'}{ $table1->name }{ $table2->name };
+ }
- #otherwise, count up how many fields refer to each FK table.field
- } elsif($field->is_foreign_key){
- $fk{$field->foreign_key_reference->reference_table->name}++;
- }
- }
-
- if($fk{ $table1->name } == 1
- and
- $fk{ $table2->name } == 1
- ){
- $self->{'can_link'}{$table1->name}{$table2->name} = 1;
- } else {
- $self->{'can_link'}{$table1->name}{$table2->name} = 0;
- }
-
- return $self->{'can_link'}{$table1->name}{$table2->name};
+ # trivial traversal, only one way to link the two tables
+ if ( scalar( @{ $fk{ $table1->name } } == 1 )
+ and scalar( @{ $fk{ $table2->name } } == 1 ) )
+ {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } =
+ [ 'one2one', $fk{ $table1->name }, $fk{ $table2->name } ];
+ $self->{'can_link'}{ $table1->name }{ $table2->name } =
+ [ 'one2one', $fk{ $table2->name }, $fk{ $table1->name } ];
+
+ # non-trivial traversal. one way to link table2,
+ # many ways to link table1
+ }
+ elsif ( scalar( @{ $fk{ $table1->name } } > 1 )
+ and scalar( @{ $fk{ $table2->name } } == 1 ) )
+ {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } =
+ [ 'many2one', $fk{ $table1->name }, $fk{ $table2->name } ];
+ $self->{'can_link'}{ $table2->name }{ $table1->name } =
+ [ 'one2many', $fk{ $table2->name }, $fk{ $table1->name } ];
+
+ # non-trivial traversal. one way to link table1,
+ # many ways to link table2
+ }
+ elsif ( scalar( @{ $fk{ $table1->name } } == 1 )
+ and scalar( @{ $fk{ $table2->name } } > 1 ) )
+ {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } =
+ [ 'one2many', $fk{ $table1->name }, $fk{ $table2->name } ];
+ $self->{'can_link'}{ $table2->name }{ $table1->name } =
+ [ 'many2one', $fk{ $table2->name }, $fk{ $table1->name } ];
+
+ # non-trivial traversal. many ways to link table1 and table2
+ }
+ elsif ( scalar( @{ $fk{ $table1->name } } > 1 )
+ and scalar( @{ $fk{ $table2->name } } > 1 ) )
+ {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } =
+ [ 'many2many', $fk{ $table1->name }, $fk{ $table2->name } ];
+ $self->{'can_link'}{ $table2->name }{ $table1->name } =
+ [ 'many2many', $fk{ $table2->name }, $fk{ $table1->name } ];
+
+ # one of the tables didn't export a key
+ # to this table, no linking possible
+ }
+ else {
+ $self->{'can_link'}{ $table1->name }{ $table2->name } = [0];
+ $self->{'can_link'}{ $table2->name }{ $table1->name } = [0];
+ }
+
+ return $self->{'can_link'}{ $table1->name }{ $table2->name };
}
# ----------------------------------------------------------------------
=head2 name
-Get or set the table\'s name.
+Get or set the table's name.
If provided an argument, checks the schema object for a table of
that name and disallows the change if one exists.
if ( my $arg = shift ) {
if ( my $schema = $self->schema ) {
- return $self->error( qq[Can\'t use table name "$arg": table exists] )
+ return $self->error( qq[Can't use table name "$arg": table exists] )
if $schema->get_table( $arg );
}
$self->{'name'} = $arg;
=head2 schema
-Get or set the table\'s schema object.
+Get or set the table's schema object.
my $schema = $table->schema;
=pod
-=head2 options
+=head2 primary_key
-Gets or sets the table\'s primary key(s). Takes one or more field
+Gets or sets the table's primary key(s). Takes one or more field
names (as a string, list or array[ref]) as an argument. If the field
names are present, it will create a new PK if none exists, or it will
add to the fields of an existing PK (and will unique the field names).
=head2 options
-Get or set the table\'s options (e.g., table types for MySQL). Returns
+Get or set the table's options (e.g., table types for MySQL). Returns
an array or array reference.
my @options = $table->options;
=head2 order
-Get or set the table\'s order.
+Get or set the table's order.
my $order = $table->order(3);
=pod
-=head1 AUTHOR
+=head1 AUTHORS
-Ken Y. Clark E<lt>kclark@cpan.orgE<gt>
+Ken Y. Clark E<lt>kclark@cpan.orgE<gt>,
+Allen Day E<lt>allenday@ucla.eduE<gt>.
=cut