Mojolicious::Command::migration — MySQL migration tool for Mojolicious
version 0.1
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.
Mojolicious::Command::migration MySQL migration tool.
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
$ 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
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
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
https://github.com/likhatskiy/Mojolicious-Command-migration
Alexey Likhatskiy, <likhatskiy@gmail.com>
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.
To install Mojolicious::Command::migration, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Mojolicious::Command::migration
CPAN shell
perl -MCPAN -e shell install Mojolicious::Command::migration
For more information on module installation, please visit the detailed CPAN module installation guide.