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

  use Alzabo::Create::Column;

This object represents a column. It holds data specific to a column. Additional data is held in a CWAlzabo::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.)

CWAlzabo::Column

Note: all relevant documentation from the superclass has been merged into this document.

The constructor accepts the following parameters:

* nullable => 0 or 1 (optional)

Defaults to false.

* sequenced => 0 or 1 (optional)

Defaults to false.

* attributes => \@attributes (optional)

One of either ... ... or ... An optional comment.

It returns a new CWAlzabo::Create::Column object.

Throws: CWAlzabo::Exception::Params

Returns the column's type as a string.

This method allows you to change a column's type, length, and precision as a single operation. It should be instead of calling CWset_type() followed by CWset_length().

It takes the following parameters:

Throws: CWAlzabo::Exception::Params, CWAlzabo::Exception::RDBMSRules

Sets the column's type.

Throws: CWAlzabo::Exception::Params, CWAlzabo::Exception::RDBMSRules Sets the CWAlzabo::Create::Table object in which this column is located.

Throws: CWAlzabo::Exception::Params

Returns the column's name as a string.

Sets the column's name (a string).

Throws: CWAlzabo::Exception::Params, CWAlzabo::Exception::RDBMSRules

Returns a boolean value indicating whether or not NULLs are allowed in this column.

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

Throws: CWAlzabo::Exception::Params

A column's attributes are strings describing the column (for example, valid attributes in MySQL are 'UNSIGNED' or 'ZEROFILL'.

This method returns a list of strings of such strings.

This method can be used to test whether or not a column has a particular attribute. By default, the check is case-insensitive.

It takes the following parameters:

* case_sensitive => 0 or 1 (defaults to 0)

It returns a boolean value indicating whether or not the column has this particular attribute.

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

Throws: CWAlzabo::Exception::RDBMSRules

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

Throws: CWAlzabo::Exception::RDBMSRules

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

Throws: Throws: CWAlzabo::Exception::Params, CWAlzabo::Exception::RDBMSRules

Returns the default value of the column as a string, or undef if there is no default.

Sets the column's default value.

Returns the length attribute of the column, or undef if there is none.

Returns the precision attribute of the column, or undef if there is none.

This method takes the following parameters:

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

Throws: CWAlzabo::Exception::RDBMSRules

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 CWAlzabo::Runtime::Table->insert.

Returns a boolean value indicating whether or not this column is sequenced.

Sets the value of the column's sequenced attribute.

Throws: CWAlzabo::Exception::Params, CWAlzabo::Exception::RDBMSRules

Returns a boolean value indicating whether or not this column is part of its table's primary key.

Returns a boolean value indicating whether the column is a numeric type column.

Returns 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.

Returns 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.

The definition object is very rarely of interest. Use the CWtype() method if you are only interested in the column's type.

This methods returns the CWAlzabo::Create::ColumnDefinition object which holds this column's type information. Sets the CWAlzabo::Create::ColumnDefinition object which holds this column's type information.

If the column's name has been changed since the last time the schema was instantiated, this method returns the column's previous name.

Returns the comment associated with the column object, if any.

Set the comment for the column object.