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 ...`
Content copied to clipboard
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
Link copied to clipboard
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.