GroupBy

expect class GroupBy : Query, HavingRouter, OrderByRouter, LimitRouter(source)

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)

actual class GroupBy : Query, HavingRouter, OrderByRouter, LimitRouter(source)

Properties

parameters

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

addChangeListener

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>

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

open override fun addChangeListener(listener: QueryChangeListener): ListenerToken

open override fun addChangeListener(context: CoroutineContext, listener: suspend (changed: QueryChange) -> Unit): ListenerToken

open override fun addChangeListener(scope: CoroutineScope, listener: suspend (changed: QueryChange) -> Unit)

equals

open operator override fun equals(other: Any?): Boolean

execute

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

explain

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

hashCode

open override fun hashCode(): Int

having

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

limit

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