co-sqlite3

promise based node-sqlite3 named co-sqlite3

$3

``
npm install co-sqlite3
`

$3

#### 1. work with co

`
var co = require('co');
var sqlite3 = require('co-sqlite3');

co(function*() {

//connect a database

var db = yield sqlite3('test.db');

// create a table
yield db.run('CREATE TABLE IF NOT EXISTS testtable (id INT NOT NULL)');

var stmt = yield db.prepare('INSERT INTO testtable(id) VALUES( ? )');

for(var i =0 ; i < 100 ; i++){
yield stmt.run(i);
}

stmt.finalize();

var row = yield db.get('SELECT * FROM testtable WHERE id < ? ORDER BY ID DESC ' ,[50]);
console.log(row); // {id: 49}

var rows = yield db.all('SELECT * FROM testtable');
console.log(rows.length);


}).catch(function(err) {

console.log(err.stack);

});

`


#### 2 work with koa


`
var koa = require('koa');
var sqlite3 = require('co-sqlite3');

var app = koa();

app.use(function*(next){
this.db = yield sqlite3('test.db');
yield next ;
});


app.use(function* (){
this.body = yield this.db.get('SELECT * FROM testtable WHERE id < ? ORDER BY ID DESC ' ,[50]);
})

app.listen(3000);


`

$3

`
var sqlite3 = require('co-sqlite3');


sqlite3('test.db').then(function(db){
db.get('SELECT * FROM testtable WHERE id < ? ORDER BY ID DESC ' ,[50])
.then(function(row){
console.log(row);
});
});
``