import { kysely } from "https://deno.land/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { WheneableMergeQueryBuilder } = kysely;
Adds the when matched
clause to the query with an and
condition.
This method is similar to SelectQueryBuilder.where, so see the documentation for that method for more examples.
For a simple when matched
clause (without an and
condition) see whenMatched.
Examples
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenMatchedAnd('person.first_name', '=', 'John')
.thenDelete()
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when matched and "person"."first_name" = $1 then
delete
Type Parameters
RE extends ReferenceExpression<DB, TT | ST>
VE extends OperandValueExpressionOrList<DB, TT | ST, RE>
Returns
MatchedThenableMergeQueryBuilder<DB, TT, ST, TT | ST, O>
Type Parameters
E extends ExpressionOrFactory<DB, TT | ST, SqlBool>
Parameters
expression: E
Returns
MatchedThenableMergeQueryBuilder<DB, TT, ST, TT | ST, O>