Alzabo::Create::Schema - Schema objects for schema creation
use Alzabo::Create::Schema;
This class represents the whole schema. It contains table objects, which in turn contain columns, indexes, etc. It contains methods that act globally on the schema, including methods to save it to disk, create itself in an RDBMS, create relationships between tables, etc.
Alzabo::Schema
name => $name
This is the name of the schema, and will be the name of the database in the RDBMS.
rdbms => $rdbms
This is a string identifying the RDBMS. The allowed values are returned from the Alzabo::RDBMSRules->available method. These are values such as 'MySQL', 'PostgreSQL', etc.
Alzabo::RDBMSRules->available
A new Alzabo::Create::Schema object.
Alzabo::Create::Schema
Alzabo::Exception::Params Alzabo::Exception::System
Alzabo::Exception::Params
Alzabo::Exception::System
Returns a schema object previously saved to disk.
The Alzabo::Create::Schema object specified by the name parameter.
Attempts to connect to a database and instantiate a new schema object based on information in the specified database. The returned object will have its instantiated value set to true so that subsequent changes will lead to SQL diffs, as opposed to SQL to create the database from scratch.
The schema object returned by this method will have its instantiated attribute set as true. This means that calling the make_sql method on the object won't generate any SQL. To do this you'd have to first call $schema->set_instantiated(0) and then $schema->make_sql.
make_sql
$schema->set_instantiated(0)
$schema->make_sql
The name of the database with which to connect.
See the new method documentation for an explanation of this parameter.
new
In addition, this method takes any parameters that can be used when connecting to the RDBMS, including user, password, host, and port.
user
password
host
port
Change the schema name. Since schemas are saved on disk with filenames based on the schema name, this deletes the files for the old name. Call save_to_file immediately afterwards if you want to make sure you have a copy of the schema saved.
save_to_file
This method makes a new table and adds it to the schema, the parameters given are passed directly to the Alzabo::Create::Table->new method. The schema parameter is filled in automatically.
Alzabo::Create::Table->new
The Alzabo::Create::Table object created.
Alzabo::Create::Table
Removes the given table from the schema. This method will also delete all foreign keys in other tables that point at the given table.
Add a table to the schema. If a before or after parameter is given then the move_table method will be called to move the new table to the appropriate position.
move_table
table => Alzabo::Create::Table object
after => Alzabo::Create::Table object (optional)
... or ...
before => Alzabo::Create::Table object (optional)
Allows you to change the order of the tables as they are stored in the schema.
The table to move.
and either ...
before => Alzabo::Create::Table object
Move the table before this table
after => Alzabo::Create::Table object
Move the table after this table.
Creates a relationship between two tables. This involves creating Alzabo::Create::ForeignKey objects in both tables. If the columns_from and columns_to parameters are not specified then the schema object attempts to calculate the proper values for these attributes.
Alzabo::Create::ForeignKey
columns_from
columns_to
To do this, Alzabo attempts to determine the dependencies of the tables. If you have specified a cardinality of 1..1, or n..1,n cases where both tables are independent, or where they are both dependent (which makes little sense but its your code so...) then the table_from is treated as being the dependent table for the purposes of determining
table_from
If no columns with the same names exist in the other table, then columns with that name will be created. Otherwise, it changes the dependent columns so that their Alzabo::Create::ColumnDefinition objects are the same as the columns in the table upon which it is dependent, meaning that changes to the type of one column affects both at the same time.
Alzabo::Create::ColumnDefinition
If you want to make multi-column relation, the assumption is that the order of the columns is significant. In other words, the first column in the columns_from parameter is assumed to correspond to the first column in hte columns_to parameter and so on.
The number of columns given in columns_from and columns_to must be the same except when creating a many to many relationship.
If the cardinality is many to many then a new table will be created to link the two tables together. This table will contain the primary keys of both the tables passed into this function. It will contain foreign keys to both of these tables as well and these tables will be linked to this new table.
table_from => Alzabo::Create::Table object (optional if columns_from is provided)
table_to => Alzabo::Create::Table object (optional if columns_to is provided)
columns_from => Alzabo::Create::Column object (optional if table_from is provided)
Alzabo::Create::Column
columns_to => Alzabo::Create::Column object (optional if table_to is provided)
cardinality => [1, 1], [1, 'n'], ['n', 1], or ['n', 'n']
from_is_dependent => $boolean
to_is_dependent => $boolean
This method causes the schema to connect to the RDBMS, create a new database if necessary, and then execute whatever SQL is necessary to make that database match the current state of the schema object. If the schema has been instantiated previously, then it will generate the SQL necessary to change the database. This may be destructive (dropping tables, columns, etc) so be careful. This will cause the schema to be marked as instantiated.
Wherever possible, existing data will be preserved.
This method takes any parameters that can be used when connecting to the RDBMS, including user, password, host, and port.
The value of the schema's instantiated attribute. It is true if the schema has been created in an RDBMS backend, otherwise it is false.
Set the schema's instantiated attribute as true or false.
An array containing the SQL statements necessary to either create the database from scratch or update the database to match the schema object. See the create method for more details.
create
Drops the database/schema from the RDBMS. This will cause the schema to be marked as not instantiated. This method does not delete the Alzabo files from disk. To do this, call the delete method.
delete
This method will look at the schema as it exists in the RDBMS backend, and make any changes that are necessary in order to make this backend schema match the Alzabo schema object. If there is no corresponding schema in the RDBMS backend, then this method is equivalent to the create method.
After this method is called, the schema will be considered to be instantiated.
This method will never be perfect because some RDBMS backends alter table definitions as they are created. For example, MySQL has default column "lengths" for all of its integer columns. Alzabo tries to account for these.
In the end, this means that Alzabo may never think that a schema in the RDBMS exactly matches the state of the Alzabo schema object. Even immediately after running this method, running it again may still cause it to execute SQL commands. Fortunately, the SQL it generates will not cause anything to break.
This method returns an array containing the set of SQL statements that would be used by the sync_backend_sql method.
sync_backend_sql
If there is no corresponding schema in the RDBMS backend, then this method returns the SQL necessary to create the schema from scratch.
Removes the schema object from disk. It does not delete the database from the RDBMS. To do this you must call the drop method first.
drop
This method creates a new object identical to the one that the method was called on, except that this new schema has a different name, it does not yet exist on disk, its instantiation attribute is set to false.
Saves the schema to a file on disk.
Dave Rolsky, <autarch@urth.org>
To install Alzabo, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Alzabo
CPAN shell
perl -MCPAN -e shell install Alzabo
For more information on module installation, please visit the detailed CPAN module installation guide.