@aux4/db-postgres
JavaScript
Install
$ npm install @aux4/db-postgres
Execute Query
const Database = require("@aux4/db-postgres");
const db = new Database({
host: "localhost",
user: "postgres",
password: "******",
database: "template1"
});
(async () => {
await db.open();
const { data } = await db.execute("select * from table where id = :id", { id: 1 });
console.log(JSON.stringify(data, null, 2));
await db.close();
})();
Query Stream
const Database = require("@aux4/db-postgres");
const db = new Database({
host: "localhost",
user: "postgres",
password: "******",
database: "template1"
});
const stream = await db.stream("select * from table where id = :id", { id: 1 });
stream.on("data", row => {
console.log(JSON.stringify(row, null, 2));
});
stream.on("error", err => {
console.error(err.message);
});
stream.on("close", async () => {
await db.close();
});
Command Line
Install
$ npm install --global @aux4/db
$ npm install --global @aux4/db-postgres
Usage
Execute Query
$ db execute --host localhost --port 5432 --user postgres --database template1 --query "select * from table where id = :id" --id 1
Stream Query
$ db stream --host localhost --port 5432 --user postgres --database template1 --query "select * from table where id = :id" --id 1
Using @aux4/config
create config.yaml
config:
dev:
postgres:
host: localhost
port: 5432
user: postgres
password: "******"
database: template1
$ db execute --configFile config.yaml --config dev/postgres --query "select * from table where id = :id" --id 1