BatchUpdateStatement

open class BatchUpdateStatement(val table: IdTable<*>) : UpdateStatement

Represents the SQL statement that batch updates rows of a table.

Parameters

table

Identity table to update values from.

Constructors

Link copied to clipboard
constructor(table: IdTable<*>)

Properties

Link copied to clipboard

The mappings of columns to update with their updated values for each entity in the batch.

Link copied to clipboard
open override val firstDataSet: List<Pair<Column<*>, Any?>>

The initial list of columns to update with their updated values.

Link copied to clipboard
val limit: Int?
Link copied to clipboard
val table: IdTable<*>
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

The mapping of columns scheduled for change with their new values.

Link copied to clipboard
val where: Op<Boolean>? = null

Functions

Link copied to clipboard
fun addBatch(id: EntityID<*>)

Adds the specified entity id to the current list of update statements, using the mapping of columns to update provided for this BatchUpdateStatement.

Link copied to clipboard
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.

Link copied to clipboard
open operator fun contains(column: Column<*>): Boolean
Link copied to clipboard
open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String

Returns the string representation of an SQL statement.

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: AbstractQuery<*>)
@JvmName(name = "setWithEntityIdExpression")
operator fun <S, ID : EntityID<S>, E : Expression<S>> set(column: Column<ID>, value: E)
@JvmName(name = "setWithNullableEntityIdValue")
operator fun <S : Any> set(column: Column<EntityID<S>?>, value: S?)
@JvmName(name = "setWithEntityIdValue")
operator fun <S : Any> set(column: Column<EntityID<S>>, value: S)
open operator fun <S> set(column: CompositeColumn<S>, value: S)
Link copied to clipboard
open override fun <T, S : T?> update(column: Column<T>, value: Expression<S>): Nothing

Updates the mapping of the specified column with the specified value if column has not been previously set up for a change and if value is of a valid type.

open fun <T, S : T?> update(column: Column<T>, value: SqlExpressionBuilder.() -> Expression<S>)

Updates the mapping of the specified column with the value of the provided expression.