InsertOrUpdate

class InsertOrUpdate<Key : Any>(table: Table, isIgnore: Boolean = false, keys: Column<*>) : InsertStatement<Key> (source)

Statement using PostgreSQL upsert.

Constructors

Link copied to clipboard
fun InsertOrUpdate(table: Table, isIgnore: Boolean = false, vararg keys: Column<*>)

Functions

Link copied to clipboard
open override fun arguments(): List<Iterable<Pair<IColumnType, Any?>>>
Link copied to clipboard
open operator fun contains(column: Column<*>): Boolean
Link copied to clipboard
fun execute(transaction: Transaction): Int?
Link copied to clipboard
open override fun PreparedStatementApi.executeInternal(transaction: Transaction): Int
Link copied to clipboard
infix operator fun <T> get(column: Column<T>): T
infix operator fun <T> get(column: CompositeColumn<T>): T
Link copied to clipboard
fun <T> getOrNull(column: Column<T>): T?
Link copied to clipboard
open override fun prepared(transaction: Transaction, sql: String): PreparedStatementApi
Link copied to clipboard
open override fun prepareSQL(transaction: Transaction): String
Link copied to clipboard
open operator fun <S> set(column: Column<S>, value: S)
open operator fun <T, S : T, E : Expression<S>> set(column: Column<T>, value: E)
open operator fun <S> set(column: Column<S>, value: Query)
operator fun <S, ID : EntityID<S>, E : Expression<S>> set(column: Column<ID>, value: E)
operator fun <S : Comparable<S>, ID : EntityID<S>> set(column: Column<ID>, value: S)
operator fun <S : Comparable<S>> set(column: Column<EntityID<S>?>, value: S?)
open operator fun <S : Any> set(column: CompositeColumn<S>, value: S)
Link copied to clipboard
open fun <T, S : T?> update(column: Column<T>, value: SqlExpressionBuilder.() -> Expression<S>)
open fun <T, S : T?> update(column: Column<T>, value: Expression<S>)

Properties

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
var resultedValues: List<ResultRow>?
Link copied to clipboard
val table: Table
Link copied to clipboard
val targets: List<Table>
Link copied to clipboard
val type: StatementType