NotMatchedThenableMergeQueryBuilder
class NotMatchedThenableMergeQueryBuilder<DB, TT extends keyof DB, ST extends keyof DB, O> {}
constructor(props: MergeQueryBuilderProps);
thenDoNothing(): WheneableMergeQueryBuilder<DB, TT, ST, O>;
thenInsertValues<I extends InsertObjectOrList<DB, TT>>(insert: I): WheneableMergeQueryBuilder<DB, TT, ST, O>;
thenInsertValues<IO extends InsertObjectOrListFactory<DB, TT, ST>>(insert: IO): WheneableMergeQueryBuilder<DB, TT, ST, O>;
§Constructors
§
new NotMatchedThenableMergeQueryBuilder(props: MergeQueryBuilderProps)
[src]§Methods
§
thenDoNothing(): WheneableMergeQueryBuilder<DB, TT, ST, O>
[src]Performs the do nothing action.
This is supported in PostgreSQL.
To perform the insert action, see {@link 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>
[src]Performs the insert (...) values action.
This method is similar to {@link InsertQueryBuilder.values}, so see the documentation for that method for more examples.
To perform the do nothing action, see {@link 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>
[src]