forked from florajs/sql-parser
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathwhere.js
More file actions
106 lines (92 loc) · 3.33 KB
/
where.js
File metadata and controls
106 lines (92 loc) · 3.33 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
'use strict';
const { expect } = require('chai');
const { Parser } = require('../../');
describe('where clause', () => {
const parser = new Parser();
let ast;
it('should parse single condition', () => {
ast = parser.parse('SELECT * FROM t where t.a > 0');
expect(ast.where).to.eql({
type: 'binary_expr',
operator: '>',
left: { type: 'column_ref', table: 't', column: 'a' },
right: { type: 'number', value: 0 }
});
});
it('should parse parameters', () => {
ast = parser.parse('SELECT * FROM t where t.a > :my_param');
expect(ast.where).to.eql({
type: 'binary_expr',
operator: '>',
left: { type: 'column_ref', table: 't', column: 'a' },
right: { type: 'param', value: 'my_param' }
});
});
it('should parse multiple conditions', () => {
ast = parser.parse(`SELECT * FROM t where t.c between 1 and 't' AND Not true`);
expect(ast.where).to.eql({
type: 'binary_expr',
operator: 'AND',
left: {
type: 'binary_expr',
operator: 'BETWEEN',
left: { type: 'column_ref', table: 't', column: 'c' },
right: {
type: 'expr_list',
value: [
{ type: 'number', value: 1 },
{ type: 'string', value: 't' }
]
}
},
right: {
type: 'unary_expr',
operator: 'NOT',
expr: { type: 'bool', value: true }
}
});
});
it('should parse single condition with boolean', () => {
ast = parser.parse('SELECT * FROM t where t.a = TRUE');
expect(ast.where).to.eql({
type: 'binary_expr',
operator: '=',
left: { type: 'column_ref', table: 't', column: 'a' },
right: { type: 'bool', value: true }
});
});
['is', 'is not'].forEach((operator) => {
it(`should parse ${operator} condition`, () => {
ast = parser.parse(`SELECT * FROM t WHERE "col" ${operator} NULL`);
expect(ast.where).to.eql({
type: 'binary_expr',
operator: operator.toUpperCase(),
left: { type: 'column_ref', table: null, column: 'col' },
right: { type: 'null', value: null }
});
});
});
['exists', 'not exists'].forEach((operator) => {
it('should parse ' + operator.toUpperCase() + ' condition', () => {
ast = parser.parse(`SELECT * FROM t WHERE ${operator} (SELECT 1)`);
expect(ast.where).to.eql({
type: 'unary_expr',
operator: operator.toUpperCase(),
expr: {
with: null,
type: 'select',
options: null,
distinct: null,
columns: [{ expr: { type: 'number', value: 1 }, as: null }],
from: null,
where: null,
groupby: null,
having: null,
orderby: null,
limit: null,
parentheses: true
}
});
});
});
});