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
Name | Summary |
---|---|
BulkInsertExpression( Bulk insert expression, represents a bulk insert statement in PostgreSQL. |
Properties
Name | Summary |
---|---|
val assignments: List<List<ColumnAssignmentExpression<*>>> column assignments of the bulk insert statement. | |
val conflictColumns: List<ColumnExpression<*>> the index columns on which the conflict may happen. | |
Extra properties of this expression, maybe useful in SqlFormatter to generate some special SQLs. | |
val isLeafNode: Boolean Check if this expression is a leaf node in expression trees. | |
val returningColumns: List<ColumnExpression<*>> the returning columns. | |
val table: TableExpression the table to be inserted. | |
val updateAssignments: List<ColumnAssignmentExpression<*>> the updated column assignments while key conflict exists. |
Extension Functions
Name | Summary |
---|---|
infix fun <T : Any> T.eq( Equal operator, translated to | |
infix fun <T : Any> T.neq( Not-equal operator, translated to | |
infix fun <T : Any> T.notEq( Not-equal operator, translated to |