Alzabo::Column - Column objects
use Alzabo::Column; foreach my $c ($table->columns) { print $c->name; }
This object represents a column. It holds data specific to a column.
The table object in which this column is located.
The column's name as a string.
A boolean value indicating whether or not NULLs are allowed in this column.
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.
The column's type as a string.
The meaning of a sequenced column varies from one RDBMS to another. In those with sequences, it means that a sequence is created and that values for this column will be drawn from it for inserts into this table. In databases without sequences, the nearest analog for a sequence is used (in MySQL the column is given the AUTO_INCREMENT attribute, in Sybase the identity attribute).
In general, this only has meaning for the primary key column of a table with a single column primary key. Setting the column as sequenced means its value never has to be provided to when calling Alzabo::Runtime::Table->insert.
Alzabo::Runtime::Table->insert
A boolean value indicating whether or not this column is sequenced.
The default value of the column as a string, or undef if there is no default.
The length attribute of the column, or undef if there is none.
The precision attribute of the column, or undef if there is none.
A boolean value indicating whether or not this column is part of its table's primary key.
A boolean value indicating whether the column is a numeric type column.
A boolean value indicating whether the column is a character type column.
This is true only for any columns which are defined to hold text data, regardless of size.
A boolean value indicating whether the column is a date type column.
A boolean value indicating whether the column is a datetime type column.
A boolean value indicating whether the column is a time type column.
A boolean value indicating whether the column is a blob column.
This is true for any columns defined to hold binary data, regardless of size.
This methods returns one of the following strings:
The definition object is very rarely of interest. Use the type method if you are only interested in the column's type.
type
The Alzabo::ColumnDefinition object which holds this column's type information.
Alzabo::ColumnDefinition
The comment associated with the column 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.