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
3 years ago
2.0.3
3 years ago
2.0.2
3 years ago
2.0.13
3 years ago
2.0.5
3 years ago
2.0.14
3 years ago
2.0.4
3 years ago
2.0.11
3 years ago
2.0.7
3 years ago
2.0.12
3 years ago
2.0.6
3 years ago
2.0.9
3 years ago
2.0.10
3 years ago
2.0.8
3 years ago
2.0.1
3 years ago
2.0.0
3 years ago
1.1.2
3 years ago
1.1.1
4 years ago
1.1.0
4 years ago
1.0.1
4 years ago
1.0.0
4 years ago