public void ShouldResolveExpression_06()
{
//Arrange
string expression = "p.BusinessEntityID NOT IN (SELECT BusinessEntityID FROM Sales.SalesPerson WHERE SalesQuota > 250000)";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpression_04()
{
//Arrange
string expression = "e.JobTitle IN ('Design Engineer', 'Tool Designer', 'Marketing Assistant')";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpression_05()
{
//Arrange
string expression = "(5 * 4 + 5 * (2.4 - 6)) = 6";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpressionWithExistsKeyword()
{
//Arrange
string expression = "NOT EXISTS (SELECT B.Cat_ID FROM Category_B B WHERE B.Cat_ID = A.Cat_ID)";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpression_11()
{
//Arrange
string expression = "[line_type] NOT IN ('Q') and NullIf(disputed_flag,'N') IS NULL";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpression_10()
{
//Arrange
string expression = "(obfuscatedTable.abc * obfuscatedTable.def) BETWEEN (obfuscatedTable.ghi) AND 5";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpression_09()
{
//Arrange
string expression = "(not ([some field] like 'TOP%' OR [some field] like 'LP %')) or ([some field] is Null)";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
public void ShouldResolveExpression_01()
{
//Arrange
string expression = "value IN (SELECT columnname FROM tablename2 WHERE condition = 1337)";
ReadOnlySpan <TSQLToken> tokens = TSQLTokenizer.ParseTokens(expression).ToArray();
int fileIndex = 0;
//Act
SearchConditionResolver.Resolve(tokens, ref fileIndex, new CompilerContext("xUnit", "irrelevant", "irrelevant", true));
//Assert
Assert.Equal(tokens.Length, fileIndex);
}
