private void ParseLogicalWord()
{
var word = SqlTokenHelper.Extract(_tokenType, _token);
var node = new LogicalOperatorNode(word);
AppendNode(node);
_nodeStack.Push(node);
}
internal bool EndsWithWordPart()
{
if (_rawSqlBuilder.Length == 0)
{
return(false);
}
var c = _rawSqlBuilder[_rawSqlBuilder.Length - 1];
return(SqlTokenHelper.IsWordPart(c));
}
private void ParseIfBlockComment()
{
var ifBlockNode = new IfBlockNode();
AppendNode(ifBlockNode);
_nodeStack.Push(ifBlockNode);
var expression = SqlTokenHelper.Extract(_tokenType, _token);
var ifNode = new IfNode(Location, expression, _token);
ifBlockNode.IfNode = ifNode;
_nodeStack.Push(ifNode);
}
private void ParseEmbeddedVariableBlockComment()
{
var variableName = SqlTokenHelper.Extract(_tokenType, _token);
if (string.IsNullOrEmpty(variableName))
{
throw new SqlParseException(ExceptionMessageId.Esp2121, _sql, _tokenizer.LineNumber,
_tokenizer.Position, _token);
}
var node = new EmbeddedVariableNode(Location, variableName, _token);
AppendNode(node);
_nodeStack.Push(node);
}
private bool IsWordStarted(char c)
{
if (c == '+' || c == '-')
{
if (_charPosition + 1 < _stringLength)
{
var next = _sql[_charPosition + 1];
if (char.IsDigit(next))
{
return(true);
}
}
}
return(SqlTokenHelper.IsWordPart(c));
}
private bool IsBlockCommentDirectiveTerminated()
{
if (_charPosition + 1 < _stringLength)
{
var next = _sql[_charPosition + 1];
if (!SqlTokenHelper.IsWordPart(next))
{
return(true);
}
}
else
{
return(true);
}
return(false);
}
private bool IsWordEnded()
{
if (_charPosition + 1 < _stringLength)
{
var next = _sql[_charPosition + 1];
if (!SqlTokenHelper.IsWordPart(next))
{
return(true);
}
}
else
{
return(true);
}
return(false);
}
private void PeekTenChars(char c, char c2, char c3, char c4, char c5,
char c6, char c7, char c8, char c9, char c10)
{
if ((c == 'f' || c == 'F') && (c2 == 'o' || c2 == 'O') &&
(c3 == 'r' || c3 == 'R') && (SqlTokenHelper.IsWhitespace(c4)) &&
(c5 == 'u' || c5 == 'U') && (c6 == 'p' || c6 == 'P') &&
(c7 == 'd' || c7 == 'D') && (c8 == 'a' || c8 == 'A') &&
(c9 == 't' || c9 == 'T') && (c10 == 'e' || c10 == 'E'))
{
_tokenType = SqlTokenType.FOR_UPDATE_WORD;
if (IsWordEnded())
{
return;
}
}
_charPosition = _charPosition - 1;
PeekNineChars(c, c2, c3, c4, c5, c6, c7, c8, c9);
}
private void ParseElseIfBlockComment()
{
if (!IsInIfBlockNode())
{
throw new SqlParseException(ExceptionMessageId.Esp2138, _sql, _tokenizer.LineNumber,
_tokenizer.Position);
}
RemoveNodesTo <IfBlockNode>();
var ifBlockNode = (IfBlockNode)Peek();
if (ifBlockNode.IsElseNodeExists)
{
throw new SqlParseException(ExceptionMessageId.Esp2139, _sql, _tokenizer.LineNumber,
_tokenizer.Position);
}
var expression = SqlTokenHelper.Extract(_tokenType, _token);
var node = new ElseifNode(Location, expression, _token);
ifBlockNode.AddElseifNode(node);
_nodeStack.Push(node);
}
private void PeekEightChars(char c, char c2, char c3, char c4, char c5,
char c6, char c7, char c8)
{
if ((c == 'g' || c == 'G') && (c2 == 'r' || c2 == 'R') &&
(c3 == 'o' || c3 == 'O') && (c4 == 'u' || c4 == 'U') &&
(c5 == 'p' || c5 == 'P') && (SqlTokenHelper.IsWhitespace(c6)) &&
(c7 == 'b' || c7 == 'B') && (c8 == 'y' || c8 == 'Y'))
{
_tokenType = SqlTokenType.GROUP_BY_WORD;
if (IsWordEnded())
{
return;
}
}
else if ((c == 'o' || c == 'O') && (c2 == 'r' || c2 == 'R') &&
(c3 == 'd' || c3 == 'D') && (c4 == 'e' || c4 == 'E') &&
(c5 == 'r' || c5 == 'R') && (char.IsWhiteSpace(c6)) &&
(c7 == 'b' || c7 == 'B') && (c8 == 'y' || c8 == 'Y'))
{
_tokenType = SqlTokenType.ORDER_BY_WORD;
if (IsWordEnded())
{
return;
}
}
else if ((c == 'o' || c == 'O') && (c2 == 'p' || c2 == 'P') &&
(c3 == 't' || c3 == 'T') && (c4 == 'i' || c4 == 'I') &&
(c5 == 'o' || c5 == 'O') && (c6 == 'n' || c6 == 'N') &&
(SqlTokenHelper.IsWhitespace(c7)) && (c8 == '('))
{
_tokenType = SqlTokenType.OPTION_WORD;
_charPosition = _charPosition - 2;
return;
}
_charPosition = _charPosition - 1;
PeekSevenChars(c, c2, c3, c4, c5, c6, c7);
}
private bool StartWithClauseKeyword(string fragment)
{
var reg = new Regex(ClauseKeywordPattern, RegexOptions.IgnoreCase);
return(reg.IsMatch(SqlTokenHelper.TrimWhitespace(fragment)));
}
private static bool IsExpressionIdentifierStart(char c)
{
return(SqlTokenHelper.IsIdentifierStartCharacter(c) || char.IsWhiteSpace(c) ||
c == '"' || c == '\'' || c == '@');
}
private void PeekOneChar(char c)
{
if (SqlTokenHelper.IsWhitespace(c))
{
_tokenType = SqlTokenType.WHITESPACE;
}
else if (c == '(')
{
_tokenType = SqlTokenType.OPENED_PARENS;
}
else if (c == ')')
{
_tokenType = SqlTokenType.CLOSED_PARENS;
}
else if (c == ';')
{
_tokenType = SqlTokenType.DELIMITER;
}
else if (c == '\'')
{
_tokenType = SqlTokenType.QUOTE;
var closed = false;
while (HasRemaining())
{
_charPosition++;
var c2 = _sql[_charPosition];
if (c2 == '\'')
{
if (_charPosition + 1 < _stringLength)
{
_charPosition++;
var c3 = _sql[_charPosition];
if (c3 != '\'')
{
_charPosition = _charPosition - 1;
closed = true;
break;
}
}
else
{
closed = true;
}
}
}
if (closed)
{
return;
}
CalcPosition();
throw new SqlParseException(ExceptionMessageId.Esp2101, _sql, LineNumber, Position);
}
else if (IsWordStarted(c))
{
_tokenType = SqlTokenType.WORD;
while (HasRemaining())
{
_charPosition++;
var c2 = _sql[_charPosition];
if (c2 == '\'')
{
var closed = false;
while (HasRemaining())
{
_charPosition++;
var c3 = _sql[_charPosition];
if (c3 == '\'')
{
if (_charPosition + 2 < _stringLength)
{
_charPosition++;
var c4 = _sql[_charPosition + 1];
if (c4 != '\'')
{
_charPosition = _charPosition - 1;
closed = true;
break;
}
}
else
{
closed = true;
}
}
}
if (closed)
{
return;
}
CalcPosition();
throw new SqlParseException(ExceptionMessageId.Esp2101, _sql, LineNumber, Position);
}
if (!SqlTokenHelper.IsWordPart(c2))
{
_charPosition = _charPosition - 1;
return;
}
}
}
else if (c == '\r' || c == '\n')
{
_tokenType = SqlTokenType.EOL;
_currentLineNumber++;
}
else
{
_tokenType = SqlTokenType.OTHER;
}
}
private ExpressionWrapper ReadParameter()
{
var parameter = "";
var doubleQuotationCount = 0;
while (true)
{
if (_current == '\0')
{
break;
}
if (char.IsLetterOrDigit(_current) || _current == '_' || _current == '"')
{
if (_current == '"')
{
doubleQuotationCount++;
}
parameter += _current;
if (IsCharBreak())
{
break;
}
NextChar();
}
else if (_current == '.' && SqlTokenHelper.IsIdentifierStartCharacter(parameter[0]))
{
NextChar();
if (_propertyValues.ContainsKey(parameter))
{
var instance = CreateParameterExpression(parameter);
var param = _propertyValues[parameter];
var paramType = param.Type;
var prop = ReadProperty(instance.Expression, paramType);
return(prop);
}
throw new ExpressionEvaluateException(ExceptionMessageId.EspA011, _expressionText, parameter);
}
else
{
break;
}
}
if (doubleQuotationCount == 1 || doubleQuotationCount > 2)
{
throw new ExpressionEvaluateException(ExceptionMessageId.EspA014, _expressionText, parameter);
}
if (char.IsDigit(parameter[0]))
{
return(CreateNumericExpression(parameter));
}
if (parameter == "null")
{
return(CreateNullExpression(parameter));
}
if (parameter == "true" || parameter == "false")
{
return(CreateBooleanExpression(parameter));
}
if (parameter == "\"\"")
{
return(CreateEmptyStringExpression(parameter));
}
if (_propertyValues.ContainsKey(parameter))
{
return(CreateParameterExpression(parameter));
}
if (Regex.IsMatch(parameter, @"\"".*\"""))
{
return(CreateLiteralStringExpression(parameter));
}
throw new ExpressionEvaluateException(ExceptionMessageId.EspA011, _expressionText, parameter);
}
