public override SqlObject VisitLimit_count([NotNull] sqlParser.Limit_countContext context)
{
Contract.Requires(context != null);
SqlLimitSpec sqlLimitSpec;
if (context.NUMERIC_LITERAL() != null)
{
sqlLimitSpec = SqlLimitSpec.Create(
SqlNumberLiteral.Create(
CstToAstVisitor.GetNumber64ValueFromNode(
context.NUMERIC_LITERAL())));
}
else if (context.PARAMETER() != null)
{
sqlLimitSpec = SqlLimitSpec.Create(
SqlParameter.Create(
context.PARAMETER().GetText()));
}
else
{
throw new NotImplementedException();
}
return(sqlLimitSpec);
}
public override SqlObject VisitOffset_limit_clause([NotNull] sqlParser.Offset_limit_clauseContext context)
{
Contract.Requires(context != null);
SqlOffsetSpec sqlOffsetSpec = SqlOffsetSpec.Create(
SqlNumberLiteral.Create(
CstToAstVisitor.GetNumber64ValueFromNode(
context.offset_count().NUMERIC_LITERAL())));
SqlLimitSpec sqlLimitSpec = SqlLimitSpec.Create(
SqlNumberLiteral.Create(
CstToAstVisitor.GetNumber64ValueFromNode(
context.limit_count().NUMERIC_LITERAL())));
return(SqlOffsetLimitClause.Create(sqlOffsetSpec, sqlLimitSpec));
}
/// <summary>
/// Convert the entire query to a SQL Query.
/// </summary>
/// <returns>The corresponding SQL Query.</returns>
public SqlQuery GetSqlQuery()
{
SqlFromClause fromClause;
if (this.inputQuery != null)
{
#if SUPPORT_SUBQUERIES
fromClause = this.CreateSubqueryFromClause();
#else
throw new DocumentQueryException("SQL subqueries currently not supported");
#endif
}
else
{
fromClause = this.CreateFrom(inputCollectionExpression: null);
}
// Create a SqlSelectClause with the topSpec.
// If the query is flatten then selectClause may have a topSpec. It should be taken in that case.
// If the query doesn't have a selectClause, use SELECT v0 where v0 is the input param.
SqlSelectClause selectClause = this.selectClause;
if (selectClause == null)
{
string parameterName = this.fromParameters.GetInputParameter().Name;
SqlScalarExpression parameterExpression = SqlPropertyRefScalarExpression.Create(null, SqlIdentifier.Create(parameterName));
selectClause = this.selectClause = SqlSelectClause.Create(SqlSelectValueSpec.Create(parameterExpression));
}
selectClause = SqlSelectClause.Create(selectClause.SelectSpec, selectClause.TopSpec ?? this.topSpec, selectClause.HasDistinct);
SqlOffsetLimitClause offsetLimitClause = (this.offsetSpec != null) ?
SqlOffsetLimitClause.Create(this.offsetSpec, this.limitSpec ?? SqlLimitSpec.Create(int.MaxValue)) :
offsetLimitClause = default(SqlOffsetLimitClause);
SqlQuery result = SqlQuery.Create(selectClause, fromClause, this.whereClause, this.orderByClause, offsetLimitClause);
return(result);
}
public override SqlObject Visit(SqlLimitSpec sqlObject)
{
return(SqlLimitSpec.Create(SqlNumberLiteral.Create(0)));
}