Linux Certif

Toute la documentation sur la certification Linux LPI

SQL::Translator::Schema::View.3pm

NAME

SQL::Translator::Schema::View - SQL::Translator view object

SYNOPSIS

   use SQL::Translator::Schema::View;
   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
   );
 
 

DESCRIPTION

"SQL::Translator::Schema::View" is the view object.

METHODS

new

Object constructor.

   my $view = SQL::Translator::Schema::View->new;
 
 

fields

Gets and set the fields the constraint is on. Accepts a string, list or arrayref; returns an array or array reference. Will unique the field names and keep them in order by the first occurrence of a field name.

   $view->fields('id');
   $view->fields('id', 'name');
   $view->fields( 'id, name' );
   $view->fields( [ 'id', 'name' ] );
   $view->fields( qw[ id name ] );
 
   my @fields = $view->fields;
 
 

is_valid

Determine whether the view is valid or not.

   my $ok = $view->is_valid;
 
 

name

Get or set the view's name.

   my $name = $view->name('foo');
 
 

order

Get or set the view's order.

   my $order = $view->order(3);
 
 

sql

Get or set the view's SQL.

   my $sql = $view->sql('select * from foo');
 
 

schema

Get or set the view's schema object.

   $view->schema( $schema );
   my $schema = $view->schema;
 
 

equals

Determines if this view is the same as another

   my $isIdentical = $view1->equals( $view2 );
 
 

AUTHOR

Ken Youens-Clark <kclark@cpan.org>.