/ 
Alzabo-0.71
River stage one • 2 direct dependents • 3 total dependents
/ Alzabo::Create::Column

NAME

Alzabo::Create::Column - Column objects for use in schema creation

SYNOPSIS

use Alzabo::Create::Column;

DESCRIPTION

This object represents a column. It holds data specific to a column. Additional data is held in a Alzabo::Create::ColumnDefinition object, which is used to allow two columns to share a type (which is good when two columns in different tables are related as it means that if the type of one is changed, the other is also.)

INHERITS FROM

Alzabo::Column

METHODS

new

Parameters

  • table => Alzabo::Create::Table object

  • name => $name

  • nullable => 0 or 1 (optional)

    Defaults to false.

  • sequenced => 0 or 1 (optional)

    Defaults to false.

  • default => $default (optional)

  • attributes => \@attributes (optional)

  • length => $length (optional)

  • precision => $precision (optional)

    One of either ...

  • type => $type

    ... or ...

  • definition => Alzabo::Create::ColumnDefinition object

  • comment => $comment

    An optional comment.

Returns

A new Alzabo::Create::Column object.

Throws

Alzabo::Exception::Params

alter

This method allows you to change a column's type, length, and precision as a single operation and should be instead of calling set_type followed by set_length.

Parameters

  • type => $type

  • length => $length (optional)

  • precision => $precision (optional)

set_type ($type)

Sets the column's type.

set_table (Alzabo::Create::Table object)

Returns/sets the Alzabo::Create::Table object in which this column is located.

set_name ($name)

Returns/sets the column's name (a string).

set_nullable (0 or 1)

Sets the nullability of the column (this determines whether nulls are allowed in the column or not). Must be 0 or 1.

Throws

Alzabo::Exception::Params

set_attributes (@attributes)

Sets the column's attributes. These are strings describing the column (for example, valid attributes in MySQL are 'PRIMARY KEY' or 'AUTO_INCREMENT').

add_attribute ($attribute)

Add an attribute to the column's list of attributes.

delete_attribute ($attribute)

Delete the given attribute from the column's list of attributes.

Throws

Alzabo::Exception::Params

set_default ($default)

Sets the column's default value.

set_length

Parameters

  • length => $length

  • precision => $precision (optional)

Sets the column's length and precision. The precision parameter is optional (though some column types may require it if the length is set).

set_sequenced (0 or 1)

Sets the value of the column's sequenced attribute.

Throws

Alzabo::Exception::Params

set_definition (Alzabo::Create::ColumnDefinition object)

Sets the Alzabo::Create::ColumnDefinition object which holds this column's type information.

set_comment ($comment)

Set the comment for the column object.