import { kysely } from "https://deno.land/x/kysely_postgrs_js_dialect@v0.27.4/deps.ts";
const { NotMatchedThenableMergeQueryBuilder } = kysely;
Constructors
new
NotMatchedThenableMergeQueryBuilder(props: MergeQueryBuilderProps)Methods
thenDoNothing(): WheneableMergeQueryBuilder<DB, TT, ST, O>
Performs the do nothing
action.
This is supported in PostgreSQL.
To perform the insert
action, see thenInsertValues.
Examples
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenNotMatched()
.thenDoNothing()
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when not matched then
do nothing
thenInsertValues<I extends InsertObjectOrList<DB, TT>>(insert: I): WheneableMergeQueryBuilder<DB, TT, ST, O>
Performs the insert (...) values
action.
This method is similar to InsertQueryBuilder.values, so see the documentation for that method for more examples.
To perform the do nothing
action, see thenDoNothing.
Examples
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenNotMatched()
.thenInsertValues({
first_name: 'John',
last_name: 'Doe',
})
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when not matched then
insert ("first_name", "last_name") values ($1, $2)
thenInsertValues<IO extends InsertObjectOrListFactory<DB, TT, ST>>(insert: IO): WheneableMergeQueryBuilder<DB, TT, ST, O>