# 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

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

## Properties

data
Link copied to clipboard
val data: ArrayList<Pair<EntityID<*>, Map<Column<*>, Any?>>>

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

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

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

limit
Link copied to clipboard
val limit: Int?
table
Link copied to clipboard
val table: IdTable<*>
targets
Link copied to clipboard
val targets: List<Table>
targetsSet
Link copied to clipboard
val targetsSet: ColumnSet
type
Link copied to clipboard
val type: StatementType
where
Link copied to clipboard
val where: Op<Boolean>?

## Functions

addBatch
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`.

arguments
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.

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

Returns the string representation of an SQL statement.

set
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)
update
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: () -> Expression<S>)

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