MergeTableStatement

Represents an SQL MERGE statement. It encapsulates the logic to perform conditional updates, insertions, or deletions.

Here is only the part specific for the Table as a source implementation. Look into MergeStatement to find the base implementation of that command.

dest

The destination Table where records will be merged into.

Constructors

constructor(dest: Table, source: Table, on: Op<Boolean>?)

The destination Table where records will be merged into.

Returns all mappings of columns and expression types to their values needed to prepare an SQL statement.

open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String

Returns the string representation of an SQL statement.

Specifies a delete operation to be executed when a matching record is found in the destination table.

Postgres only. Specifies that no operation should be performed when a matching record is found in the destination table.

fun whenMatchedUpdate(and: Op<Boolean>? = null, deleteWhere: Op<Boolean>? = null, body: (UpdateStatement) -> Unit)

Defines an update operation to be executed when a matching record is found in the destination table.

Postgres only. Specifies that no operation should be performed when no matching record is found in the destination table.

fun whenNotMatchedInsert( and: Op<Boolean>? = null, overridingUserValue: Boolean = false, overridingSystemValue: Boolean = false, body: (InsertStatement<Int>) -> Unit)

Defines an insert operation to be performed when there is no matching record in the destination table.