debian man page for sql::translator::schema::view

Query: sql::translator::schema::view

OS: debian

Section: 3pm

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

SQL::Translator::Schema::View(3pm)			User Contributed Perl Documentation			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; tables Gets and set the tables the SELECT mentions. Accepts a string, list or arrayref; returns an array or array reference. Will unique the table names and keep them in order by the first occurrence of a field name. $view->tables('foo'); $view->tables('foo', 'bar'); $view->tables( 'foo, bar' ); $view->tables( [ 'foo', 'bar' ] ); $view->tables( qw[ foo bar ] ); my @tables = $view->tables; options Gets and sets a list of options on the view. $view->options('ALGORITHM=UNDEFINED'); my @options = $view->options; 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>. perl v5.14.2 2012-05-01 SQL::Translator::Schema::View(3pm)
Related Man Pages
dbix::class::resultsource::view5.18(3) - mojave
dbix::class::resultsource::view(3pm) - debian
sql::translator::producer::xml::sqlfairy(3pm) - debian
sql::translator::schema(3pm) - debian
sql::translator::schema::view(3pm) - debian
Similar Topics in the Unix Linux Community
How to redirect value from sql select statment to unix variable
Pdisks
Bold Characters
Creating CSV files
Can't able to view the data in a file using the VI editor