protected virtual void EmitParenthesisGroup(NPathParenthesisGroup parenthesisGroup)
{
if (parenthesisGroup.IsNegative)
Write("-");
Write("(");
EmitExpression(parenthesisGroup.Expression);
Write(")");
}
protected virtual bool EvalParenthesisExpression(object item, NPathParenthesisGroup parenthesisGroup)
{
return EvalExpression(item, parenthesisGroup.Expression);
}
protected virtual object EvalParenthesisValue(object item, NPathParenthesisGroup parenthesis)
{
object res = EvalValue(item, parenthesis.Expression);
if (parenthesis.IsNegative)
{
//negate result
return NegateValue(res);
}
else
return res;
}
private SqlExpression EvalMethodCall (NPathMethodCall methodCall)
{
if (methodCall.MethodName == "Count" && methodCall.Parameters.Count == 0)
{
string npath = string.Format("select count(*) from {0}",methodCall.PropertyPath.Path);
NPathParser parser = new NPathParser() ;
NPathSelectQuery query = parser.ParseSelectQuery(npath) ;
NPathParenthesisGroup pg = new NPathParenthesisGroup() ;
pg.IsNegative = methodCall.PropertyPath.IsNegative;
pg.Expression = query;
return EvalExpression (pg);
}
throw new IAmOpenSourcePleaseImplementMeException (string.Format("Method calls to '{0}' is not yet implemented",methodCall.MethodName));
}
private SqlExpression EvalParenthesisGroup(NPathParenthesisGroup parenthesisGroup)
{
if (conditionChainOwner != null && !(parenthesisGroup.Expression is NPathSelectQuery) )
{
SqlSearchCondition prev;
if (conditionChainOwner is SqlSearchCondition)
prev = (SqlSearchCondition) conditionChainOwner;
else
prev = conditionChainOwner.GetCurrentSqlSearchCondition();
SqlSearchCondition search = conditionChainOwner.GetNextSqlSearchCondition() ;
SqlSearchCondition sub = search.GetSubSqlSearchCondition();
conditionChainOwner = sub;
noNext = true;
EvalExpression(parenthesisGroup.Expression);
conditionChainOwner = prev;
return search;
}
else
{
//Roger
SqlExpression sqlExpression = EvalExpression(parenthesisGroup.Expression);
SqlParenthesisGroup sqlParenthesisGroup = new SqlParenthesisGroup(parenthesisGroup.IsNegative,sqlExpression) ;
return sqlParenthesisGroup;
}
}
private IValue ParseValue()
{
IValue operand = null;
bool isNegative = false;
if (tokenizer.GetCurrentToken().IsType("sign"))
{
if (tokenizer.GetCurrentToken().IsType("minus"))
isNegative = true;
tokenizer.MoveNext();
}
Token currentToken = tokenizer.GetCurrentToken();
#region parse value
if (currentToken.IsType("null"))
{
NPathNullValue nullOperand = new NPathNullValue();
operand = nullOperand;
tokenizer.MoveNext();
}
else if (currentToken.IsType("parameter"))
{
NPathParameter parameterOperand = new NPathParameter();
parameterOperand.Value = parameterQueue[0];
parameterQueue.RemoveAt(0);
operand = parameterOperand;
tokenizer.MoveNext();
}
else if (tokenizer.GetCurrentToken().IsType("textsearch"))
{
return ParseSearchFunctionExpression();
}
else if (currentToken.IsType("function") && IsInSelectClause() || currentToken.IsType("isnull") || currentToken.IsType("soundex"))
{
NPathFunction functionOperand = new NPathFunction();
if (currentToken.IsType("soundex"))
functionOperand = new NPathSoundexStatement();
if (currentToken.IsType("sum"))
functionOperand = new NPathSumStatement();
if (currentToken.IsType("isnull"))
functionOperand = new NPathIsNullStatement();
if (currentToken.IsType("count"))
functionOperand = new NPathCountStatement();
if (currentToken.IsType("avg"))
functionOperand = new NPathAvgStatement();
if (currentToken.IsType("min"))
functionOperand = new NPathMinStatement();
if (currentToken.IsType("max"))
functionOperand = new NPathMaxStatement();
tokenizer.MoveNext();
tokenizer.GetCurrentToken("(", "(");
tokenizer.MoveNext();
if (tokenizer.GetCurrentToken().IsType("distinct"))
{
functionOperand.Distinct = true;
tokenizer.MoveNext();
}
functionOperand.Expression = ParseBooleanExpression();
tokenizer.GetCurrentToken(")", ")");
tokenizer.MoveNext();
operand = functionOperand;
}
else if (currentToken.IsType("date"))
{
NPathDateTimeValue dateOperand = new NPathDateTimeValue();
dateOperand.Value = DateTime.Parse(currentToken.Text);
operand = dateOperand;
tokenizer.MoveNext();
}
else if (currentToken.IsType("decimal"))
{
NPathDecimalValue decimalOperand = new NPathDecimalValue();
decimalOperand.Value = double.Parse(currentToken.Text, NumberFormatInfo.InvariantInfo);
decimalOperand.IsNegative = isNegative;
operand = decimalOperand;
tokenizer.MoveNext();
}
else if (currentToken.IsType("string"))
{
NPathStringValue stringOperand = new NPathStringValue();
string text = currentToken.Text;
text = text.Substring(1, text.Length - 2);
if (currentToken.IsType("string '")) // do not localize
text = text.Replace("''", "'");
else if (currentToken.IsType("string \""))
text = text.Replace("\"\"", "\""); // do not localize
stringOperand.Value = text;
operand = stringOperand;
tokenizer.MoveNext();
}
else if (currentToken.IsType("boolean"))
{
NPathBooleanValue booleanOperand = new NPathBooleanValue();
booleanOperand.Value = bool.Parse(currentToken.Text);
operand = booleanOperand;
tokenizer.MoveNext();
}
else if (currentToken.IsType("guid"))
{
NPathGuidValue guidOperand = new NPathGuidValue();
guidOperand.Value = currentToken.Text;
operand = guidOperand;
tokenizer.MoveNext();
}
else if (currentToken.IsType("property path")) // do not localize
{
if (tokenizer.GetNextToken().IsType("("))
{
string fullPath = currentToken.Text;
string propertyPath = "";
string methodName = "";
int lastIndexOfDot = fullPath.LastIndexOf(".");
if (lastIndexOfDot > 0)
{
propertyPath = fullPath.Substring(0, lastIndexOfDot);
methodName = fullPath.Substring(lastIndexOfDot + 1);
}
else
{
methodName = fullPath;
}
NPathMethodCall call = new NPathMethodCall();
call.MethodName = methodName;
call.PropertyPath = new NPathIdentifier();
call.PropertyPath.Path = propertyPath;
call.PropertyPath.IsNegative = isNegative;
//TODO:add method support here
tokenizer.MoveNext(); //move past "("
tokenizer.MoveNext();
while (!tokenizer.GetCurrentToken().IsType(")"))
{
IValue param = ParseExpression();
call.Parameters.Add(param);
if (tokenizer.GetCurrentToken().IsType("comma"))
{
tokenizer.MoveNext();
}
else
{
tokenizer.GetCurrentToken(")", ")");
}
}
tokenizer.MoveNext();
operand = call;
}
else if (tokenizer.GetNextToken().IsType("["))
{
CurrentPropertyPrefix = currentToken.Text + ".";
NPathBracketGroup bracketGroup = new NPathBracketGroup();
tokenizer.MoveNext();
ParseBracketGroup(bracketGroup);
CurrentPropertyPrefix = "";
NPathParenthesisGroup parens = new NPathParenthesisGroup();
parens.Expression = bracketGroup.Expression;
operand = parens;
}
else
{
NPathIdentifier propertyOperand = new NPathIdentifier();
propertyOperand.Path = CurrentPropertyPrefix + currentToken.Text;
propertyOperand.ReferenceLocation = IsInSelectClause() ? NPathPropertyPathReferenceLocation.SelectClause : NPathPropertyPathReferenceLocation.WhereClause;
//CurrentQuery.AddPropertyPathReference(propertyOperand.Path) ;
propertyOperand.IsNegative = isNegative;
operand = propertyOperand;
tokenizer.MoveNext();
}
}
else if (currentToken.IsType("("))
{
NPathParenthesisGroup parenthesisOperand = new NPathParenthesisGroup();
ParseParenthesisGroup(parenthesisOperand);
parenthesisOperand.IsNegative = isNegative;
operand = parenthesisOperand;
}
else
{
//unknown value?
throw GetUnknownTokenException();
}
#endregion
return operand;
}
private void ParseParenthesisGroup(NPathParenthesisGroup parenthesisGroup)
{
tokenizer.GetCurrentToken("(", "(");
tokenizer.MoveNext(); //step past (
if (tokenizer.GetCurrentToken().IsType("select"))
{
parenthesisGroup.Expression = ParseSelectQuery();
}
else
{
parenthesisGroup.Expression = ParseBooleanExpression();
}
tokenizer.GetCurrentToken(")", ")");
tokenizer.MoveNext(); // step past )
}
private void EmitWhere()
{
conditionChainOwner = select.SqlWhereClause;
if (query.Where != null)
{
//EvalExpression (query.Where.Expression);
NPathParenthesisGroup parens = new NPathParenthesisGroup();
parens.Expression = query.Where.Expression;
EvalParenthesisGroup ( parens );
}
}
