import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { MatchedThenableMergeQueryBuilder } = kysely;
Performs an update set
action, similar to {@link UpdateQueryBuilder.set}.
For a full-fledged update query builder, see {@link thenUpdate}.
To perform the delete
action, see {@link thenDelete}.
To perform the do nothing
action, see {@link thenDoNothing}.
Examples
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenMatched()
.thenUpdateSet({
middle_name: 'dog owner',
})
.execute()
The generate SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when matched then
update set "middle_name" = $1
Type Parameters
UO extends UpdateObject<DB, UT, TT>
Parameters
update: UO
Returns
WheneableMergeQueryBuilder<DB, TT, ST, O>
Type Parameters
RE extends ReferenceExpression<DB, TT>
VE extends ValueExpression<DB, UT, ExtractUpdateTypeFromReferenceExpression<DB, TT, RE>>
Returns
WheneableMergeQueryBuilder<DB, TT, ST, O>