orm-migrate

A command line tool for https://github.com/locomote/node-migrate-orm2 .

Installation

npm install -g orm-migrate

Usage

♪  node-orm-migrate git:(master) ✗ migrate --help

  Usage: migrate [options]

  Options:

    -h, --help      output usage information
    -V, --version   output the version number
    -g, --generate  Generate a migration
    -u, --up        Run up migrations
    -d, --down      Run down migrations

Generate a migration:

♪  node-orm-migrate git:(master) ✗ migrate -g create-foo
  create : /Users/nicholasf/code/nicholasf/node-orm-migrate/data/migrations/001-create-foo.js
Done.

Perform an up run:

♪  node-orm-migrate git:(master) ✗ migrate -u       
(orm/postgres) CREATE TABLE "orm_migrations" ("migration" TEXT NOT NULL , "direction" TEXT NOT NULL , "created_at" TEXT NOT NULL )
(orm/postgres) SELECT migration FROM orm_migrations ORDER BY created_at DESC LIMIT 1;
  up : data/migrations/001-foo.js.js
(orm/postgres) INSERT INTO orm_migrations(migration, direction, created_at) VALUES('001-foo.js.js', 'up', '2014-05-03T05:42:29.188Z');
  migration : complete
Done.

Perform a down run:

♪  node-orm-migrate git:(master) ✗ migrate -d
(orm/postgres) CREATE TABLE "orm_migrations" ("migration" TEXT NOT NULL , "direction" TEXT NOT NULL , "created_at" TEXT NOT NULL )
(orm/postgres) SELECT migration FROM orm_migrations ORDER BY created_at DESC LIMIT 1;
(orm/postgres) SELECT migration FROM orm_migrations ORDER BY created_at DESC LIMIT 1;
  down : data/migrations/001-foo.js.js
(orm/postgres) INSERT INTO orm_migrations(migration, direction, created_at) VALUES('001-foo.js.js', 'down', '2014-05-03T05:42:52.659Z');
  migration : complete
Done.

That's it! (Made with beer)