exposed-core/org.jetbrains.exposed.v1.core.statements/SQLServerBatchInsertStatement

SQLServerBatchInsertStatement

open class SQLServerBatchInsertStatement(table: Table, ignore: Boolean = false, val shouldReturnGeneratedValues: Boolean = true) : BatchInsertStatement

Represents the SQL statement that batch inserts new rows into a table, specifically for the SQL Server database.

Before adding each new batch, the class validates that the database's maximum number of inserted rows (1000) is not being exceeded.

Constructors

Link copied to clipboard
constructor(table: Table, ignore: Boolean = false, shouldReturnGeneratedValues: Boolean = true)

Properties

Link copied to clipboard
open override var arguments: List<List<Pair<Column<*>, Any?>>>?
Link copied to clipboard
var insertedCount: Int

The number of rows affected by the insert operation.

Link copied to clipboard
Link copied to clipboard
var resultedValues: List<ResultRow>?

The ResultRows generated by processing the database result set retrieved after executing the statement.

Link copied to clipboard
Link copied to clipboard
val table: Table
Link copied to clipboard
Link copied to clipboard

Functions

Link copied to clipboard
fun addBatch()

Adds the most recent batch to the current list of insert statements.

Link copied to clipboard
open override fun arguments(): List<List<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
infix operator fun <T> get(column: Column<T>): T
infix operator fun <T> get(column: CompositeColumn<T>): T
Link copied to clipboard
fun <T> getOrNull(column: Column<T>): T?

Returns the value of a given column from the first stored ResultRow, or null if either no results were retrieved from the database or if the column cannot be found in the row.

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

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

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.