module Clear::SQL::Query::Aggregate

Direct including types

#agg(field, x : X.class) forall X
Call an custom aggregation function, like MEDIAN or other:
#avg(field, x : X.class) forall X
SQL aggregation function "AVG":
#count(type : X.class = Int64) forall X
Use SQL COUNT over your query, and return this number as a Int64
#max(field, x : X.class) forall X
SQL aggregation function "MAX":
#min(field, x : X.class) forall X
SQL aggregation function "MIN":
#sum(field, x : X.class) forall X
SQL aggregation function "SUM":
#sum(field) : Float64
SUM through a field and return a Float64

def agg(field, x : X.class) forall X #

Call an custom aggregation function, like MEDIAN or other:

query.agg("MEDIAN(age)", Int64)

COUNT, MIN, MAX, SUM and AVG are already conveniently mapped.

This return only one row, and should not be used with group_by (prefer pluck or fetch)

[View source]

def avg(field, x : X.class) forall X #

SQL aggregation function "AVG":

  query.avg("field", Int64)

[View source]

def count(type : X.class = Int64) forall X #

Use SQL COUNT over your query, and return this number as a Int64

as count return always a scalar, the usage of COUNT(*) OVER GROUP BY can be done by using pluck or select

[View source]

def max(field, x : X.class) forall X #

SQL aggregation function "MAX":

  query.max("field", Int64)

[View source]

def min(field, x : X.class) forall X #

SQL aggregation function "MIN":

  query.min("field", Int64)

[View source]

def sum(field, x : X.class) forall X #

SQL aggregation function "SUM":

  query.sum("field", Int64)

[View source]

def sum(field) : Float64 #

SUM through a field and return a Float64

This function is not safe injection-wise, so beware !.

[View source]