exposed-core/org.jetbrains.exposed.sql/Union

Union

class Union(firstStatement: AbstractQuery<*>, val secondStatement: AbstractQuery<*>) : SetOperation

Represents an SQL operation that combines all results from two queries, without any duplicates.

Constructors

Union

constructor(firstStatement: AbstractQuery<*>, secondStatement: AbstractQuery<*>)

Properties

fetchSize

var fetchSize: Int?

The number of results that should be fetched when this query is executed.

firstStatement

val firstStatement: AbstractQuery<*>

The SQL statement on the left-hand side of the set operator.

isAlwaysBatch

open val isAlwaysBatch: Boolean

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

limit

var limit: Int?

The stored value for a LIMIT clause in this query.

offset

var offset: Long

The stored value for an OFFSET clause in this query.

operationName

open val operationName: String

The SQL keyword representing the set operation.

orderByExpressions

var orderByExpressions: List<Pair<Expression<*>, SortOrder>>

The stored list of columns and their SortOrder for an ORDER BY clause in this query.

secondStatement

val secondStatement: AbstractQuery<*>

set

open override val set: FieldSet

The set of columns on which a query should be executed, contained by a ColumnSet.

targets

val targets: List<Table>

type

val type: StatementType

Functions

appendTo

fun <T> Iterable<T>.appendTo(builder: QueryBuilder, separator: CharSequence = ", ", prefix: CharSequence = "", postfix: CharSequence = "", transform: QueryBuilder.(T) -> Unit): QueryBuilder

Appends all the elements separated using separator and using the given prefix and postfix if supplied.

arguments

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.

copy

open override fun copy(): Union

Returns a new SizedIterable that is a copy of the original.

copyTo

open fun copyTo(other: SetOperation)

Copies all stored properties of this SELECT query into the properties of other.

count

open override fun count(): Long

Returns the number of results retrieved after query execution.

empty

open override fun empty(): Boolean

Returns whether any results were retrieved by query execution.

except

fun AbstractQuery<*>.except(other: Query): Except

Returns only distinct results from this query that are NOT common to the results of other.

execute

fun execute(transaction: Transaction): ResultSet?

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): ResultSet

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.

fetchSize

fun fetchSize(n: Int): SetOperation

Modifies the number of results that should be fetched when this query is executed.

forEach

open fun forEach(p0: Consumer<in ResultRow>)

forUpdate

open fun forUpdate(option: ForUpdateOption = ForUpdateOption.ForUpdate): SizedIterable<ResultRow>

Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.

intersect

fun AbstractQuery<*>.intersect(other: Query): Intersect

Returns only results from this query that are common to the results of other, WITHOUT including any duplicates.

iterator

open operator override fun iterator(): Iterator<ResultRow>

limit

open override fun limit(count: Int): SetOperation

Modifies this query to return only count results.

open override fun ~~limit~~(n: Int, offset: Long): SetOperation

mapLazy

infix fun <T, R> SizedIterable<T>.mapLazy(f: (T) -> R): SizedIterable<R>

Returns a SizedIterable containing the lazily evaluated results of applying the function f to each original element.

notForUpdate

open fun notForUpdate(): SizedIterable<ResultRow>

Returns a new SizedIterable without any locking read for the elements.

offset

open override fun offset(start: Long): SetOperation

Modifies this query to return only results starting after the specified start.

orderBy

open override fun orderBy(vararg order: Pair<Expression<*>, SortOrder>): SetOperation

Modifies this query to sort results according to the provided order of expressions.

fun orderBy(column: Expression<*>, order: SortOrder = SortOrder.ASC): SetOperation

Modifies this query to sort results by the specified column, according to the provided order.

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.

open override fun prepareSQL(builder: QueryBuilder): String

Returns the string representation of an SQL query, generated by appending SQL expressions to a QueryBuilder.

spliterator

open fun spliterator(): Spliterator<ResultRow>

union

fun AbstractQuery<*>.union(other: Query): Union

Combines all results from this query with the results of other, WITHOUT including duplicates.

unionAll

fun AbstractQuery<*>.unionAll(other: Query): UnionAll

Combines all results from this query with the results of other, WITH duplicates included.

withDistinct

open override fun withDistinct(value: Boolean): SetOperation

Modifies this query to retrieve only distinct results if value is set to true.