A database independent migration tool which support different migrations in different git branches
npm install klei-migrateklei-migrate
==================
* Database independent migrations
* Can be used:
* programatically as a local node module
* from command line
* as a gruntplugin with grunt-klei-migrate for Grunt
* Handling different migration versions in different branches with:
* automatic migration synchronization when used as a post-checkout hook for git
* Environment dependent migration history
* e.g. have a separate test database with its own migration history
* Write migrations in coffee-script
* N.B. klei-migrate does not depend on coffee-script itself, your project must have the module installed for it to work
* Migration template (used when creating new migrations)
* Can be set in a klei-migrate.json config file in cwd when running klei-migrate
To use from command line:
``bash`
$ npm install -g klei-migrate
To use as a module from within your project:
`bash`
$ npm install klei-migrate
And then:
`javascript`
var migrate = require('klei-migrate');
klei-migrate looks for a klei-migrate.json configuration file in cwd (current working directory) when it is run.
The configuration options that can be set via the klei-migrate.json is:
* template - Path to template to use when creating new migrations (a path relative to the config-file location)timeout
* - Set default timeout for all migrations in secondsenv
* - Set default environment when running migrationsdirectory
* - Set directory where you have your migration files (and the .migrated.json status file)coffee
* - Set default coffee-script mode
Example file:
`json`
{
"directory": "migs",
"template": ".migration.tpl.coffee",
"coffee": true,
"env": "stage",
"timeout": 600
}
`bash
$ klei-migrate new [options] Your Migration Name
$ klei-migrate create ...
`
Generates a migration file with name: in migrations/.
If no name is provided, like so:
`bash`
$ klei-migrate new
The generated name will be: .
Options:
* --template - Can be used to set path to the template to use when creating the migration--coffee
* - If set the migration file created will have .coffee extension instead of .js
Shows a list of possible migrations to run.
`bash`
$ klei-migrate dry [options] [arguments]
Options:
* --up or -u - If provided forces an up migration (default)--down
* or -d - If provided forces an down migration--limit
* or -l - Limits number of migrations to run to given number--one
* - The same as --limit 1
* or -e - Set environment name--coffee
* - Activate coffee-script mode
Arguments:
* name - Any given extra parameters is used to limit the migration list by name--one
* If combined with the migration list is limited to only the provided name, even though it's not the next in line to be run
Runs all migrations, according to provided options, and stops when everything is done or when a migration has failed.
`bash`
$ klei-migrate run [options] [arguments]
Options:
* --up or -u - If provided forces an up migration (default)--down
* or -d - If provided forces an down migration--limit
* or -l - Limits number of migrations to run to given number--one
* - The same as --limit 1
* or -t - Limit migration execution timeout (per migration) to given number in seconds--env
* or -e - Set environment name--coffee
* - Makes klei-migrate look for migration files with .coffee extension instead of .js
Arguments:
* name - Any given extra parameters is used to limit the migrations to run by name--one
* If combined with only the migration with the given name is run, even though it's not the next in line
Reverts all migrations from provided branch that does not exist in current branch,
and migrates all unmigrated migrations in current branch (used internally for post-checkout command, see below).
`bash`
$ klei-migrate sync [arguments]
Options:
* --timeout or -t - Limit migration execution timeout (per migration) to given number in seconds--env
* or -e - Set environment name--coffee
* - Run coffee-script migrations
Arguments:
* fromBranch - The branch where klei-migrate should look for migrations to migrate down
How to use as a git checkout hook:
Create a file .git/hooks/post-checkout with the following contents:
If klei-migrate is installed globally:
`bash`
#!/usr/bin/env sh
klei-migrate post-checkout "$@"
If installed as a local module:
`bash`
#!/usr/bin/env sh
node_modules/.bin/klei-migrate post-checkout "$@"
Reverts all migrations from provided branch that does not exist in current branch,
and migrates all unmigrated migrations in current branch (used internally for post-checkout command, see below).
`bash`
$ klei-migrate post-checkout [arguments]
Options:
* --timeout or -t - Limit migration execution timeout (per migration) to given number in seconds--env
* or -e - Set environment name--coffee
* - Run coffee-script migrations
Arguments:
fromRef - Set by git* The git hash for the branch where klei-migrate should look for migrations to migrate downtoRef
- Set by git* The current branch git hashflag
- Set by git* Is set to 1 for a branch checkout and 0 on a file checkout
Which migrations that has been run is stored in migrations/.migrated.json, so be sure to add it to your .gitignore.
The .migrated.json` file takes the current environment name into account, so that you can have e.g. a separate test database with its own migration history.