0.0.22 • Published 2 months ago
postgres-pdo v0.0.22
Postgres Data Object
Pdo wrapper for https://github.com/porsager/postgres
Usage
Install
$ npm i -S postgres-pdo
Connect
const postgres = require('postgres');
const Pdo = require('postgres-pdo');
const options = {
// Connection parameters
}
const sql = postgres(options);
const pdo = new Pdo(sql);
Select
const result = await pdo
.select()
.from('table_name')
.whereIn('id', [1, 2])
.orWhere('id', '=', 3)
.execute();
console.log(result);
Insert
await pdo
.insert(['name', 'age'])
.into('table_name')
.values(['John', 30])
.execute();
Update
await pdo
.update({
name: 'John',
age: 30
})
.table('table_name')
.where('id', '=', 1)
.execute();
Delete
await pdo
.delete('table_name')
.where('id', '>', 1)
.execute();
0.0.22
2 months ago
0.0.20
1 year ago
0.0.21
1 year ago
0.0.19
1 year ago
0.0.18
2 years ago
0.0.16
2 years ago
0.0.17
2 years ago
0.0.14
2 years ago
0.0.15
2 years ago
0.0.12
2 years ago
0.0.13
2 years ago
0.0.11
3 years ago
0.0.10
3 years ago
0.0.9
3 years ago
0.0.9-1
3 years ago
0.0.8
3 years ago
0.0.7
3 years ago
0.0.6
3 years ago
0.0.4
3 years ago
0.0.3
3 years ago
0.0.2
3 years ago
0.0.1
3 years ago