English | 简体中文

api-docs / org.ktorm.support.sqlite / InsertOrUpdateOnConflictClauseBuilder

InsertOrUpdateOnConflictClauseBuilder

class InsertOrUpdateOnConflictClauseBuilder : 
    SQLiteAssignmentsBuilder
(source code)

DSL builder for insert or update on conflict clause.

Constructors

NameSummary

<init>

InsertOrUpdateOnConflictClauseBuilder()

DSL builder for insert or update on conflict clause.

Functions

NameSummary

doNothing

fun doNothing(): Unit

Explicitly tells ktorm to ignore any on-conflict errors and continue insertion.

excluded

fun <T : Any> excluded(
    column: Column<T>
): ColumnExpression<T>

Reference the ‘EXCLUDED’ table in a ON CONFLICT clause.

where

fun where(block: () -> ColumnDeclaring<Boolean>): Unit

Specify the where condition for the update clause.

Extension Functions

NameSummary

eq

infix fun <T : Any> T.eq(
    expr: ColumnDeclaring<T>
): BinaryExpression<Boolean>

Equal operator, translated to = in SQL.

neq

infix fun <T : Any> T.neq(
    expr: ColumnDeclaring<T>
): BinaryExpression<Boolean>

Not-equal operator, translated to <> in SQL.

notEq

infix fun <T : Any> T.notEq(
    expr: ColumnDeclaring<T>
): BinaryExpression<Boolean>

Not-equal operator, translated to <> in SQL.