Create SQLite adapter

[Leestex]

The task is to create a simple sqlite3 adapter, which will have API like this:

find(model, query, cb)

SQLite.find('Computer', {
    name: 'PC01'
}, function (err, computer) {
    console.log(computer);
});

db.run('SELECT * FROM $model WHERE name = $name', {
    $model: 'computer' + 's',
    $name: 'PC01'
});

update(model, query, values, cb)

SQLite.update('Computer', {
    name: 'PC01'
}, {
    name: 'PC02'
}, function (err, computer) {
    console.log(computer);
});

db.run('UPDATE $model name = $name WHERE name = $updname', {
    $model: 'computer' + 's',
    $name: 'PC01',
    $updname: 'PC02'
});

destroy(model, query, cb)

SQLite.destroy('Computer', {
    name: 'PC01'
}, function (err, computer) {
    console.log(computer);
});

db.run('DELETE FROM $model WHERE name = $name', {
    $model: 'computer' + 's',
    $name: 'PC01'
});

You can try to use node-sqlite3 module.
Please note: code snippets above are just examples. db.run will not actually work as it doesn't return results of a query execution. So read docs before implementing this.