forked from TryGhost/node-sqlite3
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathparallel_insert.test.js
More file actions
38 lines (31 loc) · 1.04 KB
/
Copy pathparallel_insert.test.js
File metadata and controls
38 lines (31 loc) · 1.04 KB
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
var sqlite3 = require('sqlite3');
var assert = require('assert');
var util = require('util');
var helper = require('./support/helper');
if (process.setMaxListeners) process.setMaxListeners(0);
exports['test parallel inserts'] = function(beforeExit) {
var completed = false;
helper.deleteFile('test/tmp/test_parallel_inserts.db');
var db = new sqlite3.Database('test/tmp/test_parallel_inserts.db');
var columns = [];
for (var i = 0; i < 128; i++) {
columns.push('id' + i);
}
db.serialize(function() {
db.run("CREATE TABLE foo (" + columns + ")");
});
for (var i = 0; i < 1000; i++) {
for (var values = [], j = 0; j < columns.length; j++) {
values.push(i * j);
}
db.run("INSERT INTO foo VALUES (" + values + ")");
}
db.close(function() {
completed = true;
});
beforeExit(function() {
assert.ok(completed);
assert.fileExists('test/tmp/test_parallel_inserts.db');
helper.deleteFile('test/tmp/test_parallel_inserts.db');
});
};