Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x | import {seq, altPrio, tok, Expression, optPrio} from "../combi";
import {ParenLeft, ParenLeftW} from "../../1_lexer/tokens";
import {Field, SQLCase, SQLFunction} from ".";
import {IStatementRunnable} from "../statement_runnable";
import {Dynamic} from "./dynamic";
import {SQLArithmetics} from "./sql_arithmetics";
export class SQLAggregation extends Expression {
public getRunnable(): IStatementRunnable {
const f = seq(optPrio("DISTINCT"), altPrio(SQLCase, SQLArithmetics, Dynamic, SQLFunction));
const fparen = seq("(", Field, ")");
const count = seq("COUNT", altPrio(tok(ParenLeft), tok(ParenLeftW)), optPrio("DISTINCT"), altPrio("*", Field, fparen), ")");
const max = seq("MAX", altPrio(tok(ParenLeft), tok(ParenLeftW)), f, ")");
const min = seq("MIN", altPrio(tok(ParenLeft), tok(ParenLeftW)), f, ")");
const sum = seq("SUM", altPrio(tok(ParenLeft), tok(ParenLeftW)), f, ")");
const avg = seq("AVG", altPrio(tok(ParenLeft), tok(ParenLeftW)), f, ")");
return altPrio(count, max, min, sum, avg);
}
} |