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 21 22 23 24 25 26 27 | 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x 1x | import {SQLAggregation, SQLFunction, SQLPath} from "."; import {Version} from "../../../version"; import {WParenLeftW, WParenRightW} from "../../1_lexer/tokens"; import {Expression, ver, alt, seq, plus, tok, optPrio, opt, altPrio, starPrio} from "../combi"; import {IStatementRunnable} from "../statement_runnable"; import {Constant} from "./constant"; import {SQLCond} from "./sql_cond"; import {SQLFieldName} from "./sql_field_name"; import {SQLSource} from "./sql_source"; export class SQLCase extends Expression { public getRunnable(): IStatementRunnable { const field = altPrio(SQLAggregation, SQLCase, SQLFunction, SQLPath, SQLFieldName, Constant); const sub = seq(altPrio("+", "-", "*", "/", "&&"), optPrio(tok(WParenLeftW)), field, optPrio(tok(WParenRightW))); const when = seq("WHEN", alt(Constant, SQLCond), "THEN", altPrio(SQLAggregation, SQLFunction, SQLSource), starPrio(sub)); const els = seq("ELSE", SQLSource); return ver(Version.v740sp05, seq("CASE", opt(SQLFieldName), plus(when), optPrio(els), "END")); } } |