migr8r

Easily run Postgres migrations using SQL files

Usage no npm install needed!

<script type="module">
  import migr8r from 'https://cdn.skypack.dev/migr8r';
</script>

README

migr8r

Easily run Postgres migrations using SQL files

oclif Version CircleCI Appveyor CI Codecov Downloads/week License

Usage

$ npm install -g migr8r
$ migr8r COMMAND
running command...
$ migr8r (-v|--version|version)
migr8r/0.0.0 darwin-x64 node-v10.1.0
$ migr8r --help [COMMAND]
USAGE
  $ migr8r COMMAND
...

Commands

migr8r help [COMMAND]

display help for migr8r

USAGE
  $ migr8r help [COMMAND]

ARGUMENTS
  COMMAND  command to show help for

OPTIONS
  --all  see all commands in CLI

See code: @oclif/plugin-help

migr8r migrate

Run .sql files

USAGE
  $ migr8r migrate

OPTIONS
  -c, --connectionString=connectionString
  -d, --dir=dir                            [default: .]
  -h, --help                               show CLI help

EXAMPLE
  $ migr8r migrate
  Migrating...

See code: src/commands/migrate.ts

migr8r migrate:create NAME

Create a migration .sql file

USAGE
  $ migr8r migrate:create NAME

ARGUMENTS
  NAME  The name of the migration to create.

OPTIONS
  -d, --dir=dir  [default: .]
  -h, --help     show CLI help

EXAMPLE
  $ migr8r migrate:create add-user-table
  Creating migration: 2018-01-01-01-01-01-add-user-table.sql

See code: src/commands/migrate/create.ts

migr8r run [PATH]

Run .sql files

USAGE
  $ migr8r run [PATH]

OPTIONS
  -c, --connectionString=connectionString
  -h, --help                               show CLI help

EXAMPLE
  $ migr8r run path/to/file.sql
  Running...

See code: src/commands/run.ts