ktorm-support-postgresql/org.ktorm.support.postgresql/BulkInsertExpression

BulkInsertExpression

data class BulkInsertExpression(val table: TableExpression, val assignments: List<List<ColumnAssignmentExpression<*>>>, val conflictColumns: List<ColumnExpression<*>> = emptyList(), val updateAssignments: List<ColumnAssignmentExpression<*>> = emptyList(), 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 PostgreSQL.

For example:

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

Constructors

BulkInsertExpression

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

Properties

val assignments: List<List<ColumnAssignmentExpression<*>>>

column assignments of the bulk insert statement.

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