sqlutil
v3.1.0
Published
Wrapper around sqlite for structured queries
Downloads
2
Readme
Wrapper for node-sqlite3
This is a wrapper module for node-sqlite3 which makes it possible to create sql queries using mongodb like syntax, and also promisifies the API.
The support is incomplete and is currently only used for some personal projects. Pull requests are welcome.
Installation
npm install sqlutil
Usage
see test suite for more:
import sqlutil from 'sqlutil';
import Promise from 'bluebird';
let table;
let db = new sqlutil.Db();
db.open(':memory:').then(() => {
table = new sqlutil.Table(db, {
name: 'testtable',
columns: {
id: {type: sqlutil.DataType.INTEGER, primaryKey: true},
name: {type: sqlutil.DataType.TEXT, unique: true},
value: {type: sqlutil.DataType.FLOAT}
}
});
return table.createTable()
.then(() => Promise.all([
table.insert({name: 'key1', value: 42}),
table.insert({name: 'key2', value: 42}),
table.insert({name: 'key3', value: 43})
]);
});
We can perform queries on a table:
table.find({name: 'key1'}).get()
.then(row => {
assert.equal(row.value, 42);
});
And we can get a stream of rows
table.find({value: {$gt: 42}}).stream();