forked from brianc/node-sql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathclause-ordering-tests.js
More file actions
85 lines (80 loc) · 3.3 KB
/
clause-ordering-tests.js
File metadata and controls
85 lines (80 loc) · 3.3 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
'use strict';
var Harness = require('./support');
var user = Harness.defineUserTable();
var post = Harness.definePostTable();
// FROM - SELECT
Harness.test({
query: user.from(user.join(post).on(user.id.equals(post.userId))).select(user.name, post.content),
pg: {
text : 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId")',
string: 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId")',
},
sqlite: {
text : 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId")',
string: 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId")'
},
mysql: {
text : 'SELECT `user`.`name`, `post`.`content` FROM `user` INNER JOIN `post` ON (`user`.`id` = `post`.`userId`)',
string: 'SELECT `user`.`name`, `post`.`content` FROM `user` INNER JOIN `post` ON (`user`.`id` = `post`.`userId`)'
},
});
// WHERE - FROM - SELECT
Harness.test({
query: user.where({
name: ''
}).from(user).select(user.id),
pg: {
text : 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = $1)',
string: 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = \'\')'
},
sqlite: {
text : 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = $1)',
string: 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = \'\')'
},
mysql: {
text : 'SELECT `user`.`id` FROM `user` WHERE (`user`.`name` = ?)',
string: 'SELECT `user`.`id` FROM `user` WHERE (`user`.`name` = \'\')'
},
params: ['']
});
// SELECT - FROM - WHERE
Harness.test({
query: user
.select(user.name, post.content)
.from(user.join(post).on(user.id.equals(post.userId)))
.where({
name: ''
}),
pg: {
text : 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId") WHERE ("user"."name" = $1)',
string: 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId") WHERE ("user"."name" = \'\')'
},
sqlite: {
text : 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId") WHERE ("user"."name" = $1)',
string: 'SELECT "user"."name", "post"."content" FROM "user" INNER JOIN "post" ON ("user"."id" = "post"."userId") WHERE ("user"."name" = \'\')'
},
mysql: {
text : 'SELECT `user`.`name`, `post`.`content` FROM `user` INNER JOIN `post` ON (`user`.`id` = `post`.`userId`) WHERE (`user`.`name` = ?)',
string: 'SELECT `user`.`name`, `post`.`content` FROM `user` INNER JOIN `post` ON (`user`.`id` = `post`.`userId`) WHERE (`user`.`name` = \'\')'
},
params: ['']
});
// SELECT - FROM - WHERE
Harness.test({
query: user.select(user.id).from(user).where({
name: ''
}),
pg: {
text : 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = $1)',
string: 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = \'\')'
},
sqlite: {
text : 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = $1)',
string: 'SELECT "user"."id" FROM "user" WHERE ("user"."name" = \'\')'
},
mysql: {
text : 'SELECT `user`.`id` FROM `user` WHERE (`user`.`name` = ?)',
string: 'SELECT `user`.`id` FROM `user` WHERE (`user`.`name` = \'\')'
},
params: ['']
});