DBIx::Migration::Directories 0.05 review

Download

DBIx::Migration::Directories is a Perl module to install/remove/upgrade/downgrade SQL schemas. SYNOPSIS use DBIx::Migration::D

License:	Perl Artistic License
File size:	28K
Developer:	Tyler MacDonald

DBIx::Migration::Directories is a Perl module to install/remove/upgrade/downgrade SQL schemas.

SYNOPSIS

use DBIx::Migration::Directories;
use DBI;

my $dbh = DBI->connect('db:something:some=where', 'user', 'pass');

my $m = DBIx::Migration::Directories->new(
base => '/path/where/schemas/are',
schema => 'MyApp',
desired_version_from => 'MyApp::DataPackage',
dbh => $dbh
);

$m->migrate
or die "Installing database failed!";

DBIx::Migration::Directories provides you with a framework for managing database schemas easily. You create a directory to hold your schema, then in that directory create sub-directories containing the SQL code to install, remove, upgrade, or downgrade your schema. The schema layout is described in more detail in the "DIRECTORY LAYOUT" section below.

When asked to install, upgrade, or downgrade a database schema, DBIx::Migration::Directories will look at these directories and attempt to find the shortest path between two schema versions. It will then run the entire upgrade code in one transaction, rolling back if the upgrade fails.

Multiple database schemas can be managed within one database. DBIx::Migration::Directories currently requires two tables to exist in your database to track schema version numbers and upgrade/downgrade history. These tables are called "migration_schema_version" and "migration_schema_log", and are also manageable using DBIx::Migration::Directories.

Requirements:
Perl

DBIx::Migration::Directories 0.05 screenshot
Zoom

DBIx::Migration::Directories 0.05 keywords

DBIx::Migration::Directories 0.05: DBIx::Migration::Directories is a Perl module to install/remove/upgrade/downgrade SQL schemas. SYNOPSIS use DBIx::Migration::D
DBIx::Class::Schema::Loader::RelBuilder 0.03007: DBIx::Class::Schema::Loader::RelBuilder is a Perl module that builds relationships for DBIx::Class::Schema::Loader. This class bui
DBIx::Frame 1.06: DBIx::Frame is a Perl module for creating and maintaining DBI frameworks. SYNOPSIS use DBIx::Frame; DBIx::Frame->init('ser
DBIx::Wrapper::Config 0.01: DBIx::Wrapper::Config Perl module allows the use of a configuration file in XML specifying information required to connect to databas
DBIx::Recordset::Playground 1.12: DBIx::Recordset::Playground is a Perl module with working sample usages of DBIx::Recordset. This document serves several purposes
DBIx::SQLCrosstab 1.17: DBIx::SQLCrosstab Perl module creates a server-side cross tabulation from a database. SYNOPSIS use DBIx::SQLCrosstab;
DBIx::XML::DataLoader 1.1b: DBIx::XML::DataLoader contains a set of modules that are meant to work together

DBIx::Migration::Directories 0.05 review

Alternative/similar