public void CaseExpression_Regression_Duplicated_Case()
{
List <TSQLStatement> statements = TSQLStatementReader.ParseStatements(
@"select case when abi = '03654' then 0 else 1 end as abi;",
includeWhitespace: false);
Assert.AreEqual(1, statements.Count);
List <TSQLToken> tokens = statements[0].Tokens;
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLKeyword(0, "select"),
new TSQLKeyword(7, "case"),
new TSQLKeyword(12, "when"),
new TSQLIdentifier(17, "abi"),
new TSQLOperator(21, "="),
new TSQLStringLiteral(23, "'03654'"),
new TSQLKeyword(31, "then"),
new TSQLNumericLiteral(36, "0"),
new TSQLKeyword(38, "else"),
new TSQLNumericLiteral(43, "1"),
new TSQLKeyword(45, "end"),
new TSQLKeyword(49, "as"),
new TSQLIdentifier(52, "abi")
},
tokens);
}
public void CaseExpression_Dont_Overrun()
{
List <TSQLStatement> statements = TSQLStatementReader.ParseStatements(
@"
BEGIN
SELECT CASE WHEN 1 = 2 THEN 0 ELSE 1 END
END"
// normalizing line endings to unix format to ensure passing
// tests in various environments
.Replace("\r", ""),
includeWhitespace: false);
Assert.AreEqual(3, statements.Count);
Assert.AreEqual(1, statements[0].Tokens.Count);
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLKeyword(18, "SELECT"),
new TSQLKeyword(25, "CASE"),
new TSQLKeyword(30, "WHEN"),
new TSQLNumericLiteral(35, "1"),
new TSQLOperator(37, "="),
new TSQLNumericLiteral(39, "2"),
new TSQLKeyword(41, "THEN"),
new TSQLNumericLiteral(46, "0"),
new TSQLKeyword(48, "ELSE"),
new TSQLNumericLiteral(53, "1"),
new TSQLKeyword(55, "END")
},
statements[1].Tokens);
Assert.AreEqual(1, statements[2].Tokens.Count);
Assert.IsTrue(statements[2].Tokens[0].IsKeyword(TSQLKeywords.END));
}
public void Parse_GO()
{
List <TSQLToken> tokens = TSQLTokenizer.ParseTokens("GO");
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLKeyword(0, "GO")
},
tokens);
}
public void Parse_uspSearchCandidateResumes_NoWhitespace()
{
using (StringReader reader = new StringReader(Resources.AdventureWorks2014_dbo_uspSearchCandidateResumes))
using (TSQLTokenizer lexer = new TSQLTokenizer(reader))
{
TokenComparisons.CompareStreamStartToList(
GetuspSearchCandidateResumesTokens()
.Where(t => !(t is TSQLWhitespace)).ToList(),
lexer);
}
}
public void Parse_GOFromStream()
{
using (TextReader reader = new StringReader("GO"))
using (TSQLTokenizer lexer = new TSQLTokenizer(reader))
{
TokenComparisons.CompareStreamToList(
new List <TSQLToken>()
{
new TSQLKeyword(0, "GO")
},
lexer);
}
}
public void Parse_uspSearchCandidateResumes()
{
using (StringReader reader = new StringReader(Resources.AdventureWorks2014_dbo_uspSearchCandidateResumes))
using (TSQLTokenizer lexer = new TSQLTokenizer(reader)
{
IncludeWhitespace = true
})
{
TokenComparisons.CompareStreamStartToList(
GetuspSearchCandidateResumesTokens(),
lexer);
}
}
public void Parse_uspSearchCandidateResumes_NoWhitespace()
{
using (StringReader reader = new StringReader(Resources.AdventureWorks2014_dbo_uspSearchCandidateResumes))
using (TSQLTokenizer lexer = new TSQLTokenizer(reader))
{
Assert.IsFalse(lexer.IncludeWhitespace);
Assert.IsFalse(lexer.UseQuotedIdentifiers);
TokenComparisons.CompareStreamStartToList(
GetuspSearchCandidateResumesTokens()
.Where(t => !(t is TSQLWhitespace)).ToList(),
lexer);
}
}
public void Parse_EmptyMoney()
{
List <TSQLToken> tokens = TSQLTokenizer.ParseTokens(
"$,",
includeWhitespace: false);
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLMoneyLiteral(0, "$"),
new TSQLCharacter(1, ",")
},
tokens);
}
public void Parse_OldStyleOuterJoins()
{
// .. WHERE tablea.id *= tableb.id
List <TSQLToken> tokens = TSQLTokenizer.ParseTokens(
"*= =*",
includeWhitespace: false);
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLOperator(0, "*="),
new TSQLOperator(3, "=*")
},
tokens);
}
public void Parse_SystemIdentifiers()
{
// $IDENTITY, $ROWGUID, $PARTITION
// https://msdn.microsoft.com/en-us/library/ms176104.aspx
// https://msdn.microsoft.com/en-us/library/ms188071.aspx
List <TSQLToken> tokens = TSQLTokenizer.ParseTokens(
"$IDENTITY $ROWGUID $PARTITION",
includeWhitespace: false);
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLIdentifier(0, "$IDENTITY"),
new TSQLIdentifier(10, "$ROWGUID"),
new TSQLIdentifier(19, "$PARTITION")
},
tokens);
}
public void ArgumentList_Simple()
{
TSQLTokenizer tokenizer = new TSQLTokenizer(
"dostuff( 1 , 2 )")
{
IncludeWhitespace = true
};
Assert.IsTrue(tokenizer.MoveNext());
Assert.AreEqual("dostuff", tokenizer.Current.Text);
Assert.IsTrue(tokenizer.MoveNext());
Assert.IsTrue(tokenizer.Current.IsCharacter(TSQLCharacters.OpenParentheses));
Assert.IsTrue(tokenizer.MoveNext());
TSQLArgumentList arguments = new TSQLArgumentListParser().Parse(tokenizer);
Assert.IsTrue(tokenizer.Current.IsCharacter(TSQLCharacters.CloseParentheses));
Assert.AreEqual(2, arguments.Count);
Assert.AreEqual(2, arguments[0].Tokens.Count);
Assert.AreEqual(TSQLExpressionType.Constant, arguments[0].Type);
Assert.AreEqual(TSQLTokenType.NumericLiteral, arguments[0].AsConstant.Literal.Type);
Assert.AreEqual(1, arguments[0].AsConstant.Literal.AsNumericLiteral.Value);
Assert.AreEqual(2, arguments[1].Tokens.Count);
Assert.AreEqual(TSQLExpressionType.Constant, arguments[1].Type);
Assert.AreEqual(TSQLTokenType.NumericLiteral, arguments[1].AsConstant.Literal.Type);
Assert.AreEqual(2, arguments[1].AsConstant.Literal.AsNumericLiteral.Value);
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLWhitespace(8, " "),
new TSQLNumericLiteral(9, "1"),
new TSQLWhitespace(10, " "),
new TSQLCharacter(11, ","),
new TSQLWhitespace(12, " "),
new TSQLNumericLiteral(13, "2"),
new TSQLWhitespace(14, " ")
},
arguments.Tokens);
}
public void OperatorExpression_Simple()
{
TSQLTokenizer tokenizer = new TSQLTokenizer(
"+ 2 - 3")
{
IncludeWhitespace = true
};
TSQLConstantExpression leftSide = new TSQLConstantExpression()
{
Literal = new TSQLNumericLiteral(
0,
"1")
};
leftSide.Tokens.Add(leftSide.Literal);
Assert.IsTrue(tokenizer.MoveNext());
TSQLOperatorExpression op = new TSQLOperatorExpressionParser().Parse(
tokenizer,
leftSide);
Assert.AreSame(leftSide, op.LeftSide);
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
// bogus begin position because we made it up
new TSQLNumericLiteral(0, "1"),
new TSQLOperator(0, "+"),
new TSQLWhitespace(1, " "),
new TSQLNumericLiteral(2, "2"),
new TSQLWhitespace(3, " "),
new TSQLOperator(4, "-"),
new TSQLWhitespace(5, " "),
new TSQLNumericLiteral(6, "3")
},
op.Tokens);
Assert.AreEqual("+", op.Operator.Text);
Assert.AreEqual(TSQLExpressionType.Operator, op.RightSide.Type);
TSQLOperatorExpression rightSide = op.RightSide.AsOperator;
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLNumericLiteral(2, "2"),
new TSQLWhitespace(3, " "),
new TSQLOperator(4, "-"),
new TSQLWhitespace(5, " "),
new TSQLNumericLiteral(6, "3")
},
rightSide.Tokens);
Assert.AreEqual("-", rightSide.Operator.Text);
Assert.AreEqual(TSQLExpressionType.Constant, rightSide.LeftSide.Type);
TSQLConstantExpression leftNumber = rightSide.LeftSide.AsConstant;
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLNumericLiteral(2, "2"),
new TSQLWhitespace(3, " ")
},
leftNumber.Tokens);
Assert.AreEqual(TSQLTokenType.NumericLiteral, leftNumber.Literal.Type);
Assert.AreEqual(2, leftNumber.Literal.AsNumericLiteral.Value);
Assert.AreEqual(TSQLExpressionType.Constant, rightSide.RightSide.Type);
TSQLConstantExpression rightNumber = rightSide.RightSide.AsConstant;
TokenComparisons.CompareTokenLists(
new List <TSQLToken>()
{
new TSQLNumericLiteral(6, "3")
},
rightNumber.Tokens);
Assert.AreEqual(TSQLTokenType.NumericLiteral, rightNumber.Literal.Type);
Assert.AreEqual(3, rightNumber.Literal.AsNumericLiteral.Value);
}