forked from TryGhost/node-sqlite3
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdatabase_fail.test.js
More file actions
153 lines (140 loc) · 5.83 KB
/
Copy pathdatabase_fail.test.js
File metadata and controls
153 lines (140 loc) · 5.83 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
var sqlite3 = require('..');
var assert = require('assert');
describe('error handling', function() {
var db;
before(function(done) {
db = new sqlite3.Database(':memory:', done);
});
it('throw when calling Database() without new', function() {
assert.throws(function() {
sqlite3.Database(':memory:');
}, (/Class constructors cannot be invoked without 'new'/));
assert.throws(function() {
sqlite3.Statement();
}, (/Class constructors cannot be invoked without 'new'/));
});
it('should error when calling Database#get on a missing table', function(done) {
db.get('SELECT id, txt FROM foo', function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#all prepare fail', function(done) {
db.all('SELECT id, txt FROM foo', function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#run prepare fail', function(done) {
db.run('SELECT id, txt FROM foo', function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#each prepare fail', function(done) {
db.each('SELECT id, txt FROM foo', function(err, row) {
assert.ok(false, "this should not be called");
}, function(err, num) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#each prepare fail without completion handler', function(done) {
db.each('SELECT id, txt FROM foo', function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#get prepare fail with param binding', function(done) {
db.get('SELECT id, txt FROM foo WHERE id = ?', 1, function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#all prepare fail with param binding', function(done) {
db.all('SELECT id, txt FROM foo WHERE id = ?', 1, function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#run prepare fail with param binding', function(done) {
db.run('SELECT id, txt FROM foo WHERE id = ?', 1, function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#each prepare fail with param binding', function(done) {
db.each('SELECT id, txt FROM foo WHERE id = ?', 1, function(err, row) {
assert.ok(false, "this should not be called");
}, function(err, num) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
it('Database#each prepare fail with param binding without completion handler', function(done) {
db.each('SELECT id, txt FROM foo WHERE id = ?', 1, function(err, row) {
if (err) {
assert.equal(err.message, 'SQLITE_ERROR: no such table: foo');
assert.equal(err.errno, sqlite3.ERROR);
assert.equal(err.code, 'SQLITE_ERROR');
done();
} else {
done(new Error('Completed query without error, but expected error'));
}
});
});
});