Rechercher une page de manuel
SQL::Translator::Schema::View.3pm
Langue: en
Version: 2010-06-03 (ubuntu - 24/10/10)
Section: 3 (Bibliothèques de fonctions)
NAME
SQL::Translator::Schema::View - SQL::Translator view objectSYNOPSIS
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 anothermy $isIdentical = $view1->equals( $view2 );
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre