|
Alzabo::Create::Table - Table objects for schema creation |
Alzabo::Create::Column object)Alzabo::Create::Column object)Alzabo::Create::Column object)Alzabo::Create::Table object)Alzabo::Create::Column object)Alzabo::Create::ForeignKey object)Alzabo::Create::ForeignKey object)Alzabo::Create::Index object)Alzabo::Create::Index object)
Alzabo::Create::Table - Table objects for schema creation
use Alzabo::Create::Table;
This class represents tables in the schema. It contains column, index, and foreign key objects.
Alzabo::Table
Note: all relevant documentation from the superclass has been merged into this document.
Alzabo::Create::Schema object
A new Alzabo::Create::Table object.
The Alzabo::Create::Schema object to which this table
belongs.
The name of the table.
Changes the name of the table.
The Alzabo::Create::Column object that matches the name
given.
A list of Alzabo::Create::Column objects that match the
list of names given. If no list is provided, then it returns all
column objects for the table.
Creates a new Alzabo::Create::Column
object and adds it to the table. This object is the function's return
value.
In addition, if the 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 method except the
table parameter, which is automatically added.
add_primary_key method will be called after this new
column is made in order to make a it a primary key for the table.
Alzabo::Create::Column objectAlzabo::Create::Column object
A new Alzabo::Create::Column object.
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.
Alzabo::Create::Column objectAlzabo::Create::Column object (optional)Alzabo::Create::Column object (optional)
Alzabo::Create::Column object)Deletes a column from the table.
Alzabo::Create::Column objectand either ...
Alzabo::Create::Column object... or ...
Alzabo::Create::Column object
A primary key is one or more columns which must be unique in each row of the table. For a multi-column primary key, than the values of the columns taken in order must be unique. The order of a multi-column key is significant as most RDBMS's will create an index on the primary key using the same column order as is specified and column order usually matters in indexes.
An ordered list of column objects that make up the primary key for the table.
Alzabo::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.
Alzabo::Create::Column object)Delete the given column from the primary key.
Alzabo::Create::Column objectAlzabo::Create::Table object
A list of Alzabo::Create::ForeignKey objects from the
given column to the given table, if they exist. In scalar context,
returns the first item in the list. There is no guarantee as to what
the first item will be.
Alzabo::Create::Table object)
A list of all the Alzabo::Create::ForeignKey objects
to the given table. In scalar context, returns the first item in the
list. There is no guarantee as to what the first item will be.
Alzabo::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, returns the first item in the list. There is no guarantee as
to what the first item will be.
A list of all the Alzabo::Create::ForeignKey objects
for this table. In scalar context, returns the first item in the
list. There is no guarantee as to what the first item will be.
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.
A new Alzabo::Create::ForeignKey
object.
Alzabo::Create::ForeignKey object)Adds the given foreign key to the table.
Alzabo::Create::ForeignKey object)Deletes the given foreign key from the table
This method expect an index id as returned by the
Alzabo::Create::Index->id method.
The Alzabo::Create::Index object matching this id, if it
exists in the table.
All the Alzabo::Create::Index objects for the table.
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.
A new Alzabo::Create::Index object.
Alzabo::Create::Index object)Adds the given index to the table.
Alzabo::Create::Index object)Deletes an index from the table.
Dave Rolsky, <autarch@urth.org>
|
Alzabo::Create::Table - Table objects for schema creation |