private static SqlQueryExpression Form(IContext context, PlSqlParser.QueryBlockContext queryBlock,
out SqlParseIntoClause into)
{
var fromClause = FromClauseBuilder.Build(context, queryBlock.fromClause());
SqlQueryExpressionItem[] columns;
if (queryBlock.all != null)
{
columns = new[] { new SqlQueryExpressionItem(SqlExpression.Reference(new ObjectName("*"))) };
}
else
{
columns = queryBlock.selectedElement().Select(x => SelectElement.BuildColumn(context, x)).ToArray();
}
var query = new SqlQueryExpression();
foreach (var column in columns)
{
query.Items.Add(column);
}
@into = null;
if (queryBlock.DISTINCT() != null ||
queryBlock.UNIQUE() != null)
{
query.Distinct = true;
}
var intoClause = queryBlock.into_clause();
if (intoClause != null)
{
@into = new SqlParseIntoClause();
if (intoClause.objectName() != null)
{
@into.TableName = SqlParseUtil.Name.Object(intoClause.objectName());
}
else if (intoClause.variable_name() != null)
{
@into.Variables = intoClause.variable_name().Select(Name.Variable).ToArray();
}
}
if (fromClause != null)
{
query.From = fromClause;
}
var groupBy = queryBlock.groupByClause();
if (groupBy != null && !groupBy.IsEmpty)
{
query.GroupBy = groupBy.groupByElements().expression()
.Select(x => new PlSqlExpressionVisitor(context).Visit(x)).ToList();
var having = groupBy.havingClause();
if (having != null)
{
query.Having = new PlSqlExpressionVisitor(context).Visit(having.condition());
}
}
var groupMax = queryBlock.groupMaxClause();
if (groupMax != null && !groupMax.IsEmpty)
{
var maxColumn = Name.Object(groupMax.objectName());
query.GroupMax = maxColumn;
}
var whereClause = queryBlock.whereClause();
if (whereClause != null && !whereClause.IsEmpty)
{
var currentOf = whereClause.current_of_clause();
if (currentOf != null && !currentOf.IsEmpty)
{
var cursorName = Name.Simple(currentOf.cursor_name());
throw new NotImplementedException();
}
else
{
query.Where = new PlSqlExpressionVisitor(context).Visit(whereClause.conditionWrapper());
}
}
//TODO: in case of a SELECT INTO cause create a statement
return(query);
}