SQL::Translator::Schema::View - SQL::Translator view object
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 );
SQL::Translator::Schema::View is the view object.
SQL::Translator::Schema::View
Object constructor.
my $view = SQL::Translator::Schema::View->new;
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;
Determine whether the view is valid or not.
my $ok = $view->is_valid;
Get or set the view's name.
my $name = $view->name('foo');
Get or set the view's order.
my $order = $view->order(3);
Get or set the view's SQL.
my $sql = $view->sql('select * from foo');
Get or set the view's schema object.
$view->schema( $schema ); my $schema = $view->schema;
Determines if this view is the same as another
my $isIdentical = $view1->equals( $view2 );
Ken Y. Clark <kclark@cpan.org>.
To install SQL::Translator, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Translator
CPAN shell
perl -MCPAN -e shell install SQL::Translator
For more information on module installation, please visit the detailed CPAN module installation guide.