6.0.2 • Published 6 years ago
db-stuff v6.0.2
Database abstraction
Attempt to provide a unified low level interface to various databases. Currently supports:
- MySql
- PostgreSql
one need to npm install pg / mysql in order to use those implementations
Example
$ npm install db-stuff pg
var dbStuff = require('db-stuff');
var config = {
implementation: 'PostgresDatastore',
connectionString: 'tcp://user:pass@redshift.host:5439/db'
};
dbStuff.create(config, function (err, datastore) {
datastore.query('select * table', function(err, data) {
console.log(err, data);
});
// with params
datastore.query('select * table where x=$1', [1], function(err, data) {
console.log(err, data);
});
datastore.insert('table', { a: 1, b: 2}, function (err) {
})
datastore.update('table', { a: 1, b: 3}, function (err) {
})
datastore.update('table', { a: 1, b: 3}, {id: 1, b:2 } function (err) {
// update record where id = 1 AND b = 2
// this simple filter only supports AND(s)
// for more complex stuff just run query()
})
// with params
datastore.createQuery('select * from table where x=$1', [1], function(err, q) {
q.on('row', function(row) {
});
q.on('error', function(err) {
});
q.on('end', function(results) {
});
});
datastore.createQuery('select * from table', function(err, q) {
...
...
...
});
//reusable/batch insert command
function cb(err) {
console.log(err);
}
var insertCommand = datastore.newInsertCommand('table', ['fieldA', 'fieldB']);
insertCommand.execute([1,2], cb);
// raw strings - will be places directly inside VALUES (...), this is very unsafe though
insertCommand.execute('1,2', cb);
var bulkInsertCommand = datastore.newBulkInsertCommand('table', ['fieldA', 'fieldB'])
bulkInsertCommand.execute([
[1,2],
[3,4],
[5,6]
], cb)
});
6.0.2
6 years ago
5.3.5
6 years ago
6.0.1
7 years ago
5.3.4
7 years ago
6.0.0
7 years ago
5.3.3
7 years ago
5.3.2
7 years ago
5.3.1
7 years ago
5.3.0
7 years ago
5.2.2
8 years ago
5.2.1
8 years ago
5.2.0
8 years ago
5.0.1
8 years ago
4.0.1
9 years ago
4.0.0
9 years ago
3.0.5
9 years ago
3.0.4
9 years ago
3.0.3
9 years ago
3.0.2
9 years ago
3.0.1
9 years ago
3.0.0
9 years ago
2.0.1
9 years ago
2.0.0
10 years ago
1.0.11
10 years ago
1.0.10
10 years ago
1.0.9
10 years ago
1.0.8
10 years ago
0.0.68
10 years ago
1.0.5
10 years ago
1.0.4
10 years ago
1.0.2
10 years ago
1.0.1
10 years ago
0.0.67
10 years ago
1.0.0
10 years ago
0.0.66
10 years ago
0.0.63
10 years ago
0.0.62
10 years ago
0.0.61
10 years ago
0.0.60
10 years ago
0.0.55
11 years ago
0.0.53
11 years ago
0.0.51
11 years ago
0.0.50
11 years ago
0.0.23
11 years ago
0.0.10
11 years ago
0.0.9
11 years ago