A database migrate module with cake task
CoffeeScript
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
config
db/migrate
lib
src
tests/functional
.gitignore
Cakefile
LICENSE
Makefile
README.md
package.json

README.md

cake-migrate

A database migrate module with cake task

usage

puts this line in your Cakefile

require('cake-db').tasks()

and add a db.json file in your config directory

// db.json
{
    "development": {
        "adapter": "mysql",
        "database": "cakedb",
        "user": "root",
        "password": "",
        "host": "127.0.0.1"
    },
    "production": {
        "adapter": "mysql",
        "database": "cakedb_production",
        "user": "root",
        "password": "",
        "host": "127.0.0.1"
    },
    "db_env": "development"
}

commands

  • cake db:migrate # migrate the database
  • cake db:migrate:create # create a migrate file
  • cake db:migrate:status # display status of migrations
  • cake db:rollback # rollback the post migrations

actions

  • createTable
  • dropTable (need self defined rollback function)
  • addColumn
  • dropColumn (need self defined rollback function)