The second argument of a where clause is not being transpiled to the tenant id
Opened this issue · 0 comments
wgrisa commented
it('exchanges all $_ as the current tenant id when using andWhere', async () => {
const query = tenantOneConnection('$_users')
.where('$_users.name', '<>', '$_users.name')
.join('$_roles', '$_users.role_id', '$_roles.id')
.select('$_roles.name as roleName', '$_users.name as userName')
.first()
expect(query.toString()).to.eql(
`select "1_roles"."name" as "roleName", "1_users"."name" as "userName" from "1_users" inner join "1_roles" on "1_users"."role_id" = "1_roles"."id" where "1_users"."name" <> '1_users.name' limit 1`,
)
})