GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  ALZABO::RUNTIME::COLUMN (3)

.ds Aq ’

NAME

Alzabo::Runtime::Column - Column objects

CONTENTS

SYNOPSIS



  use Alzabo::Runtime::Column;



DESCRIPTION

This object represents a column. It holds data specific to a column.

INHERITS FROM

Alzabo::Column

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

METHODS

    table

Returns the table object to which this column belongs.

    name

Returns the column’s name as a string.

    nullable

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

    attributes

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.

    has_attribute

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:
o attribute => $attribute
o case_sensitive => 0 or 1 (defaults to 0)
It returns a boolean value indicating whether or not the column has this particular attribute.

    type

Returns the column’s type as a string.

    sequenced

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.

    default

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

    default_is_raw

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

    length

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

    precision

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

    is_primary_key

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

    is_numeric

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

    is_integer

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

    is_floating_point

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

    is_character

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.

    is_date

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

    is_datetime

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

    is_time

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

    is_time_interval

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

    is_blob

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.

    generic_type

This methods returns one of the following strings:
integer
floating_point
character
date
datetime
time
blob
unknown

    definition

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::Runtime::ColumnDefinition object which holds this column’s type information.

    comment

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

    alias

Takes the following parameters:
o as => $name
This method returns an object that can be used in calls to the table and schema select() methods in order to change the name given to the column if next_as_hash() is called on the Alzabo::DriverStatement returned by the aforementioned select() method.

AUTHOR

Dave Rolsky, <autarch@urth.org>
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 ALZABO::RUNTIME::COLUMN (3) 2016-04-03

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.