@aux4/db

Install

$ npm install --global @aux4/db
...
$ npm install --global @aux4/db-oracle
$ npm install --global @aux4/db-mssql
$ npm install --global @aux4/db-postgres

Usage

Execute Query

$ db execute --host localhost --port 1521 --user sysadmin --service ORCL --query "select * from schema.table where id = :id" --id 1

Stream Query

$ db stream --host localhost --port 1521 --user sysadmin --service ORCL --query "select * from schema.table where id = :id" --id 1

Using @aux4/config

create config.yaml

config:
  dev:
    oracle:
      host: localhost
      port: 1521
      user: sysadmin
      password: "******"
      service: ORCL

$ db execute --configFile config.yaml --config dev/oracle --query "select * from schema.table where id = :id" --id 1

See Also

• aux4 website / npm / GitHub
• @aux4/config npm / GitHub