DOKK / manpages / debian 12 / libalzabo-perl / Alzabo::Column.3pm.en
Alzabo::Column(3pm) User Contributed Perl Documentation Alzabo::Column(3pm)

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.

Returns the table object to which this column belongs.

Returns the column's name as a string.

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

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:

  • attribute => $attribute
  • case_sensitive => 0 or 1 (defaults to 0)

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

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

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

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

Returns true if the default is intended to be provided to the DBMS as-is, without quoting, fore example "NOW()" or "current_timestamp".

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.

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 numeric type column.

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 date type column.

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

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

Returns a boolean value indicating whether the column is a time interval type column.

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.

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.

This methods returns the "Alzabo::ColumnDefinition" object which holds this column's type information.

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

Dave Rolsky, <autarch@urth.org>

2022-06-14 perl v5.34.0