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 28 29 | 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 1x | import {seq, optPrio, altPrio, Expression, ver, tok} from "../combi";
import {IStatementRunnable} from "../statement_runnable";
import {Release} from "../../../version";
import {ParenLeftW, WParenRightW} from "../../1_lexer/tokens";
import {DatabaseTable, SQLCond, SQLSource} from ".";
export class SQLHierarchyAccessor extends Expression {
public getRunnable(): IStatementRunnable {
const distanceTo = seq("TO", SQLSource);
const distanceFrom = seq("FROM", SQLSource, optPrio(distanceTo));
const distance = seq("DISTANCE", altPrio(distanceFrom, distanceTo));
const accessor = seq(
"SOURCE", DatabaseTable,
"START", "WHERE", SQLCond,
optPrio(distance),
);
const name = altPrio("HIERARCHY_DESCENDANTS", "HIERARCHY_ANCESTORS", "HIERARCHY_SIBLINGS");
return ver(Release.v750, seq(
name,
tok(ParenLeftW),
accessor,
tok(WParenRightW),
));
}
}
|