2.0.18 • Published 2 years ago
@sodra/pg v2.0.18
@sodra/pg
Install
npm i @sodra/pg
Usage
import PG from '@sodra/pg'
const pg = new PG({
connectionString: ...,
})
type User = {
user_id: string
}
const { rows } = await pg.query<User>(`SELECT * FROM users WHERE user_id=$userId`, { userId })
Simple queries
// SELECT * FROM users WHERE user_id=$userId
pg.select('users', { userId })
// SELECT name FROM users WHERE user_id=$userId
pg.select('users', 'name', { userId })
// SELECT count(1) FROM users WHERE user_id=$userId
pg.count('users', { userId })
// INSERT INTO users (user_id, name) VALUES ($userId, $userName)
pg.insert('users', { userId, name })
// UPDATE users SET name=$name WHERE user_id=$userId
pg.update('users', { name }, { userId })
// DELETE FROM users WHERE user_id=$userId
pg.del('users', { userId })
Transactions
const batch = pg.beginBatch()
batch.insert('...'),
batch.update('...'),
batch.del('...')
await batch.exec()
2.0.16
2 years ago
2.0.17
2 years ago
2.0.18
2 years ago
2.0.15
2 years ago
2.0.3
2 years ago
2.0.2
2 years ago
2.0.13
2 years ago
2.0.5
2 years ago
2.0.14
2 years ago
2.0.4
2 years ago
2.0.11
2 years ago
2.0.7
2 years ago
2.0.12
2 years ago
2.0.6
2 years ago
2.0.9
2 years ago
2.0.10
2 years ago
2.0.8
2 years ago
2.0.1
2 years ago
2.0.0
2 years ago
1.1.2
3 years ago
1.1.1
3 years ago
1.1.0
4 years ago
1.0.1
4 years ago
1.0.0
4 years ago