=pod
=encoding utf8
=head1 NAME
Mojolicious::Command::migration — MySQL migration tool for Mojolicious
=head1 VERSION
version 0.1
=head1 SYNOPSIS
Usage: APPLICATION migration [COMMAND] [OPTIONS]
mojo migration prepare
Commands:
status : Current database and schema version
install : Install a version to the database.
prepare : Makes deployment files for your database
upgrade : Upgrade the database.
downgrade : Downgrade the database.
=head1 DESCRIPTION
L<Mojolicious::Command::migration> MySQL migration tool.
=head1 USAGE
L<Mojolicious::Command::migration> uses app->db for mysql connection and following configuration:
{
'user' => 'USER',
'password' => 'PASSWORD',
'datasource' => { 'database' => 'DB_NAME'},
}
from
$ app->config->{db}->{mysql}
All deploy files saves to relative directory 'share/'. You can change it with 'MOJO_MIGRATION_SHARE' environment.
Current project state saves to 'tmp/.deploy_status' file. You can change directory with 'MOJO_MIGRATION_TMP' environment.
Note: we create directories automatically
=head1 COMMANDS
=head2 status
$ app migration status
Current version: 21
Deployed database is 20
Returns the state of the deployed database (if it is deployed) and the state of the current schema version. Sends this as a string to STDOUT
=head2 prepare
Makes deployment files for the current schema. If deployment files exist, will fail unless you "overwrite_migrations".
# have changes
$ app migration prepare
Current version: 21
New version is 22
# no changes
$ app migration prepare
Current version: 21
Nothing to upgrade. Exit
=head2 install
Installs either the current schema version (if already prepared) or the target version specified via any to_version flags.
If you try to install to a database that has already been installed (not empty), you'll get an error. Use flag force to set current database to schema version without changes database.
# last
$ app migration install
Current version: 21
Deploy database to 21
# target version
$ app migration install --to-version 10
Current version: 21
Deploy database to 10
# force install
$ app migration install --force
Current version: 21
Force deploy to 21
=head1 SOURCE REPOSITORY
L<
https://github.com/likhatskiy/Mojolicious-Command-migration>
=head1 AUTHOR
Alexey Likhatskiy, <
[email protected]>
=head1 LICENSE AND COPYRIGHT
Copyright (C) 2015 "Alexey Likhatskiy"
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
