@aux4/db
v1.0.33
Published
Database CLI
Downloads
71
Readme
@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