English | 简体中文

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

BulkInsertExpression

data class BulkInsertExpression : SqlExpression (source code)

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

For example:

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

Constructors

NameSummary

<init>

BulkInsertExpression(
    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())

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

Properties

NameSummary

assignments

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

val extraProperties: Map<String, Any>

Extra properties of this expression, maybe useful in SqlFormatter to generate some special SQLs.

isLeafNode

val isLeafNode: Boolean

Check if this expression is a leaf node in expression trees.

returningColumns

val returningColumns: List<ColumnExpression<*>>

the returning columns.

table

val table: TableExpression

the table to be inserted.

updateAssignments

val updateAssignments: List<ColumnAssignmentExpression<*>>

the updated column assignments while key conflict exists.