exposed-core/org.jetbrains.exposed.sql.statements/ReplaceSelectStatement

ReplaceSelectStatement

open class ReplaceSelectStatement(val columns: List<Column<*>>, val selectQuery: AbstractQuery<*>) : InsertSelectStatement

Represents the SQL statement that uses data retrieved from a selectQuery to either insert a new row into a table, or, if insertion would violate a unique constraint, first delete the existing row before inserting a new row.

Parameters

columns

Columns to either insert values into or delete values from then insert into.

selectQuery

Source SELECT query that provides the values to insert.

Constructors

ReplaceSelectStatement

constructor(columns: List<Column<*>>, selectQuery: AbstractQuery<*>)

Properties

columns

val columns: List<Column<*>>

isAlwaysBatch

open val isAlwaysBatch: Boolean

Whether the SQL statement is meant to be performed as part of a batch execution.

isIgnore

val isIgnore: Boolean = false

selectQuery

val selectQuery: AbstractQuery<*>

targets

val targets: List<Table>

type

val type: StatementType

Functions

arguments

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

Returns all mappings of columns and expression types to their values needed to prepare an SQL statement.

execute

fun execute(transaction: Transaction): Int?

Executes the SQL statement directly in the provided transaction and returns the generated result, or null if either no result was retrieved or if the transaction blocked statement execution.

executeInternal

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

Determines the exact way that an SQL statement is executed in a transaction and applies any necessary logic before returning the result generated by the executed statement.

prepared

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

Uses a transaction connection and an sql string representation to return a precompiled SQL statement, stored as an implementation of PreparedStatementApi.

prepareSQL

open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String

Returns the string representation of an SQL statement.