client/io.github.octaviusframework.client.query/OnConflictClause

OnConflictClause

class OnConflictClause @PublishedApi constructor

The ON CONFLICT clause of an InsertQuery, configured inside InsertQuery.onConflict. The target is optional; an action is required.

Constructors

OnConflictClause

@PublishedApi

internal constructor()

Functions

copyInto

internal fun copyInto(other: OnConflictClause)

doNothing

fun doNothing()

Leaves the existing row alone and inserts nothing.

doUpdate

fun doUpdate(setExpression: String, whereCondition: String? = null)

Updates the existing row. setExpression is the SET body as SQL, in which excluded is the row that could not be inserted: doUpdate("cognomen = excluded.cognomen, updated_at = now()"). whereCondition limits which conflicting rows are updated.

fun doUpdate(setMap: Map<String, String>, whereCondition: String? = null)

As doUpdate, with the assignments given as a column-to-expression map.

fun doUpdate(vararg setPairs: Pair<String, String>, whereCondition: String? = null)

As doUpdate, with the assignments given as column-to-expression pairs.

onColumns

fun onColumns(vararg columns: String, where: String? = null)

Conflicts on a unique index over columns, which may be expressions. where is the index predicate; null or blank leaves it out.

onConstraint

fun onConstraint(constraintName: String)

Conflicts on a named constraint.

render

internal fun render(): String