stormify/onl.ycode.stormify.biglist/MultiAggregator

MultiAggregator

A multi-value aggregator built from a chain of aggregation requests over a PagedListBase. Each chain method adds another expression to the generated SELECT list. execute returns a Map<String, Any?> keyed by the alias of each added aggregation.

Obtained by chaining additional methods onto a SingleAggregator — conceptually the "two or more aggregations" view. Acquire via PagedListBase.getAggregator and then chain .sum(…), .avg(…), … Aggregations respect the parent list's constraints and per-column filters.

val row = list.getAggregator()
    .sum("revenue", "total")
    .avg("revenue", "average")
    .count("*", "cnt")
    .execute()
val total = row["total"] as BigDecimal

Properties

query

val query: String

The SQL that execute will run against the database.

Functions

avg

@JvmOverloads

fun avg(path: String, alias: String? = null): MultiAggregator

Adds AVG(path) with an optional alias.

@JvmOverloads

fun avg(path: ScalarPath, alias: String? = null): MultiAggregator

Adds AVG(path) using a type-safe ScalarPath with an optional alias.

count

@JvmOverloads

fun count(path: String, alias: String? = null): MultiAggregator

Adds COUNT(path) with an optional alias. Pass "*" for COUNT(*).

@JvmOverloads

fun count(path: ScalarPath, alias: String? = null): MultiAggregator

Adds COUNT(path) using a type-safe ScalarPath with an optional alias.

countDistinct

@JvmOverloads

fun countDistinct(path: String, alias: String? = null): MultiAggregator

Adds COUNT(DISTINCT path) with an optional alias.

@JvmOverloads

fun countDistinct(path: ScalarPath, alias: String? = null): MultiAggregator

Adds COUNT(DISTINCT path) using a type-safe ScalarPath with an optional alias.

execute

fun execute(): Map<String, Any?>

Executes the chained aggregations in a single query and returns a map keyed by each added aggregation's alias. The map values are the raw column results — callers are responsible for any type coercion.

max

@JvmOverloads

fun max(path: String, alias: String? = null): MultiAggregator

Adds MAX(path) with an optional alias.

@JvmOverloads

fun max(path: ScalarPath, alias: String? = null): MultiAggregator

Adds MAX(path) using a type-safe ScalarPath with an optional alias.

min

@JvmOverloads

fun min(path: String, alias: String? = null): MultiAggregator

Adds MIN(path) with an optional alias.

@JvmOverloads

fun min(path: ScalarPath, alias: String? = null): MultiAggregator

Adds MIN(path) using a type-safe ScalarPath with an optional alias.

raw

@JvmOverloads

fun raw(expression: String, alias: String? = null): MultiAggregator

Adds an arbitrary SQL expression as a standalone aggregation column. The expression is emitted verbatim — callers are responsible for writing safe, dialect-compatible SQL.

sum

@JvmOverloads

fun sum(path: String, alias: String? = null): MultiAggregator

Adds SUM(path) with an optional alias.

@JvmOverloads

fun sum(path: ScalarPath, alias: String? = null): MultiAggregator

Adds SUM(path) using a type-safe ScalarPath with an optional alias.