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

Link copied to clipboard
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())

Properties

Link copied to clipboard

column assignments of the bulk insert statement.

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 key conflict exists.

Link copied to clipboard

the condition whether the update assignments should be executed.