exposed-upsert/dev.forst.exposed/InsertOrUpdate

InsertOrUpdate

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

Statement using PostgreSQL upsert.

Constructors

InsertOrUpdate

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

Functions

arguments

open override fun arguments(): List<Iterable<Pair<IColumnType, Any?>>>

contains

open operator fun contains(column: Column<*>): Boolean

execute

fun execute(transaction: Transaction): Int?

executeInternal

open override fun PreparedStatementApi.executeInternal(transaction: Transaction): Int

get

infix operator fun <T> get(column: Column<T>): T

infix operator fun <T> get(column: CompositeColumn<T>): T

getOrNull

fun <T> getOrNull(column: Column<T>): T?

prepared

open override fun prepared(transaction: Transaction, sql: String): PreparedStatementApi

prepareSQL

open override fun prepareSQL(transaction: Transaction): String

set

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)

update

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

insertedCount

var insertedCount: Int

isAlwaysBatch

open val isAlwaysBatch: Boolean

isIgnore

val isIgnore: Boolean

resultedValues

var resultedValues: List<ResultRow>?

table

val table: Table

targets

val targets: List<Table>

type

val type: StatementType