Unix and Linux Discussions Tagged with view |
|
Thread / Thread Starter |
Last Post |
Replies |
Views |
Forum |
|
|
|
5 |
15,485 |
Shell Programming and Scripting |
|
|
|
2 |
3,307 |
UNIX for Beginners Questions & Answers |
|
|
|
38 |
14,774 |
What is on Your Mind? |
|
|
|
1 |
4,699 |
Shell Programming and Scripting |
|
|
|
8 |
3,928 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
9,537 |
Shell Programming and Scripting |
|
|
|
2 |
4,468 |
Solaris |
|
|
|
2 |
61,558 |
UNIX for Advanced & Expert Users |
|
|
|
0 |
1,094 |
Software Releases - RSS News |
|
|
|
3 |
3,738 |
Solaris |
|
|
|
0 |
944 |
Software Releases - RSS News |
|
|
|
0 |
1,235 |
Software Releases - RSS News |
|
|
|
10 |
379,588 |
Shell Programming and Scripting |
|
|
|
2 |
29,465 |
Shell Programming and Scripting |
|
|
|
0 |
889 |
Software Releases - RSS News |
|
|
|
4 |
9,935 |
HP-UX |
|
|
|
6 |
3,334 |
UNIX for Dummies Questions & Answers |
|
|
|
0 |
916 |
Software Releases - RSS News |
|
|
|
4 |
135,843 |
Shell Programming and Scripting |
|
|
|
0 |
4,751 |
Virtualization and Cloud Computing |
|
|
|
15 |
43,052 |
IP Networking |
|
|
|
9 |
5,625 |
Ubuntu |
|
|
|
0 |
2,037 |
Security Advisories (RSS) |
|
|
|
5 |
3,823 |
Shell Programming and Scripting |
|
|
|
8 |
17,498 |
Cybersecurity |
|
|
|
0 |
1,356 |
Security Advisories (RSS) |
|
|
|
1 |
3,554 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
4,364 |
Linux |
|
|
|
6 |
3,183 |
Linux |
|
|
|
0 |
10,882 |
UNIX for Dummies Questions & Answers |
|
|
|
0 |
1,089 |
Software Releases - RSS News |
|
|
|
0 |
2,062 |
Security Advisories (RSS) |
|
|
|
1 |
30,430 |
Solaris |
|
|
|
0 |
1,002 |
Software Releases - RSS News |
|
|
|
0 |
1,013 |
Software Releases - RSS News |
|
|
|
0 |
1,047 |
Software Releases - RSS News |
|
|
|
1 |
28,407 |
Programming |
|
|
|
0 |
1,835 |
Security Advisories (RSS) |
|
|
|
0 |
1,819 |
UNIX for Dummies Questions & Answers |
|
|
|
0 |
1,078 |
Security Advisories (RSS) |
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)