English |

简体中文

api-docs / org.ktorm.support.mysql / InsertOrUpdateExpression

InsertOrUpdateExpression

data class InsertOrUpdateExpression : SqlExpression (source code)

Insert or update expression, represents an insert statement with an
on duplicate key update clause in MySQL.

Constructors

Name	Summary
<init>	`InsertOrUpdateExpression( table: TableExpression, assignments: List<ColumnAssignmentExpression<>>, updateAssignments: List<ColumnAssignmentExpression<>> = emptyList(), isLeafNode: Boolean = false, extraProperties: Map<String, Any> = emptyMap())` Insert or update expression, represents an insert statement with an `on duplicate key update` clause in MySQL.

Properties

Name	Summary
assignments	`val assignments: List<ColumnAssignmentExpression<*>>` the inserted column assignments.
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.
table	`val table: TableExpression` the table to be inserted.
updateAssignments	`val updateAssignments: List<ColumnAssignmentExpression<*>>` the updated column assignments while any key conflict exists.

Extension Functions

Name	Summary
eq	`infix fun <T : Any> T.eq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Equal operator, translated to `=` in SQL.
neq	`infix fun <T : Any> T.neq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.
notEq	`infix fun <T : Any> T.notEq( expr: ColumnDeclaring<T> ): BinaryExpression<Boolean>` Not-equal operator, translated to `<>` in SQL.