Relevanzz: Clickhouse migrate cli

CLI Install

npm install -g @dactilar/clickhouse-migrate
# -- or --
yarn global add @dactilar/clickhouse-migrate

##### IMPORTANT

You must have .npmrc correctly installed in your home directory to install private packages.

Install

Requires a clickhouse.js file at the root of the target repository.

// clickhouse.js example
module.exports = {
  host: process.env.WAREHOUSE_HOST,
  port: process.env.WAREHOUSE_PORT,
  user: process.env.WAREHOUSE_USER,
  password: process.env.WAREHOUSE_PASSWORD,
  protocol: process.env.WAREHOUSE_PROTOCOL,
  pathname: "/",
  queryOptions: {
    database: process.env.WAREHOUSE_DATABASE
  },
  migrations: {
    directory: "./migrations/clickhouse"
  }
}

API

ch migrate:make // Creates a new migration
ch migrate:list // Lists migrations
ch migrate:latest // Migrates to the latest file
ch migrate:rollback <all> // Migrates one file down, or back to the root if command all is passed