ktorm-support-sqlite/org.ktorm.support.sqlite/InsertOrUpdateExpression

InsertOrUpdateExpression

data class InsertOrUpdateExpression(val table: TableExpression, val assignments: List<ColumnAssignmentExpression<*>>, val conflictColumns: List<ColumnExpression<*>> = emptyList(), val updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(), val where: ScalarExpression<Boolean>? = null, 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 SQLite.

Constructors

InsertOrUpdateExpression

constructor(table: TableExpression, assignments: List<ColumnAssignmentExpression<*>>, conflictColumns: List<ColumnExpression<*>> = emptyList(), updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(), where: ScalarExpression<Boolean>? = null, returningColumns: List<ColumnExpression<*>> = emptyList(), isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())

Properties

val assignments: List<ColumnAssignmentExpression<*>>

the inserted column assignments.

conflictColumns

val conflictColumns: List<ColumnExpression<*>>

the index columns on which the conflict may happen.

extraProperties

open override val extraProperties: Map<String, Any>

open override val isLeafNode: Boolean = false

returningColumns

val returningColumns: List<ColumnExpression<*>>

the returning columns.

val table: TableExpression

the table to be inserted.

updateAssignments

val updateAssignments: List<ColumnAssignmentExpression<*>>

the updated column assignments while any key conflict exists.

val where: ScalarExpression<Boolean>? = null

the condition whether the update assignments should be executed.