X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FSchema.pm;h=eb8e8c29757b53f4720efea547c01c5f53f16298;hb=5a3f5c82c2d3da458501ac18e3433997590308d7;hp=02962d29482431f5125629355f4e01ed0e311088;hpb=201642eed3f61181d877fa8af819c3cc624c5646;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Schema.pm b/lib/SQL/Translator/Schema.pm index 02962d2..eb8e8c2 100644 --- a/lib/SQL/Translator/Schema.pm +++ b/lib/SQL/Translator/Schema.pm @@ -1,9 +1,9 @@ package SQL::Translator::Schema; # ---------------------------------------------------------------------- -# $Id: Schema.pm,v 1.11 2003-10-08 18:30:15 phrrngtn Exp $ +# $Id: Schema.pm,v 1.13 2004-02-09 23:04:26 kycl4rk Exp $ # ---------------------------------------------------------------------- -# Copyright (C) 2003 Ken Y. Clark +# Copyright (C) 2002-4 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 @@ -49,15 +49,12 @@ use SQL::Translator::Schema::Procedure; use SQL::Translator::Schema::Table; use SQL::Translator::Schema::Trigger; use SQL::Translator::Schema::View; -use SQL::Translator::Schema::Procedure; - use SQL::Translator::Utils 'parse_list_arg'; - use base 'Class::Base'; use vars qw[ $VERSION $TABLE_ORDER $VIEW_ORDER $TRIGGER_ORDER $PROC_ORDER ]; -$VERSION = sprintf "%d.%02d", q$Revision: 1.11 $ =~ /(\d+)\.(\d+)/; +$VERSION = sprintf "%d.%02d", q$Revision: 1.13 $ =~ /(\d+)\.(\d+)/; # ---------------------------------------------------------------------- sub init { @@ -271,53 +268,6 @@ not be created. } # ---------------------------------------------------------------------- -sub add_procedure { - -=pod - -=head2 add_procedure - -Add a procedure object. Returns the new -SQL::Translator::Schema::Procedure object. The "name" parameter is -required. If you try to create a procedure with the same name as an -existing procedure, you will get an error and the procedure will not -be created. - - my $p1 = $schema->add_procedure( name => 'foo' ); - my $p2 = SQL::Translator::Schema::Procedure->new( name => 'bar' ); - $p2 = $schema->add_procedure( $p2 ) or die $schema->error; - -=cut - - my $self = shift; - my $procedure_class = 'SQL::Translator::Schema::Procedure'; - my $procedure; - - if ( UNIVERSAL::isa( $_[0], $procedure_class ) ) { - $procedure= shift; - $procedure->schema( $self ); - } - else { - my %args = @_; - return $self->error('No procedure name') unless $args{'name'}; - $args{'schema'} = $self; - $procedure = $procedure_class->new( \%args ) or return $procedure_class->error; - } - - my $procedure_name = $procedure->name or return $self->error('No procedure name'); - - if ( defined $self->{'procedures'}{ $procedure_name } ) { - return $self->error(qq[Can't create procedure: "$procedure_name" exists]); - } - else { - $self->{'procedures'}{ $procedure_name } = $procedure; - } - - return $procedure; -} - - -# ---------------------------------------------------------------------- sub database { =pod @@ -555,53 +505,6 @@ Returns all the views as an array or array reference. } } - - -# ---------------------------------------------------------------------- -sub get_procedure { - -=pod - -=head2 get_procedure - -Returns a procedure by the name provided. - - my $view = $schema->get_procedure('foo'); - -=cut - - my $self = shift; - my $procedure_name = shift or return $self->error('No procedure name'); - return $self->error('Procedure "$procedure_name" does not exist') unless - exists $self->{'procedures'}{ $procedure_name }; - return $self->{'procedures'}{ $procedure_name }; -} - -# ---------------------------------------------------------------------- -sub get_procedures { - -=pod - -=head2 get_procedures - -Returns all the procedures as an array or array reference. - - my @procedures = $schema->get_procedures; - -=cut - - my $self = shift; - my @procedures = values %{ $self->{'procedures'} }; - - if ( @procedures ) { - return wantarray ? @procedures : \@procedures; - } - else { - $self->error('No procedures'); - return wantarray ? () : undef; - } -} - # ---------------------------------------------------------------------- sub make_natural_joins {