FilesExpand file tree

 master

/

exec.test.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

39 lines (36 loc) · 1.42 KB

 master

/

exec.test.js

Copy path

Top

File metadata and controls

• Code
• Blame

39 lines (36 loc) · 1.42 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

var sqlite3 = require('..');

var assert = require('assert');

var fs = require('fs');

describe('exec', function() {

var db;

before(function(done) {

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

});

it('Database#exec', function(done) {

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

db.exec(sql, done);

});

it('retrieve database structure', function(done) {

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

if (err) throw err;

assert.deepEqual(rows, [

{ type: 'index', name: 'grid_key_lookup' },

{ type: 'index', name: 'grid_utfgrid_lookup' },

{ type: 'index', name: 'images_id' },

{ type: 'index', name: 'keymap_lookup' },

{ type: 'index', name: 'map_index' },

{ type: 'index', name: 'name' },

{ type: 'table', name: 'grid_key' },

{ type: 'table', name: 'grid_utfgrid' },

{ type: 'table', name: 'images' },

{ type: 'table', name: 'keymap' },

{ type: 'table', name: 'map' },

{ type: 'table', name: 'metadata' },

{ type: 'view', name: 'grid_data' },

{ type: 'view', name: 'grids' },

{ type: 'view', name: 'tiles' }

]);

done();

});

});

});