'use strict';

var Harness = require('./support');

var post = Harness.definePostTable();

var user = Harness.defineUserTable();

Harness.test({

query: post.select(post.star()).forShare(),

pg: {

text : 'SELECT "post".* FROM "post" FOR SHARE',

string: 'SELECT "post".* FROM "post" FOR SHARE'

},

params: []

});

Harness.test({

query: post.select(post.star()).from(post.join(user).on(user.id.equals(post.userId))).where(post.content.equals('foo')).forShare(),

pg: {

text : 'SELECT "post".* FROM "post" INNER JOIN "user" ON ("user"."id" = "post"."userId") WHERE ("post"."content" = $1) FOR SHARE',

string: 'SELECT "post".* FROM "post" INNER JOIN "user" ON ("user"."id" = "post"."userId") WHERE ("post"."content" = \'foo\') FOR SHARE'

},

params: ["foo"]

});