V8 Coverage Report
Files covered Lines
. / test/named_columns.test.js
94.87 %
37 / 39
    1.      1var sqlite3 = require('..');
    2.      1var assert = require('assert');
    3.      1
    4.      1describe('named columns', function() {
    5.      1    var db;
    6.      1    before(function(done) {
    7.      1        db = new sqlite3.Database(':memory:', done);
    8.      1    });
    9.      1
   10.      1    it('should create the table', function(done) {
   11.      1        db.run("CREATE TABLE foo (txt TEXT, num INT)", done);
   12.      1    });
   13.      1
   14.      1    it('should insert a value', function(done) {
   15.      1        db.run("INSERT INTO foo VALUES($text, $id)", {
   16.      1            $id: 1,
   17.      1            $text: "Lorem Ipsum"
   18.      1        }, done);
   19.      1    });
   20.      1
   21.      1    it('should retrieve the values', function(done) {
   22.      1        db.get("SELECT txt, num FROM foo ORDER BY num", function(err, row) {
   23.      0            if (err) throw err;
   24.      1            assert.equal(row.txt, "Lorem Ipsum");
   25.      1            assert.equal(row.num, 1);
   26.      1            done();
   27.      1        });
   28.      1    });
   29.      1
   30.      1    it('should be able to retrieve rowid of last inserted value', function(done) {
   31.      1        db.get("SELECT last_insert_rowid() as last_id FROM foo", function(err, row) {
   32.      0            if (err) throw err;
   33.      1            assert.equal(row.last_id, 1);
   34.      1            done();
   35.      1        });
   36.      1    });
   37.      1
   38.      1});
   39.      1