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