1.      1var sqlite3 = require('..');

    2.      1var assert = require('assert');

    3.      1var fs = require('fs');

    4.      1

    5.      1describe('exec', function() {

    6.      1    var db;

    7.      1    before(function(done) {

    8.      1        db = new sqlite3.Database(':memory:', done);

    9.      1    });

   10.      1

   11.      1    it('Database#exec', function(done) {

   12.      1        var sql = fs.readFileSync('test/support/script.sql', 'utf8');

   13.      1        db.exec(sql, done);

   14.      1    });

   15.      1

   16.      1    it('retrieve database structure', function(done) {

   17.      1        db.all("SELECT type, name FROM sqlite_master ORDER BY type, name", function(err, rows) {

   18.      0            if (err) throw err;

   19.      1            assert.deepEqual(rows, [

   20.      1                { type: 'index', name: 'grid_key_lookup' },

   21.      1                { type: 'index', name: 'grid_utfgrid_lookup' },

   22.      1                { type: 'index', name: 'images_id' },

   23.      1                { type: 'index', name: 'keymap_lookup' },

   24.      1                { type: 'index', name: 'map_index' },

   25.      1                { type: 'index', name: 'name' },

   26.      1                { type: 'table', name: 'grid_key' },

   27.      1                { type: 'table', name: 'grid_utfgrid' },

   28.      1                { type: 'table', name: 'images' },

   29.      1                { type: 'table', name: 'keymap' },

   30.      1                { type: 'table', name: 'map' },

   31.      1                { type: 'table', name: 'metadata' },

   32.      1                { type: 'view', name: 'grid_data' },

   33.      1                { type: 'view', name: 'grids' },

   34.      1                { type: 'view', name: 'tiles' }

   35.      1            ]);

   36.      1            done();

   37.      1        });

   38.      1    });

   39.      1});

   40.      1