2.2.0 • Published 2 years ago
pg-tag v2.2.0
pg-tag
Social Media Photo by Hu Chen on Unsplash
A tiny utility to safely query pg via template literals.
Available for SQLite too.
const {Pool} = require('pg');
const pg = require('pg-tag')(new Pool);
// returns result.rows[0]
const user = await pg.get`
SELECT
id, name, address
FROM
users
WHERE
email = ${email}
`;
// returns result.rows
const users = await pg.all`
SELECT *
FROM users
WHERE status = ${activeUser}
`;
// returns regular pg.query results
await pg.query`
SELECT *
FROM users
WHERE status = ${activeUser}
`;
// allow partial entries
let x = 1;
await pg.all`SELECT * FROM ${raw`table_${x}`}`;
pg.pool.end();