forked from brianc/node-sql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreate-view-tests.js
More file actions
80 lines (76 loc) · 2.7 KB
/
create-view-tests.js
File metadata and controls
80 lines (76 loc) · 2.7 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
'use strict';
var Harness = require('./support');
var user = Harness.defineUserTable();
//simple view create
Harness.test({
query: user.select(user.star()).createView('allUsersView'),
pg: {
text : '(CREATE VIEW "allUsersView" AS SELECT "user".* FROM "user")',
string: '(CREATE VIEW "allUsersView" AS SELECT "user".* FROM "user")'
},
sqlite: {
text : '(CREATE VIEW "allUsersView" AS SELECT "user".* FROM "user")',
string: '(CREATE VIEW "allUsersView" AS SELECT "user".* FROM "user")'
},
mysql: {
text : '(CREATE VIEW `allUsersView` AS SELECT `user`.* FROM `user`)',
string: '(CREATE VIEW `allUsersView` AS SELECT `user`.* FROM `user`)'
},
mssql: {
text : '(CREATE VIEW [allUsersView] AS SELECT [user].* FROM [user])',
string: '(CREATE VIEW [allUsersView] AS SELECT [user].* FROM [user])'
},
oracle: {
text : '(CREATE VIEW "allUsersView" AS SELECT "user".* FROM "user")',
string: '(CREATE VIEW "allUsersView" AS SELECT "user".* FROM "user")'
}
});
//create view with parameters
Harness.test({
query: user.select(user.star()).where(user.id.equals(1)).createView('oneUserView'),
pg: {
text : '(CREATE VIEW "oneUserView" AS SELECT "user".* FROM "user" WHERE ("user"."id" = 1))',
string: '(CREATE VIEW "oneUserView" AS SELECT "user".* FROM "user" WHERE ("user"."id" = 1))'
},
sqlite: {
text : '(CREATE VIEW "oneUserView" AS SELECT "user".* FROM "user" WHERE ("user"."id" = 1))',
string: '(CREATE VIEW "oneUserView" AS SELECT "user".* FROM "user" WHERE ("user"."id" = 1))'
},
mysql: {
text : '(CREATE VIEW `oneUserView` AS SELECT `user`.* FROM `user` WHERE (`user`.`id` = 1))',
string: '(CREATE VIEW `oneUserView` AS SELECT `user`.* FROM `user` WHERE (`user`.`id` = 1))'
},
mssql: {
text : '(CREATE VIEW [oneUserView] AS SELECT [user].* FROM [user] WHERE ([user].[id] = 1))',
string: '(CREATE VIEW [oneUserView] AS SELECT [user].* FROM [user] WHERE ([user].[id] = 1))'
},
oracle: {
text : '(CREATE VIEW "oneUserView" AS SELECT "user".* FROM "user" WHERE ("user"."id" = 1))',
string: '(CREATE VIEW "oneUserView" AS SELECT "user".* FROM "user" WHERE ("user"."id" = 1))'
}
});
//Tests error raised for non-SELECT create view attempts
Harness.test({
query: user.delete().where(user.id.equals(1)).createView('oneUserView'),
pg: {
text : 'Create View requires a Select.',
throws: true
},
sqlite: {
text : 'Create View requires a Select.',
throws: true
},
mysql: {
text : 'Create View requires a Select.',
throws: true
},
mssql: {
text : 'Create View requires a Select.',
throws: true
},
oracle: {
text : 'Create View requires a Select.',
throws: true
},
params: []
});