Alzabo::Table - Table objects
use Alzabo::Table; my $t = $schema->table('foo'); foreach $pk ($t->primary_keys) { print $pk->name; }
Objects in this class represent tables. They contain foreign key, index, and column objects.
The Alzabo::Schema object to which this table belongs.
Alzabo::Schema
The name of the table.
The Alzabo::Column object that matches the name given.
Alzabo::Column
If no arguments are given, returns a list of all Alzabo::Column objects in the schema, or in a scalar context the number of such tables. If one or more arguments are given, returns a list of table objects with those names, in the same order given.
A true or false value depending on whether or not the column exists in the table.
A primary key is one or more columns which must be unique in each row of the table. For a multi-column primary key, than the values of the columns taken in order must be unique. The order of a multi-column key is significant as most RDBMS's will create an index on the primary key using the same column order as is specified and column order usually matters in indexes.
In array context, return an ordered list of column objects that make up the primary key for the table. In scalar context, it returns the first element of that list.
The number of columsn in the table's primary key.
This method is really only needed if you're not sure that column belongs to the table. Otherwise just call the Alzabo::Column->is_primary_key method on the column object.
Alzabo::Column->is_primary_key
A boolean value indicating whether or not the column given is part of the table's primary key.
A column's attributes are strings describing the column (for example, valid attributes in MySQL are 'UNSIGNED' or 'ZEROFILL'.
A list of strings.
This method can be used to test whether or not a column has a particular attribute. By default, the check is case-insensitive.
attribute => $attribute
case_sensitive => 0 or 1 (defaults to 0)
A boolean value indicating whether or not the column has this particular attribute.
column => Alzabo::Column object
table => Alzabo::Table object
Alzabo::Table
A list of Alzabo::ForeignKey objects from the given column to the given table, if they exist. In scalar context, returns the first item in the list. There is no guarantee as to what the first item will be.
Alzabo::ForeignKey
A list of all the Alzabo::ForeignKey objects to the given table. In scalar context, returns the first item in the list. There is no guarantee as to what the first item will be.
Returns a list of all the Alzabo::ForeignKey objects that the given column is a part of, if any. In scalar context, returns the first item in the list. There is no guarantee as to what the first item will be.
A list of all the Alzabo::ForeignKey objects for this table. In scalar context, returns the first item in the list. There is no guarantee as to what the first item will be.
This method expects an index id as returned by the Alzabo::Index->id method.
Alzabo::Index->id
The Alzabo::Index object matching this id, if it exists in the table.
Alzabo::Index
A boolean indicating whether or not the table has an index with the same id.
All the Alzabo::Index objects for the table.
The comment associated with the table object, if any.
Dave Rolsky, <autarch@urth.org>
To install Alzabo, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Alzabo
CPAN shell
perl -MCPAN -e shell install Alzabo
For more information on module installation, please visit the detailed CPAN module installation guide.