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::CREATE::TABLE (3)

.ds Aq ’

NAME

Alzabo::Create::Table - Table objects for schema creation

CONTENTS

SYNOPSIS



  use Alzabo::Create::Table;



DESCRIPTION

This class represents tables in the schema. It contains column, index, and foreign key objects.

INHERITS FROM

Alzabo::Table

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

METHODS

    new

The constructor takes the following parameters:
o schema => Alzabo::Create::Schema object

The schema to which this table belongs.

o name => $name
o attributes => \@attributes
o comment => $comment

An optional comment.

It returns a new Alzabo::Create::Table object.

Throws: Alzabo::Exception::Params

    schema

Returns the Alzabo::Create::Schema object to which this table belongs.

    name

Returns the name of the table.

    set_name ($name)

Changes the name of the table.

Throws: Alzabo::Exception::Params, Alzabo::Exception::RDBMSRules

    column ($name)

Returns the Alzabo::Create::Column object that matches the name given.

An Alzabo::Exception::Params exception is throws if the table does not contain the column.

    columns (@optional_list_of_column_names)

If no arguments are given, returns a list of all Alzabo::Create::Column objects in the schema, or in a scalar context the number of such tables. If one or more arguments are given, returns a list of table objects with those names, in the same order given.

An Alzabo::Exception::Params exception is throws if the table does not contain one or more of the specified columns.

    has_column ($name)

Returns a voolean value indicating whether the column exists in the table.

    make_column

Creates a new Alzabo::Create::Column object and adds it to the table. This object is the function’s return value.

In addition, if a before or after parameter is given, the move_column() method is called to move the new column.

This method takes all of the same parameters as the Alzabo::Create::Column->new() method except the table parameter, which is automatically supplied.

This method also accepts an additional parameter, primary_key, indicating whether or not the column is part of the table’s primary key.

Returns a new Alzabo::Create::Column object.

Throws: Alzabo::Exception::Params, Alzabo::Exception::RDBMSRules

    add_column

Adds a column to the table. If a before or after parameter is given then the move_column() method will be called to move the new column to the appropriate position.

It takes the following parameters:
o column => Alzabo::Create::Column object
o after => Alzabo::Create::Column object (optional)

... or ...

o before => Alzabo::Create::Column object (optional)
Throws: Alzabo::Exception::Params, Alzabo::Exception::RDBMSRules

delete_column (CWAlzabo::Create::Column object)

Deletes a column from the table.

Throws: Alzabo::Exception::Params

    move_column

This method takes the following parameters:
o column => Alzabo::Create::Column object

The column to move.

and either ...

o before => Alzabo::Create::Column object

Move the column before this column

... or ...

o after => Alzabo::Create::Column object

Move the column after this column.

Throws: Alzabo::Exception::Params

    primary_key

In array context, return an ordered list of column objects that make up the primary key for the table. In scalar context, it returns the first element of that list.

    primary_key_size

The number of columns in the table’s primary key.

add_primary_key (CWAlzabo::Create::Column object)

Make the given column part of the table’s primary key. The primary key is an ordered list of columns. The given column will be added to the end of this list.

Throws: Alzabo::Exception::Params

delete_primary_key (CWAlzabo::Create::Column object)

Delete the given column from the primary key.

Throws: Alzabo::Exception::Params

    foreign_keys

Thie method takes two parameters:
o column => Alzabo::Create::Column object
o table => Alzabo::Create::Table object
It returns a list of Alzabo::Create::ForeignKey objects <B>fromB> the given column <B>toB> the given table, if they exist. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be.

An Alzabo::Exception::Params exception is throws if the table does not contain the specified column.

foreign_keys_by_table (CWAlzabo::Create::Table object)

Returns a list of all the Alzabo::Create::ForeignKey objects <B>toB> the given table. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be.

foreign_keys_by_column (CWAlzabo::Create::Column object)

Returns a list of all the Alzabo::Create::ForeignKey objects that the given column is a part of, if any. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be.

An Alzabo::Exception::Params exception is throws if the table does not contain the specified column.

    all_foreign_keys

Returns a list of all the Alzabo::Create::ForeignKey objects for this table. In scalar context, it returns the first item in the list. There is no guarantee as to what the first item will be.

    make_foreign_key (see below)

Takes the same parameters as the Alzabo::Create::ForeignKey->new method except for the table parameter, which is automatically added. The foreign key object that is created is then added to the table.

If the foreign key being made is 1..1 or 1..n, then a unique index will be created on the columns involved in the 1 side of the foreign key, unless they are the table’s primary key.

Returns a new Alzabo::Create::ForeignKey object.

Throws: Alzabo::Exception::Params

add_foreign_key (CWAlzabo::Create::ForeignKey object)

Adds the given foreign key to the table.

Throws: Alzabo::Exception::Params

delete_foreign_key (CWAlzabo::Create::ForeignKey object)

Deletes the given foreign key from the table

Throws: Alzabo::Exception::Params

    index ($index_id)

This method expects an index id as returned by the Alzabo::Create::Index->id method as its parameter.

The Alzabo::Create::Index object matching this id, if it exists in the table.

An Alzabo::Exception::Params exception is throws if the table does not contain the specified index.

    has_index ($index_id)

This method expects an index id as returned by the Alzabo::Create::Index->id method as its parameter.

Returns a boolean indicating whether the table has an index with the same id.

    indexes

Returns all the Alzabo::Create::Index objects for the table.

    make_index

Takes the same parameters as the Alzabo::Create::Index->new() method except for the table parameter, which is automatically added. The index object that is created is then added to the table.

Returns the new Alzabo::Create::Index object.

Throws: Alzabo::Exception::Params

add_index (CWAlzabo::Create::Index object)

Adds the given index to the table.

Throws: Alzabo::Exception::Params

delete_index (CWAlzabo::Create::Index object)

Deletes the specified index from the table.

Throws: Alzabo::Exception::Params

    attributes

A table’s attributes are strings describing the table (for example, valid attributes in MySQL are thing like TYPE = INNODB.

Returns a list of strings.

    has_attribute

This method can be used to test whether or not a table has a particular attribute. By default, the check is case-insensitive.
o attribute => $attribute
o case_sensitive => 0 or 1 (defaults to 0)
Returns a boolean value indicating whether the table has this particular attribute.

    set_attributes (@attributes)

Sets the tables’s attributes. These are strings describing the table (for example, valid attributes in MySQL are TYPE = INNODB or AUTO_INCREMENT = 100).

You can also set table constraints as attributes. Alzabo will generate correct SQL for both actual attributes and constraints.

    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.

Alzabo::Exception::Params

    former_name

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

    comment

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

    set_comment ($comment)

Set the comment for the table object.

AUTHOR

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


perl v5.20.3 ALZABO::CREATE::TABLE (3) 2016-04-03

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