X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FSchema.pm;h=c53789f14ecf38704694616277a8d7874d2e9c17;hb=ba506e52c480afe33dfec6b38a12759fad1e7fa2;hp=03e658a355629d07cde38d16c65a674d84acd9c5;hpb=da5a1bae10b18456fedc2707f0361274e6c68a17;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Schema.pm b/lib/SQL/Translator/Schema.pm index 03e658a..c53789f 100644 --- a/lib/SQL/Translator/Schema.pm +++ b/lib/SQL/Translator/Schema.pm @@ -1,11 +1,7 @@ package SQL::Translator::Schema; -# vim: sw=4: ts=4: - -# ---------------------------------------------------------------------- -# $Id: Schema.pm,v 1.27 2007-10-24 10:58:35 schiffbruechige 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 @@ -54,16 +50,31 @@ use SQL::Translator::Schema::Procedure; use SQL::Translator::Schema::Table; use SQL::Translator::Schema::Trigger; use SQL::Translator::Schema::View; -use SQL::Translator::Schema::Graph; + use SQL::Translator::Utils 'parse_list_arg'; use base 'SQL::Translator::Schema::Object'; -use vars qw[ $VERSION $TABLE_ORDER $VIEW_ORDER $TRIGGER_ORDER $PROC_ORDER ]; +use vars qw[ $VERSION ]; -$VERSION = sprintf "%d.%02d", q$Revision: 1.27 $ =~ /(\d+)\.(\d+)/; +$VERSION = '1.60'; __PACKAGE__->_attributes(qw/name database translator/); +sub new { + my $class = shift; + my $self = $class->SUPER::new (@_) + or return; + + $self->{_order} = { map { $_ => 0 } qw/ + table + view + trigger + proc + /}; + + return $self; +} + # ---------------------------------------------------------------------- sub as_graph { @@ -74,8 +85,10 @@ sub as_graph { Returns the schema as an L object. =cut + require SQL::Translator::Schema::Graph; my $self = shift; + return SQL::Translator::Schema::Graph->new( translator => $self->translator ); } @@ -139,13 +152,13 @@ not be created. $table->schema($self); } else { - my %args = @_; + my %args = ref $_[0] eq 'HASH' ? %{ $_[0] } : @_; $args{'schema'} = $self; $table = $table_class->new( \%args ) or return $self->error( $table_class->error ); } - $table->order( ++$TABLE_ORDER ); + $table->order( ++$self->{_order}{table} ); # We know we have a name as the Table->new above errors if none given. my $table_name = $table->name; @@ -232,14 +245,14 @@ procedure will not be created. $procedure->schema($self); } else { - my %args = @_; + my %args = ref $_[0] eq 'HASH' ? %{ $_[0] } : @_; $args{'schema'} = $self; return $self->error('No procedure name') unless $args{'name'}; $procedure = $procedure_class->new( \%args ) or return $self->error( $procedure_class->error ); } - $procedure->order( ++$PROC_ORDER ); + $procedure->order( ++$self->{_order}{proc} ); my $procedure_name = $procedure->name or return $self->error('No procedure name'); @@ -318,14 +331,14 @@ not be created. $trigger->schema($self); } else { - my %args = @_; + my %args = ref $_[0] eq 'HASH' ? %{ $_[0] } : @_; $args{'schema'} = $self; return $self->error('No trigger name') unless $args{'name'}; $trigger = $trigger_class->new( \%args ) or return $self->error( $trigger_class->error ); } - $trigger->order( ++$TRIGGER_ORDER ); + $trigger->order( ++$self->{_order}{trigger} ); my $trigger_name = $trigger->name or return $self->error('No trigger name'); if ( defined $self->{'triggers'}{$trigger_name} ) { @@ -401,13 +414,13 @@ not be created. $view->schema($self); } else { - my %args = @_; + my %args = ref $_[0] eq 'HASH' ? %{ $_[0] } : @_; $args{'schema'} = $self; return $self->error('No view name') unless $args{'name'}; $view = $view_class->new( \%args ) or return $view_class->error; } - $view->order( ++$VIEW_ORDER ); + $view->order( ++$self->{_order}{view} ); my $view_name = $view->name or return $self->error('No view name'); if ( defined $self->{'views'}{$view_name} ) { @@ -718,7 +731,7 @@ the joins from primary keys to fields of the same name in other tables A list of fields to skip in the joins -=back 4 +=back $schema->make_natural_joins( join_pk_only => 1,