@aux4/db

1.0.33 • Public • Published

@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

Readme

Keywords

Package Sidebar

Install

npm i @aux4/db

Weekly Downloads

2

Version

1.0.33

License

Apache-2.0

Unpacked Size

21.5 kB

Total Files

13

Last publish

Collaborators

  • aux4-dev