expressions sql_order_by.ts

100% Statements 17/17

100% Branches 1/1

100% Functions 1/1

100% Lines 17/17

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 1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x
1x import {Expression, plus, opt, alt, seq, altPrio, ver} from "../combi";
import {IStatementRunnable} from "../statement_runnable";
import {Dynamic} from "./dynamic";
import {Release} from "../../../version";
import {SQLField} from "./sql_field";
import {SQLFieldName} from "./sql_field_name";
 
export class SQLOrderBy extends Expression {
  public getRunnable(): IStatementRunnable {
    const ding = alt("ASCENDING", "DESCENDING");
    const nulls = ver(Release.v778, seq("NULLS", alt("FIRST", "LAST")));
    const item = altPrio(ver(Release.v789, SQLField), SQLFieldName);
    const ofields = plus(seq(item, opt(ding), opt(nulls), opt(",")));
    const order = seq("ORDER BY", altPrio("PRIMARY KEY", Dynamic, ofields));
    return order;
  }
}