forked from brianc/node-sql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathgroup-by-tests.js
More file actions
129 lines (123 loc) · 4.92 KB
/
group-by-tests.js
File metadata and controls
129 lines (123 loc) · 4.92 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
'use strict';
var Harness = require('./support');
var post = Harness.definePostTable();
Harness.test({
query: post.select(post.content).group(post.userId),
pg: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId"'
},
sqlite: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId"'
},
mysql: {
text : 'SELECT `post`.`content` FROM `post` GROUP BY `post`.`userId`',
string: 'SELECT `post`.`content` FROM `post` GROUP BY `post`.`userId`'
},
mssql: {
text : 'SELECT [post].[content] FROM [post] GROUP BY [post].[userId]',
string: 'SELECT [post].[content] FROM [post] GROUP BY [post].[userId]'
},
oracle: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId"'
},
params: []
});
Harness.test({
query: post.select(post.content).group(post.userId, post.id),
pg: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"'
},
sqlite: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"'
},
mysql: {
text : 'SELECT `post`.`content` FROM `post` GROUP BY `post`.`userId`, `post`.`id`',
string: 'SELECT `post`.`content` FROM `post` GROUP BY `post`.`userId`, `post`.`id`'
},
mssql: {
text : 'SELECT [post].[content] FROM [post] GROUP BY [post].[userId], [post].[id]',
string: 'SELECT [post].[content] FROM [post] GROUP BY [post].[userId], [post].[id]'
},
oracle: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"'
},
params: []
});
Harness.test({
query: post.select(post.content.arrayAgg()).group(post.userId),
pg: {
text : 'SELECT array_agg("post"."content") AS "contents" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT array_agg("post"."content") AS "contents" FROM "post" GROUP BY "post"."userId"'
},
sqlite: {
text : 'SELECT GROUP_CONCAT("post"."content") AS "contents" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT GROUP_CONCAT("post"."content") AS "contents" FROM "post" GROUP BY "post"."userId"'
},
mysql: {
text : 'SELECT GROUP_CONCAT(`post`.`content`) AS `contents` FROM `post` GROUP BY `post`.`userId`',
string: 'SELECT GROUP_CONCAT(`post`.`content`) AS `contents` FROM `post` GROUP BY `post`.`userId`'
},
mssql: {
text : 'SQL Server does not support array_agg.',
throws: true
},
oracle: {
text : 'Oracle does not support array_agg.',
throws: true
},
params: []
});
Harness.test({
query: post.select(post.content.arrayAgg('post contents')).group(post.userId),
pg: {
text : 'SELECT array_agg("post"."content") AS "post contents" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT array_agg("post"."content") AS "post contents" FROM "post" GROUP BY "post"."userId"'
},
sqlite: {
text : 'SELECT GROUP_CONCAT("post"."content") AS "post contents" FROM "post" GROUP BY "post"."userId"',
string: 'SELECT GROUP_CONCAT("post"."content") AS "post contents" FROM "post" GROUP BY "post"."userId"'
},
mysql: {
text : 'SELECT GROUP_CONCAT(`post`.`content`) AS `post contents` FROM `post` GROUP BY `post`.`userId`',
string: 'SELECT GROUP_CONCAT(`post`.`content`) AS `post contents` FROM `post` GROUP BY `post`.`userId`'
},
mssql: {
text : 'SQL Server does not support array_agg.',
throws: true
},
oracle: {
text : 'Oracle does not support array_agg.',
throws: true
},
params: []
});
Harness.test({
query: post.select(post.content).group([post.userId, post.id]),
pg: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"'
},
sqlite: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"'
},
mysql: {
text : 'SELECT `post`.`content` FROM `post` GROUP BY `post`.`userId`, `post`.`id`',
string: 'SELECT `post`.`content` FROM `post` GROUP BY `post`.`userId`, `post`.`id`'
},
mssql: {
text : 'SELECT [post].[content] FROM [post] GROUP BY [post].[userId], [post].[id]',
string: 'SELECT [post].[content] FROM [post] GROUP BY [post].[userId], [post].[id]'
},
oracel: {
text : 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"',
string: 'SELECT "post"."content" FROM "post" GROUP BY "post"."userId", "post"."id"'
},
params: []
});