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