InsertOrUpdateExpression

data class InsertOrUpdateExpression(    val table: TableExpression,     val assignments: List<ColumnAssignmentExpression<*>>,     val conflictColumns: List<ColumnExpression<*>> = emptyList(),     val updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(),     val returningColumns: List<ColumnExpression<*>> = emptyList(),     val isLeafNode: Boolean = false,     val extraProperties: Map<String, Any> = emptyMap()) : SqlExpression(source)

Insert or update expression, represents an insert statement with an on conflict (key) do update set clause in PostgreSQL.

Constructors

Link copied to clipboard
constructor(    table: TableExpression,     assignments: List<ColumnAssignmentExpression<*>>,     conflictColumns: List<ColumnExpression<*>> = emptyList(),     updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(),     returningColumns: List<ColumnExpression<*>> = emptyList(),     isLeafNode: Boolean = false,     extraProperties: Map<String, Any> = emptyMap())

Properties

Link copied to clipboard

the inserted column assignments.

Link copied to clipboard

the index columns on which the conflict may happen.

Link copied to clipboard
open override val extraProperties: Map<String, Any>
Link copied to clipboard
open override val isLeafNode: Boolean = false
Link copied to clipboard

the returning columns.

Link copied to clipboard

the table to be inserted.

Link copied to clipboard

the updated column assignments while any key conflict exists.