wgrisa/knex-postgres-multi-tenancy

The second argument of a where clause is not being transpiled to the tenant id

Opened this issue · 0 comments

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`,
      )
    })