test.js

/**
 * promise based node-sqlite3 for co or koa
 */
var db = require('./');
var chai = require('chai');
var should = chai.should();
var expect = chai.expect;
var assert = chai.assert;
var fs = require('fs');

chai.use(require('chai-as-promised'));

describe('New sqlite3.Database test', function() {

	// after this test ,delete test.db
	it('should create success if filename is writeable', function() {
		db('test2.db').then(function(data) {
			expect(data.db).to.have.property('filename').with.equal('test2.db');
		}, function(err) {
			should.not.exist(err);
		});
	});

	it('should create fail if filename is unwriteable', function() {
		db('/somepaththatnotexist/test.db').then(function(data) {
			should.not.exist(data);
		}, function(err) {
			should.exist(err);
		});
	});
});

// db.run test

describe('Database#run API test', function() {

	var sqlCreateTable = 'CREATE TABLE IF NOT EXISTS testtable2( id INT NOT NULL)';
	var sqlInsert = 'INSERT INTO testtable2 (id) VALUES(1)';
	var sqlCreateTableWrong = 'INSERT INTO testta VALUES("string")';


	it('should create  table  success if sql right', function() {
		db('test2.db').then(function(data) {
			return data.run(sqlCreateTable).should.eventually.have.property('lastID');
		});

	});

	it('should insert data    success if sql right', function() {
		db('test2.db').then(function(data) {
			return data.run(sqlInsert).should.eventually.have.property('lastID');
	});

	});
	it('should run sql  fail if sql wrong', function() {
		db('test2.db').then(function(data) {
			return data.run(sqlCreateTableWrong).should.be.rejected;
		});

	});


});

// db.close test

describe('Database#close API test', function() {

	// after this test ,delete test2.db
	it('should close success have opened connection', function() {
		db('test2.db').then(function(data) {
			return data.close().should.eventually.resolve;
		});

	});


});


// db.get test


describe('Database#get API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';
		// after this test ,delete test2.db

	it('should get one record with id ', function() {
		db('test2.db').then(function(data) {
			 data.get(selectSQL).then(function(d){
			 	console.log(d);
			 })
		});

	});
});

// db.all test
describe('Database#all API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';

	after(function(){
		//fs.unlinkSync('test2.db');
	});

	it('should get more than one record  ', function() {
		db('test2.db').then(function(data) {
			return expect(data.all(selectSQL)).to.eventually.be.a('array');
		});

	});
});

// db.each test
describe('Database#each API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';

	it('should get a num  ', function() {
		db('test2.db').then(function(data) {

			return expect(data.each(selectSQL)).to.eventually.be.a('number');
		});

	});
});

// db.exec test
describe('Database#exec API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';

	it('should resolve successful  ', function() {
		db('test2.db').then(function(data) {

			return data.exec(selectSQL).should.eventually.resolve;
		});

	});
});

// db.exec test
describe('Database#prepare API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';

	it('should resolve successful  ', function() {
		db('test2.db').then(function(data) {

			return data.prepare(selectSQL).should.eventually.resolve;
		});

	});
});

// statement.bind test
describe('Statement#bind API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';

	it('should resolve successful  ', function() {
		db('test2.db').then(function(data) {

			 data.prepare(selectSQL).then(function(statement){
			 	return statement.bind().should.eventually.resolve;
			});
		});

	});
});

// statement.reset test
describe('Statement#reset API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';

	it('should resolve successful  ', function() {
		db('test2.db').then(function(data) {

			 data.prepare(selectSQL).then(function(statement){
			 	return statement.reset().should.eventually.resolve;
			});
		});

	});
});

// statement.finalize test
describe('Statement#finalize API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';
	
	it('should resolve successful  ', function() {
		db('test2.db').then(function(data) {

			 data.prepare(selectSQL).then(function(statement){
			 	return statement.finalize().should.eventually.resolve;
			});
		});

	});
});

// statement.run test
describe('Statement#run API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';
	
	it('should resolve successful and have property lastID  ', function() {
		db('test2.db').then(function(data) {

			 data.prepare(selectSQL).then(function(statement){
			 	return statement.run().should.eventually.have.property('lastID');
			});
		});

	});
});



// statement.each test
describe('Statement#run API test', function() {
	var selectSQL = 'SELECT * FROM testtable2;';
	
	it('should resolve successful and got a num   ', function() {
		db('test2.db').then(function(data) {

			 data.prepare(selectSQL).then(function(statement){
			 	return expect(statement.each()).to.eventually.be.a('number');
			});
		});

	});
});