error.test.js
12 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
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
'use strict';
const chai = require('chai'),
sinon = require('sinon'),
expect = chai.expect,
errors = require('../../lib/errors'),
Support = require(__dirname + '/support'),
Sequelize = Support.Sequelize;
describe(Support.getTestDialectTeaser('Sequelize Errors'), () => {
describe('API Surface', () => {
it('Should have the Error constructors exposed', () => {
expect(Sequelize).to.have.property('Error');
expect(Sequelize).to.have.property('ValidationError');
expect(Sequelize).to.have.property('OptimisticLockError');
const sequelize = new Sequelize('mysql://user:pass@example.com:9821/dbname');
expect(sequelize).to.have.property('Error');
expect(sequelize).to.have.property('ValidationError');
expect(sequelize).to.have.property('OptimisticLockError');
});
it('Sequelize Errors instances should be instances of Error', () => {
const error = new Sequelize.Error();
const errorMessage = 'error message';
const validationError = new Sequelize.ValidationError(errorMessage, [
new errors.ValidationErrorItem('<field name> cannot be null', 'notNull Violation', '<field name>', null),
new errors.ValidationErrorItem('<field name> cannot be an array or an object', 'string violation', '<field name>', null)
]);
const optimisticLockError = new Sequelize.OptimisticLockError();
const sequelize = new Sequelize('mysql://user:pass@example.com:9821/dbname');
const instError = new sequelize.Error();
const instValidationError = new sequelize.ValidationError();
const instOptimisticLockError = new sequelize.OptimisticLockError();
expect(error).to.be.instanceOf(Sequelize.Error);
expect(error).to.be.instanceOf(Error);
expect(error).to.have.property('name', 'SequelizeBaseError');
expect(validationError).to.be.instanceOf(Sequelize.ValidationError);
expect(validationError).to.be.instanceOf(Error);
expect(validationError).to.have.property('name', 'SequelizeValidationError');
expect(validationError.message).to.equal(errorMessage);
expect(optimisticLockError).to.be.instanceOf(Sequelize.OptimisticLockError);
expect(optimisticLockError).to.be.instanceOf(Error);
expect(optimisticLockError).to.have.property('name', 'SequelizeOptimisticLockError');
expect(instError).to.be.instanceOf(Sequelize.Error);
expect(instError).to.be.instanceOf(Error);
expect(instValidationError).to.be.instanceOf(Sequelize.ValidationError);
expect(instValidationError).to.be.instanceOf(Error);
expect(instOptimisticLockError).to.be.instanceOf(Sequelize.OptimisticLockError);
expect(instOptimisticLockError).to.be.instanceOf(Error);
});
it('SequelizeValidationError should find errors by path', () => {
const errorItems = [
new Sequelize.ValidationErrorItem('invalid', 'type', 'first_name', null),
new Sequelize.ValidationErrorItem('invalid', 'type', 'last_name', null)
];
const validationError = new Sequelize.ValidationError('Validation error', errorItems);
expect(validationError).to.have.property('get');
expect(validationError.get).to.be.a('function');
const matches = validationError.get('first_name');
expect(matches).to.be.instanceOf(Array);
expect(matches).to.have.lengthOf(1);
expect(matches[0]).to.have.property('message', 'invalid');
});
it('SequelizeValidationError should override message property when message parameter is specified', () => {
const errorItems = [
new Sequelize.ValidationErrorItem('invalid', 'type', 'first_name', null),
new Sequelize.ValidationErrorItem('invalid', 'type', 'last_name', null)
],
customErrorMessage = 'Custom validation error message',
validationError = new Sequelize.ValidationError(customErrorMessage, errorItems);
expect(validationError).to.have.property('name', 'SequelizeValidationError');
expect(validationError.message).to.equal(customErrorMessage);
});
it('SequelizeValidationError should concatenate an error messages from given errors if no explicit message is defined', () => {
const errorItems = [
new errors.ValidationErrorItem('<field name> cannot be null', 'notNull Violation', '<field name>', null),
new errors.ValidationErrorItem('<field name> cannot be an array or an object', 'string violation', '<field name>', null)
],
validationError = new Sequelize.ValidationError(null, errorItems);
expect(validationError).to.have.property('name', 'SequelizeValidationError');
expect(validationError.message).to.match(/notNull Violation: <field name> cannot be null,\nstring violation: <field name> cannot be an array or an object/);
});
it('SequelizeDatabaseError should keep original message', () => {
const orig = new Error('original database error message');
const databaseError = new Sequelize.DatabaseError(orig);
expect(databaseError).to.have.property('parent');
expect(databaseError).to.have.property('original');
expect(databaseError.name).to.equal('SequelizeDatabaseError');
expect(databaseError.message).to.equal('original database error message');
});
it('ConnectionError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.ConnectionError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeConnectionError');
expect(connectionError.message).to.equal('original connection error message');
});
it('ConnectionRefusedError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.ConnectionRefusedError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeConnectionRefusedError');
expect(connectionError.message).to.equal('original connection error message');
});
it('AccessDeniedError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.AccessDeniedError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeAccessDeniedError');
expect(connectionError.message).to.equal('original connection error message');
});
it('HostNotFoundError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.HostNotFoundError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeHostNotFoundError');
expect(connectionError.message).to.equal('original connection error message');
});
it('HostNotReachableError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.HostNotReachableError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeHostNotReachableError');
expect(connectionError.message).to.equal('original connection error message');
});
it('InvalidConnectionError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.InvalidConnectionError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeInvalidConnectionError');
expect(connectionError.message).to.equal('original connection error message');
});
it('ConnectionTimedOutError should keep original message', () => {
const orig = new Error('original connection error message');
const connectionError = new Sequelize.ConnectionTimedOutError(orig);
expect(connectionError).to.have.property('parent');
expect(connectionError).to.have.property('original');
expect(connectionError.name).to.equal('SequelizeConnectionTimedOutError');
expect(connectionError.message).to.equal('original connection error message');
});
});
describe('Constraint error', () => {
[
{
type: 'UniqueConstraintError',
exception: Sequelize.UniqueConstraintError
},
{
type: 'ValidationError',
exception: Sequelize.ValidationError
}
].forEach(constraintTest => {
it('Can be intercepted as ' + constraintTest.type + ' using .catch', function() {
const spy = sinon.spy(),
User = this.sequelize.define('user', {
first_name: {
type: Sequelize.STRING,
unique: 'unique_name'
},
last_name: {
type: Sequelize.STRING,
unique: 'unique_name'
}
});
const record = { first_name: 'jan', last_name: 'meier' };
return this.sequelize.sync({ force: true }).bind(this).then(() => {
return User.create(record);
}).then(() => {
return User.create(record).catch(constraintTest.exception, spy);
}).then(() => {
expect(spy).to.have.been.calledOnce;
});
});
});
it('Supports newlines in keys', function() {
const spy = sinon.spy(),
User = this.sequelize.define('user', {
name: {
type: Sequelize.STRING,
unique: 'unique \n unique'
}
});
return this.sequelize.sync({ force: true }).bind(this).then(() => {
return User.create({ name: 'jan' });
}).then(function() {
// If the error was successfully parsed, we can catch it!
return User.create({ name: 'jan' }).catch(this.sequelize.UniqueConstraintError, spy);
}).then(() => {
expect(spy).to.have.been.calledOnce;
});
});
it('Works when unique keys are not defined in sequelize', function() {
let User = this.sequelize.define('user', {
name: {
type: Sequelize.STRING,
unique: 'unique \n unique'
}
}, { timestamps: false });
return this.sequelize.sync({ force: true }).bind(this).then(function() {
// Now let's pretend the index was created by someone else, and sequelize doesn't know about it
User = this.sequelize.define('user', {
name: Sequelize.STRING
}, { timestamps: false });
return User.create({ name: 'jan' });
}).then(function() {
// It should work even though the unique key is not defined in the model
return expect(User.create({ name: 'jan' })).to.be.rejectedWith(this.sequelize.UniqueConstraintError);
}).then(function() {
// And when the model is not passed at all
return expect(this.sequelize.query('INSERT INTO users (name) VALUES (\'jan\')')).to.be.rejectedWith(this.sequelize.UniqueConstraintError);
});
});
it('adds parent and sql properties', function() {
const User = this.sequelize.define('user', {
name: {
type: Sequelize.STRING,
unique: 'unique'
}
}, { timestamps: false });
return this.sequelize.sync({ force: true }).bind(this).then(() => {
return User.create({ name: 'jan' });
}).then(() => {
return expect(User.create({ name: 'jan' })).to.be.rejected;
}).then(function(error) {
expect(error).to.be.instanceOf(this.sequelize.UniqueConstraintError);
expect(error).to.have.property('parent');
expect(error).to.have.property('original');
expect(error).to.have.property('sql');
});
});
});
});