@informaticon/devops.sql-script-runner
CLI to automatically run scripts in CI/CD environments and to automatically initialize new databases and users.
Last updated 8 months ago by informaticon.bot .
ISC · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install @informaticon/devops.sql-script-runner 
SYNC missed versions from official npm registry.

SQL script runner

CLI to automatically run scripts in CI/CD environments and to automatically initialize new databases and users.

Currently only availabe for MySQL databases.

Installation

npm i @informaticon/devops.sql-script-runner
./node_modules/.bin/ssr --version

Usage

CLI

ssr --database test --user test --password test

This will connect to the default mysql port on localhost and run the necessary scripts form ./scripts.

Configuration

Option CLI switch ENV variable Defaults
DB database --database SSR_DB_DATABASE
DB user --user SSR_DB_USER
DB password --password SSR_DB_PASSWORD ''
DB host --host SSR_DB_HOST 'localhost'
DB port --port SSR_DB_PORT 3306
DB socket path --socket-path SSR_DB_SOCKET_PATH
GCS proxy --gcs-proxy SSR_GCS_PROXY
GCS standalone proxy --gcs-proxy-standalone SSR_GCS_PROXY_STANDALONE
GCS proxy timeout --gcs-proxy-timeout SSR_GCS_PROXY_TIMEOUT 300000
Script directory --script-dir SSR_SCRIPT_DIRECTORY './scripts'

CLI switches will be used priror to ENV variables and paths will be resolved relative to the working directory.

You can use a .env file to configure your environment as well.

Initialization

IMPORTANT Make sure you save the generated password!

To initialize a new database and user use the --init option.

The given user must have the privileges to create databases and users.

Please use this option only locally on your system!

ssr --database test --user root --password "YOUR_ROOT_PW" --init

The following lines should be printed on success

Database test created
User test created
PLEASE SAVE YOUR NEW PASSWORD: YOUR_NEW_PASSWORD

Google Cloud SQL

The script runner has built in support for proxying to a Google Cloud SQL database. To use this functionality use --gcs-proxy

ssr --database test_db --user root --password "YOUR_ROOT_PW" --gcs-proxy informaticon-devops:europe-west1:devops --init

Standalone

The proxy can be used in standalone mode as well to use it with any given sql tool.

ssr --gcs-proxy-standalone informaticon-devops:europe-west1:devops

Current Tags

  • 2.1.10                                ...           latest (8 months ago)

26 Versions

  • 2.1.10                                ...           8 months ago
  • 2.1.8                                ...           8 months ago
  • 2.1.7                                ...           8 months ago
  • 2.1.6                                ...           8 months ago
  • 2.1.5                                ...           8 months ago
  • 2.1.4                                ...           8 months ago
  • 2.1.3                                ...           8 months ago
  • 2.1.2                                ...           8 months ago
  • 2.1.0                                ...           8 months ago
  • 2.0.1                                ...           8 months ago
  • 1.4.6                                ...           a year ago
  • 1.4.5                                ...           a year ago
  • 1.4.4                                ...           a year ago
  • 1.4.3                                ...           a year ago
  • 1.4.2                                ...           a year ago
  • 1.4.1                                ...           a year ago
  • 1.4.0                                ...           a year ago
  • 1.3.0                                ...           a year ago
  • 1.2.3                                ...           a year ago
  • 1.2.1                                ...           a year ago
  • 1.2.0                                ...           a year ago
  • 1.1.0                                ...           a year ago
  • 1.0.3                                ...           a year ago
  • 1.0.2                                ...           a year ago
  • 1.0.1                                ...           a year ago
  • 1.0.0                                ...           a year ago
Downloads
Today 0
This Week 0
This Month 26
Last Day 0
Last Week 26
Last Month 3
Dependencies (19)
Dev Dependencies (11)
Dependents (0)
None

Copyright 2014 - 2016 © taobao.org |