BulkInsertExpression

data class BulkInsertExpression(val table: TableExpression, val assignments: List<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)

Bulk insert expression, represents a bulk insert statement in SQLite.

For example:

insert into table (column1, column2)
values (?, ?), (?, ?), (?, ?)...
on conflict (...) do update set ...`

Constructors

constructor(table: TableExpression, assignments: List<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())

column assignments of the bulk insert statement.

the index columns on which the conflict may happen.

open override val isLeafNode: Boolean = false

the returning columns.

the table to be inserted.

the updated column assignments while key conflict exists.

the condition whether the update assignments should be executed.