protected override void GetData(SerializationInfo info, StreamingContext context)
{
if (SelectColumns != null)
{
info.AddValue("Columns", SelectColumns.ToArray());
}
else
{
info.AddValue("Columns", null, typeof(SelectColumn[]));
}
info.AddValue("Distinct", Distinct);
info.AddValue("From", FromClause, typeof(FromClause));
info.AddValue("Where", WhereExpression, typeof(SqlExpression));
info.AddValue("Having", HavingExpression, typeof(SqlExpression));
if (GroupBy != null)
{
info.AddValue("GroupBy", GroupBy.ToArray());
}
else
{
info.AddValue("GroupBy", null, typeof(SqlExpression[]));
}
info.AddValue("GroupMax", GroupMax, typeof(ObjectName));
info.AddValue("NextComposite", NextComposite, typeof(SqlQueryExpression));
info.AddValue("CompositeFunction", (int)CompositeFunction);
info.AddValue("CompositeAll", IsCompositeAll);
}
protected override void GetData(SerializeData data)
{
if (SelectColumns != null)
{
data.SetValue("Columns", SelectColumns.ToArray());
}
data.SetValue("Distinct", Distinct);
data.SetValue("From", FromClause);
data.SetValue("Where", WhereExpression);
data.SetValue("Having", HavingExpression);
if (GroupBy != null)
{
data.SetValue("GroupBy", GroupBy.ToArray());
}
data.SetValue("GroupMax", GroupMax);
data.SetValue("NextComposite", NextComposite);
data.SetValue("CompositeFunction", (int)CompositeFunction);
data.SetValue("CompositeAll", IsCompositeAll);
}
/// <summary>
/// Tries to parse a script node.
/// </summary>
/// <param name="Parser">Custom parser.</param>
/// <param name="Result">Parsed Script Node.</param>
/// <returns>If successful in parsing a script node.</returns>
public bool TryParse(ScriptParser Parser, out ScriptNode Result)
{
Result = null;
try
{
List <ScriptNode> Columns;
List <ScriptNode> ColumnNames;
ScriptNode Top = null;
string s;
bool Distinct = false;
s = Parser.PeekNextToken().ToUpper();
if (string.IsNullOrEmpty(s))
{
return(false);
}
while (s == "TOP" || s == "DISTINCT")
{
switch (s)
{
case "TOP":
Parser.NextToken();
Top = Parser.ParseNoWhiteSpace();
break;
case "DISTINCT":
Parser.NextToken();
Distinct = true;
break;
}
s = Parser.PeekNextToken();
if (string.IsNullOrEmpty(s))
{
return(false);
}
}
if (s == "*")
{
Parser.NextToken();
Columns = null;
ColumnNames = null;
}
else
{
Columns = new List <ScriptNode>();
ColumnNames = new List <ScriptNode>();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
ScriptNode Name = null;
Parser.SkipWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (!string.IsNullOrEmpty(s) && s != "," && s != "FROM")
{
if (s == "AS")
{
Parser.NextToken();
}
Name = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken();
}
else if (Node is VariableReference Ref)
{
Name = new ConstantElement(new StringValue(Ref.VariableName), Node.Start, Node.Length, Node.Expression);
}
else if (Node is NamedMember NamedMember)
{
Name = new ConstantElement(new StringValue(NamedMember.Name), Node.Start, Node.Length, Node.Expression);
}
Columns.Add(Node);
ColumnNames.Add(Name);
if (s != ",")
{
break;
}
Parser.NextToken();
}
}
s = Parser.NextToken().ToUpper();
if (s != "FROM")
{
return(false);
}
if (!TryParseSources(Parser, out SourceDefinition Source))
{
return(false);
}
ScriptNode Where = null;
s = Parser.PeekNextToken().ToUpper();
if (s == "WHERE")
{
Parser.NextToken();
Where = Parser.ParseOrs();
s = Parser.PeekNextToken().ToUpper();
}
List <ScriptNode> GroupBy = null;
List <ScriptNode> GroupByNames = null;
ScriptNode Having = null;
if (s == "GROUP")
{
Parser.NextToken();
if (Parser.NextToken().ToUpper() != "BY")
{
return(false);
}
GroupBy = new List <ScriptNode>();
GroupByNames = new List <ScriptNode>();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
ScriptNode Name = null;
Parser.SkipWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (!string.IsNullOrEmpty(s) && s != "," && s != "HAVING" && s != "ORDER" && s != "OFFSET")
{
if (s == "AS")
{
Parser.NextToken();
}
Name = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
}
else if (Node is VariableReference Ref)
{
Name = new ConstantElement(new StringValue(Ref.VariableName), Node.Start, Node.Length, Node.Expression);
}
else if (Node is NamedMember NamedMember)
{
Name = new ConstantElement(new StringValue(NamedMember.Name), Node.Start, Node.Length, Node.Expression);
}
GroupBy.Add(Node);
GroupByNames.Add(Name);
if (s != ",")
{
break;
}
Parser.NextToken();
}
if (s == "HAVING")
{
Parser.NextToken();
Having = Parser.ParseOrs();
s = Parser.PeekNextToken().ToUpper();
}
}
else if (!(Columns is null))
{
bool ImplicitGrouping = false;
foreach (ScriptNode Column in Columns)
{
if (this.ContainsVectorFunction(Column))
{
ImplicitGrouping = true;
break;
}
}
if (ImplicitGrouping)
{
GroupBy = new List <ScriptNode>();
GroupByNames = new List <ScriptNode>();
}
}
List <KeyValuePair <ScriptNode, bool> > OrderBy = null;
if (s == "ORDER")
{
Parser.NextToken();
if (Parser.NextToken().ToUpper() != "BY")
{
return(false);
}
OrderBy = new List <KeyValuePair <ScriptNode, bool> >();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (s == "ASC")
{
Parser.NextToken();
OrderBy.Add(new KeyValuePair <ScriptNode, bool>(Node, true));
s = Parser.PeekNextToken().ToUpper();
}
else if (s == "DESC")
{
Parser.NextToken();
OrderBy.Add(new KeyValuePair <ScriptNode, bool>(Node, false));
s = Parser.PeekNextToken().ToUpper();
}
else
{
OrderBy.Add(new KeyValuePair <ScriptNode, bool>(Node, true));
}
if (s != ",")
{
break;
}
Parser.NextToken();
}
}
ScriptNode Offset = null;
if (s == "OFFSET")
{
Parser.NextToken();
Offset = Parser.ParseNoWhiteSpace();
}
Result = new Select(Columns?.ToArray(), ColumnNames?.ToArray(), Source, Where, GroupBy?.ToArray(),
GroupByNames?.ToArray(), Having, OrderBy?.ToArray(), Top, Offset, Distinct,
Parser.Start, Parser.Length, Parser.Expression);
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Tries to parse a script node.
/// </summary>
/// <param name="Parser">Custom parser.</param>
/// <param name="Result">Parsed Script Node.</param>
/// <returns>If successful in parsing a script node.</returns>
public bool TryParse(ScriptParser Parser, out ScriptNode Result)
{
Result = null;
try
{
List <ScriptNode> Columns;
List <ScriptNode> ColumnNames;
ScriptNode Top;
string s;
s = Parser.PeekNextToken().ToUpper();
if (s == string.Empty)
{
return(false);
}
if (s == "TOP")
{
Parser.NextToken();
Top = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken();
if (s == string.Empty)
{
return(false);
}
}
else
{
Top = null;
}
if (s == "*")
{
Parser.NextToken();
Columns = null;
ColumnNames = null;
}
else
{
Columns = new List <ScriptNode>();
ColumnNames = new List <ScriptNode>();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
ScriptNode Name = null;
Parser.SkipWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (!string.IsNullOrEmpty(s) && s != "," && s != "FROM")
{
Name = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken();
}
else if (Node is VariableReference Ref)
{
Name = new ConstantElement(new StringValue(Ref.VariableName), Node.Start, Node.Length, Node.Expression);
}
Columns.Add(Node);
ColumnNames.Add(Name);
if (s != ",")
{
break;
}
Parser.NextToken();
}
}
s = Parser.NextToken().ToUpper();
if (s != "FROM")
{
return(false);
}
List <ScriptNode> Sources = new List <ScriptNode>();
List <ScriptNode> SourceNames = new List <ScriptNode>();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
ScriptNode Name = null;
Parser.SkipWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (!string.IsNullOrEmpty(s) && s != "," && s != "WHERE" && s != "GROUP" && s != "ORDER" && s != "OFFSET")
{
Name = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
}
else if (Node is VariableReference Ref)
{
Name = new ConstantElement(new StringValue(Ref.VariableName), Node.Start, Node.Length, Node.Expression);
}
Sources.Add(Node);
SourceNames.Add(Name);
if (s != ",")
{
break;
}
Parser.NextToken();
}
ScriptNode Where = null;
if (s == "WHERE")
{
Parser.NextToken();
Where = Parser.ParseOrs();
s = Parser.PeekNextToken().ToUpper();
}
List <ScriptNode> GroupBy = null;
List <ScriptNode> GroupByNames = null;
ScriptNode Having = null;
if (s == "GROUP")
{
Parser.NextToken();
if (Parser.NextToken().ToUpper() != "BY")
{
return(false);
}
GroupBy = new List <ScriptNode>();
GroupByNames = new List <ScriptNode>();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
ScriptNode Name = null;
Parser.SkipWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (!string.IsNullOrEmpty(s) && s != "," && s != "HAVING" && s != "ORDER" && s != "OFFSET")
{
Name = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
}
else if (Node is VariableReference Ref)
{
Name = new ConstantElement(new StringValue(Ref.VariableName), Node.Start, Node.Length, Node.Expression);
}
GroupBy.Add(Node);
GroupByNames.Add(Name);
if (s != ",")
{
break;
}
Parser.NextToken();
}
if (s == "HAVING")
{
Parser.NextToken();
Having = Parser.ParseOrs();
s = Parser.PeekNextToken().ToUpper();
}
}
List <KeyValuePair <ScriptNode, bool> > OrderBy = null;
if (s == "ORDER")
{
Parser.NextToken();
if (Parser.NextToken().ToUpper() != "BY")
{
return(false);
}
OrderBy = new List <KeyValuePair <ScriptNode, bool> >();
while (true)
{
ScriptNode Node = Parser.ParseNoWhiteSpace();
s = Parser.PeekNextToken().ToUpper();
if (s == "ASC")
{
Parser.NextToken();
OrderBy.Add(new KeyValuePair <ScriptNode, bool>(Node, true));
s = Parser.PeekNextToken().ToUpper();
}
else if (s == "DESC")
{
Parser.NextToken();
OrderBy.Add(new KeyValuePair <ScriptNode, bool>(Node, false));
s = Parser.PeekNextToken().ToUpper();
}
else
{
OrderBy.Add(new KeyValuePair <ScriptNode, bool>(Node, true));
}
if (s != ",")
{
break;
}
Parser.NextToken();
}
}
ScriptNode Offset = null;
if (s == "OFFSET")
{
Parser.NextToken();
Offset = Parser.ParseNoWhiteSpace();
}
Result = new Select(Columns?.ToArray(), ColumnNames?.ToArray(), Sources.ToArray(), SourceNames.ToArray(),
Where, GroupBy?.ToArray(), GroupByNames?.ToArray(), Having, OrderBy?.ToArray(), Top, Offset,
Parser.Start, Parser.Length, Parser.Expression);
return(true);
}
catch (Exception)
{
return(false);
}
}