NAME

DBIx::Migration - Seamless DB schema up- and downgrades

SYNOPSIS

# migrate.pl
my $m = DBIx::Migration->new(
    {
        dsn => 'dbi:SQLite:/Users/sri/myapp/db/sqlite/myapp.db',
        dir => '/Users/sri/myapp/db/sqlite'
    }
);

my $version = $m->version;   # Get current version from database
$m->migrate( 2 );            # Migrate database to version 2

# /Users/sri/myapp/db/sqlite/schema_1_up.sql
CREATE TABLE foo (
    id INTEGER PRIMARY KEY,
    bar TEXT
);

# /Users/sri/myapp/db/sqlite/schema_1_down.sql
DROP TABLE foo;

# /Users/sri/myapp/db/sqlite/schema_2_up.sql
CREATE TABLE bar (
    id INTEGER PRIMARY KEY,
    baz TEXT
);

# /Users/sri/myapp/db/sqlite/schema_2_down.sql
DROP TABLE bar;

DESCRIPTION

Seamless DB schema up- and downgrades.

METHODS

$self->debug( $debug )

Enable/Disable debug messages.

$self->dir( $dir )

Get/Set directory.

$self->dsn( $dsn )

Get/Set dsn.

$self->dbh( $dsn )

Get/Set dbh.

$self->migrate( $version )

Migrate database to version.

$self->password

Get/Set database password.

$self->username( $username )

Get/Set database username.

$self->version

Get migration version from database. Will be undef if no migration has taken place yet.

AUTHOR

Sebastian Riedel, <kraihx@gmail.com>

CONTRIBUTORS

Dan Sully, <dan+github@sully.org>

Marcus Ramberg, <marcus@nordaaker.com>

Steven Jenkin, <sjenkin@venda.com>

Sven Willenbuecher, <sven.willenbuecher@gmx.de>

COPYRIGHT

Copyright 2004-2005 Sebastian Riedel. All rights reserved.

This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.