X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FSchema%2FView.pm;h=8893d15a4fdcc959780dac106c848ed6a360ec76;hb=abf315bb9c2c78e40da9af6519e5daae76d60f08;hp=c41f5f097622b95dc038e5d6955513d081637c28;hpb=25a02fa730c2f24d9d1ed36f3ded087e5bfaa47e;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Schema/View.pm b/lib/SQL/Translator/Schema/View.pm index c41f5f0..8893d15 100644 --- a/lib/SQL/Translator/Schema/View.pm +++ b/lib/SQL/Translator/Schema/View.pm @@ -1,9 +1,9 @@ package SQL::Translator::Schema::View; # ---------------------------------------------------------------------- -# $Id: View.pm,v 1.2 2003-05-09 17:12:15 kycl4rk Exp $ +# $Id: View.pm,v 1.10 2005-06-27 21:59:20 duality72 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 @@ -29,9 +29,10 @@ SQL::Translator::Schema::View - SQL::Translator view object =head1 SYNOPSIS use SQL::Translator::Schema::View; - my $view = SQL::Translator::Schema::View->new( - name => 'foo', - sql => 'select * from foo', + my $view = SQL::Translator::Schema::View->new( + name => 'foo', # name, required + sql => 'select id, name from foo', # SQL for view + fields => 'id, name', # field names in view ); =head1 DESCRIPTION @@ -43,16 +44,19 @@ C is the view object. =cut use strict; -use Class::Base; use SQL::Translator::Utils 'parse_list_arg'; -use base 'Class::Base'; +use base 'SQL::Translator::Schema::Object'; + use vars qw($VERSION $TABLE_COUNT $VIEW_COUNT); -$VERSION = 1.00; +$VERSION = sprintf "%d.%02d", q$Revision: 1.10 $ =~ /(\d+)\.(\d+)/; # ---------------------------------------------------------------------- -sub init { + +__PACKAGE__->_attributes( qw/ + name sql fields schema order +/); =pod @@ -60,20 +64,10 @@ sub init { Object constructor. - my $schema = SQL::Translator::Schema::View->new; + my $view = SQL::Translator::Schema::View->new; =cut - my ( $self, $config ) = @_; - - for my $arg ( qw[ name sql fields ] ) { - next unless $config->{ $arg }; - $self->$arg( $config->{ $arg } ) or return; - } - - return $self; -} - # ---------------------------------------------------------------------- sub fields { @@ -192,9 +186,58 @@ Get or set the view's SQL. } # ---------------------------------------------------------------------- +sub schema { + +=pod + +=head2 schema + +Get or set the view's schema object. + + $view->schema( $schema ); + my $schema = $view->schema; + +=cut + + my $self = shift; + if ( my $arg = shift ) { + return $self->error('Not a schema object') unless + UNIVERSAL::isa( $arg, 'SQL::Translator::Schema' ); + $self->{'schema'} = $arg; + } + + return $self->{'schema'}; +} + +# ---------------------------------------------------------------------- +sub equals { + +=pod + +=head2 equals + +Determines if this view is the same as another + + my $isIdentical = $view1->equals( $view2 ); + +=cut + + my $self = shift; + my $other = shift; + + return 0 unless $self->SUPER::equals($other); + return 0 unless $self->name eq $other->name; + return 0 unless $self->is_valid eq $other->is_valid; + return 0 unless $self->sql eq $other->sql; + return 0 unless $self->_compare_objects($self->fields, $other->fields); + return 0 unless $self->_compare_objects($self->extra, $other->extra); + return 1; +} + +# ---------------------------------------------------------------------- sub DESTROY { my $self = shift; - undef $self->{'table'}; # destroy cyclical reference + undef $self->{'schema'}; # destroy cyclical reference } 1; @@ -205,6 +248,6 @@ sub DESTROY { =head1 AUTHOR -Ken Y. Clark Ekclark@cpan.orgE +Ken Y. Clark Ekclark@cpan.orgE. =cut