operators.test.js
3.54 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
'use strict';
const chai = require('chai'),
Sequelize = require('../../index'),
Op = Sequelize.Op,
expect = chai.expect,
Support = require('../support'),
DataTypes = require('../../lib/data-types'),
dialect = Support.getTestDialect();
describe(Support.getTestDialectTeaser('Operators'), () => {
describe('REGEXP', () => {
beforeEach(async function() {
this.User = this.sequelize.define('user', {
id: {
type: DataTypes.INTEGER,
allowNull: false,
primaryKey: true,
autoIncrement: true,
field: 'userId'
},
name: {
type: DataTypes.STRING,
field: 'full_name'
}
}, {
tableName: 'users',
timestamps: false
});
await this.sequelize.getQueryInterface().createTable('users', {
userId: {
type: DataTypes.INTEGER,
allowNull: false,
primaryKey: true,
autoIncrement: true
},
full_name: {
type: DataTypes.STRING
}
});
});
if (dialect === 'mysql' || dialect === 'postgres') {
describe('case sensitive', () => {
it('should work with a regexp where', async function() {
await this.User.create({ name: 'Foobar' });
const user = await this.User.findOne({
where: {
name: { [Op.regexp]: '^Foo' }
}
});
expect(user).to.be.ok;
});
it('should work with a not regexp where', async function() {
await this.User.create({ name: 'Foobar' });
const user = await this.User.findOne({
where: {
name: { [Op.notRegexp]: '^Foo' }
}
});
expect(user).to.not.be.ok;
});
it('should properly escape regular expressions', async function() {
await this.User.bulkCreate([{ name: 'John' }, { name: 'Bob' }]);
await this.User.findAll({
where: {
name: { [Op.notRegexp]: "Bob'; drop table users --" }
}
});
await this.User.findAll({
where: {
name: { [Op.regexp]: "Bob'; drop table users --" }
}
});
expect(await this.User.findAll()).to.have.length(2);
});
});
}
if (dialect === 'postgres') {
describe('case insensitive', () => {
it('should work with a case-insensitive regexp where', async function() {
await this.User.create({ name: 'Foobar' });
const user = await this.User.findOne({
where: {
name: { [Op.iRegexp]: '^foo' }
}
});
expect(user).to.be.ok;
});
it('should work with a case-insensitive not regexp where', async function() {
await this.User.create({ name: 'Foobar' });
const user = await this.User.findOne({
where: {
name: { [Op.notIRegexp]: '^foo' }
}
});
expect(user).to.not.be.ok;
});
it('should properly escape regular expressions', async function() {
await this.User.bulkCreate([{ name: 'John' }, { name: 'Bob' }]);
await this.User.findAll({
where: {
name: { [Op.iRegexp]: "Bob'; drop table users --" }
}
});
await this.User.findAll({
where: {
name: { [Op.notIRegexp]: "Bob'; drop table users --" }
}
});
expect(await this.User.findAll()).to.have.length(2);
});
});
}
});
});