This repository was archived by the owner on Jul 20, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 12
dsully/perl-dbix-migration
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
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->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.
AUTHOR
Sebastian Riedel, "sri@oook.de"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it
under the same terms as Perl itself.
About
DBIx::Migration
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published