public static AST.ICommonTableDefinition TableDef <TType>(
TableReferenceCreator <TType> c,
SetSelectExpression expr)
{
return
(new AST.CommonTableDefinition <TType>(PlainSelectExpression.NewSet(expr), c));
}
public static SqlExpression SelectNode(
CommonTableExpression with,
SetSelectExpression select)
{
return
(SqlExpression.NewSelect(
SelectExpression.NewComplex(
new Tuple <CommonTableExpression, PlainSelectExpression>(
with,
PlainSelectExpression.NewSet(select)))));
}
public static SqlExpression SelectNode(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(SqlExpression.NewSelect(
SelectExpression.NewPlain(
PlainSelectExpression.NewPlain(
PlainSelect(select, from, where, groupBy, orderBy)))));
}
public static SqlExpression SelectNode(
CommonTableExpression with,
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(SqlExpression.NewSelect(
SelectExpression.NewComplex(
new Tuple <CommonTableExpression, PlainSelectExpression>(
with,
PlainSelectExpression.NewPlain(PlainSelect(select, from, where, groupBy, orderBy))))));
}
public static AST.ICommonTableDefinition TableDef <TType>(
TableIdentifier <TType> tdef,
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return
(new AST.CommonTableDefinition <TType>(
PlainSelectExpression.NewPlain(
new SelectExpressionToken(select, from, where.ToOption(), groupBy.ToOption(), orderBy.ToOption())),
tdef));
}
public static ValueNode SubExp(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null)
{
return(ValueNode.NewSubExpression(
PlainSelectExpression.NewPlain(
new SelectExpressionToken(
select,
from,
where.ToOption(),
groupBy.ToOption(),
orderBy.ToOption()))));
}
public static ValueNode SubExp(
SelectValuesExpressionNode select,
FromExpressionNode from,
WhereExpressionNode where = null,
GroupByExpressionNode groupBy = null,
OrderByExpressionNode orderBy = null,
LimitOffsetNode limitOffset = null)
{
return(ValueNode.NewSubExpression(
PlainSelectExpression.NewPlain(
new SelectExpressionToken(
select,
from,
where.ToOption(),
groupBy.ToOption(),
orderBy.ToOption(),
limitOffset ?? new LimitOffsetNode(FSharpOption <int> .None, FSharpOption <int> .None)))));
}
public static SetSelectExpression Minus(params SelectExpressionToken[] expr)
{
return(new SetSelectExpression(
AST.SetOperationType.Minus,
ListModule.OfSeq(expr.Select(e => PlainSelectExpression.NewPlain(e)))));
}
public static AST.ICommonTableDefinition TableDef <TType>(SetSelectExpression expr)
{
return(new AST.CommonTableDefinition <TType>(PlainSelectExpression.NewSet(expr), new TableIdentifier <TType>()));
}
