FilesExpand file tree

 sqlite3_update_hook

/

database_fail.test.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

153 lines (140 loc) · 5.83 KB

 sqlite3_update_hook

/

database_fail.test.js

Copy path

Top

File metadata and controls

• Code
• Blame

153 lines (140 loc) · 5.83 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

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'));

}

});

});

});