exposed-core/org.jetbrains.exposed.v1.core.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<*>>

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.

prepareSQL

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

Returns the string representation of an SQL statement.