GroupBy

A GroupBy represents the GROUP BY clause to group the query result. The GROUP BY clause is normally used with aggregate functions (AVG, COUNT, MAX, MIN, SUM) to aggregate the group of the values.

actual class GroupBy : DelegatedClass<<Error class: unknown class>> , Query, HavingRouter, OrderByRouter, LimitRouter(source)

Properties

Link copied to clipboard
expect open override var parameters: Parameters?

Returns a copies of the current parameters.

open override var parameters: Parameters?

Returns a copies of the current parameters.

open override var parameters: Parameters?

Functions

Link copied to clipboard
expect open override fun addChangeListener(listener: QueryChangeListener): ListenerToken

Adds a change listener for the changes that occur in the query results.

expect open override fun addChangeListener(context: CoroutineContext, listener: QueryChangeSuspendListener): ListenerToken

Adds a change listener for the changes that occur in the query results with a CoroutineContext that will be used to launch coroutines the listener will be called on. Coroutines will be launched in a CoroutineScope that is canceled when the listener is removed.

expect open override fun addChangeListener(scope: CoroutineScope, listener: QueryChangeSuspendListener)

Adds a change listener for the changes that occur in the query results with a CoroutineScope that will be used to launch coroutines the listener will be called on. The listener is removed when the scope is canceled.

open override fun addChangeListener(listener: QueryChangeListener): <Error class: unknown class>

Adds a change listener for the changes that occur in the query results.

open override fun addChangeListener(context: CoroutineContext, listener: QueryChangeSuspendListener): <Error class: unknown class>

Adds a change listener for the changes that occur in the query results with a CoroutineContext that will be used to launch coroutines the listener will be called on. Coroutines will be launched in a CoroutineScope that is canceled when the listener is removed.

open override fun addChangeListener(scope: CoroutineScope, listener: QueryChangeSuspendListener)

Adds a change listener for the changes that occur in the query results with a CoroutineScope that will be used to launch coroutines the listener will be called on. The listener is removed when the scope is canceled.

open override fun addChangeListener(context: CoroutineContext, listener: suspend (changed: QueryChange) -> Unit): ListenerToken
open override fun addChangeListener(scope: CoroutineScope, listener: suspend (changed: QueryChange) -> Unit)
Link copied to clipboard
open operator override fun equals(other: Any?): Boolean
Link copied to clipboard
expect open override fun execute(): ResultSet

Executes the query. The returning a result set that enumerates result rows one at a time. You can run the query any number of times, and you can even have multiple ResultSet active at once.

open override fun execute(): ResultSet

Executes the query. The returning a result set that enumerates result rows one at a time. You can run the query any number of times, and you can even have multiple ResultSet active at once.

open override fun execute(): ResultSet
Link copied to clipboard
expect open override fun explain(): String

Returns a string describing the implementation of the compiled query. This is intended to be read by a developer for purposes of optimizing the query, especially to add database indexes. It's not machine-readable and its format may change. As currently implemented, the result is two or more lines separated by newline characters:

open override fun explain(): String

Returns a string describing the implementation of the compiled query. This is intended to be read by a developer for purposes of optimizing the query, especially to add database indexes. It's not machine-readable and its format may change. As currently implemented, the result is two or more lines separated by newline characters:

open override fun explain(): String
Link copied to clipboard
open override fun hashCode(): Int
Link copied to clipboard
expect open override fun having(expression: Expression): Having

Create and chain a Having object for filtering the aggregated values from the GROUP BY clause.

actual open override fun having(expression: Expression): Having

Create and chain a Having object for filtering the aggregated values from the GROUP BY clause.

actual open override fun having(expression: Expression): Having
Link copied to clipboard
expect open override fun limit(limit: Expression): Limit

Creates and chains a Limit object to limit the number query results.

expect open override fun limit(limit: Expression, offset: Expression?): Limit

Creates and chains a Limit object to skip the returned results for the given offset position and to limit the number of results to not more than the given limit value.

actual open override fun limit(limit: Expression): Limit

Creates and chains a Limit object to limit the number query results.

actual open override fun limit(limit: Expression, offset: Expression?): Limit

Creates and chains a Limit object to skip the returned results for the given offset position and to limit the number of results to not more than the given limit value.

actual open override fun limit(limit: Expression): Limit
actual open override fun limit(limit: Expression, offset: Expression?): Limit
Link copied to clipboard
expect open override fun orderBy(vararg orderings: Ordering): OrderBy

Create and chain an ORDER BY component for specifying the ORDER BY clause of the query.

actual open override fun orderBy(vararg orderings: Ordering): OrderBy

Create and chain an ORDER BY component for specifying the ORDER BY clause of the query.

actual open override fun orderBy(vararg orderings: Ordering): OrderBy
Link copied to clipboard
fun Query.queryChangeFlow(coroutineContext: CoroutineContext? = null): Flow<QueryChange>

A Flow of query changes.

Link copied to clipboard
expect open override fun removeChangeListener(token: ListenerToken)

Removes a change listener wih the given listener token.

open override fun removeChangeListener(token: <Error class: unknown class>)

Removes a change listener wih the given listener token.

open override fun removeChangeListener(token: ListenerToken)
Link copied to clipboard
open override fun toString(): String