public void BuildBooleanQuery_OneValidInput_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("+foo");
// Assert
Assert.AreEqual("(({{COLUMN}} LIKE '%' + @field1 + '%'))", parameterizedSql.Sql);
}
public void BuildPhraseQuery_OneValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("\"abc def\"");
// Assert
Assert.AreEqual("ABC DEF", parameterizedSql.UserInputVariables["field1"]);
}
public void BuildWildcardPhraseQuery_ValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("\"Ab?Cd* dog\"");
// Assert
Assert.AreEqual("AB_CD% DOG", parameterizedSql.UserInputVariables["field1"]);
}
public void BuildWildcardPhraseQuery_ValidInput_ValidNumParameters()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("\"Ab?Cd* dog\"");
// Assert
Assert.AreEqual(1, parameterizedSql.UserInputVariables.Count);
}
public void BuildBooleanQuery_OneValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("+foo");
// Assert
Assert.AreEqual("FOO", parameterizedSql.UserInputVariables["field1"]);
}
public void BuildPrefixQuery_ValidInput_ValidNumParameters()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("abc*");
// Assert
Assert.AreEqual(1, parameterizedSql.UserInputVariables.Count);
}
public void BuildTermRangeQuery_ValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("{a TO B}");
// Assert
Assert.AreEqual(null, parameterizedSql);
}
public void BuildBooleanQuery_OneValidInput_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("+foo");
// Assert
Assert.AreEqual("(({{COLUMN}} LIKE '%' + @field1 + '%'))", parameterizedSql.Sql);
}
public void BuildBooleanQuery_TwoValidInputs_ValidNumParameters()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("foo AND bar");
// Assert
Assert.AreEqual(2, parameterizedSql.UserInputVariables.Count);
}
public void BuildPrefixQuery_ValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("abc*");
// Assert
Assert.AreEqual("ABC%", parameterizedSql.UserInputVariables["field1"]);
}
public void BuildBooleanQuery_OneValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("+foo");
// Assert
Assert.AreEqual("FOO", parameterizedSql.UserInputVariables["field1"]);
}
public void BuildWildcardPhraseQuery_ValidInput_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("\"Ab?Cd* dog\"");
// Assert
Assert.AreEqual("{{COLUMN}} LIKE '%' + @field1 + '%'", parameterizedSql.Sql);
}
public void BuildPrefixQuery_ValidInput_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("abc*");
// Assert
Assert.AreEqual("{{COLUMN}} LIKE '%' + @field1 + '%'", parameterizedSql.Sql);
}
public void BuildBooleanQuery_TwoValidInputs_ValidNumParameters()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("foo AND bar");
// Assert
Assert.AreEqual(2, parameterizedSql.UserInputVariables.Count);
}
public void BuildBooleanQuery_TwoValidInputs_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
var sqlOutput = "(({{COLUMN}} LIKE '%' + @field1 + '%') AND ({{COLUMN}} LIKE '%' + @field2 + '%'))";
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("foo AND bar");
// Assert
Assert.AreEqual(sqlOutput, parameterizedSql.Sql);
}
public void BuildQuery_SqlWildcardInput_EscapedOutput()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
var luceneQuery = "\"5% of coders \\{\\{FOO\\}\\} are cod\\[ing\\] all_night_long\"";
var sqlOutput = "5[%] OF CODERS [{][{]FOO}} ARE COD[[]ING] ALL[_]NIGHT[_]LONG";
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause(luceneQuery);
// Assert
Assert.AreEqual(sqlOutput, parameterizedSql.UserInputVariables["field1"]);
}
public void BuildBooleanQuery_TwoValidInputs_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
var sqlOutput = "(({{COLUMN}} LIKE '%' + @field1 + '%') AND ({{COLUMN}} LIKE '%' + @field2 + '%'))";
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("foo AND bar");
// Assert
Assert.AreEqual(sqlOutput, parameterizedSql.Sql);
}
public void BuildWildcardQuery_ValidInput_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("Ab?Cd*");
// Assert
Assert.AreEqual("{{COLUMN}} LIKE '%' + @field1 + '%'", parameterizedSql.Sql);
}
public void BuildWildcardQuery_ValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("Ab?Cd*");
// Assert
Assert.AreEqual("AB_CD%", parameterizedSql.UserInputVariables["field1"]);
}
public void BuildWildcardQuery_ValidInput_ValidNumParameters()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("Ab?Cd*");
// Assert
Assert.AreEqual(1, parameterizedSql.UserInputVariables.Count);
}
public void BuildTermRangeQuery_ValidInput_ValidSql()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("{a TO B}");
// Assert
Assert.AreEqual(null, parameterizedSql);
}
public void BuildQuery_SqlWildcardInput_EscapedOutput()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
var luceneQuery = "\"5% of coders \\{\\{FOO\\}\\} are cod\\[ing\\] all_night_long\"";
var sqlOutput = "5[%] OF CODERS [{][{]FOO}} ARE COD[[]ING] ALL[_]NIGHT[_]LONG";
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause(luceneQuery);
// Assert
Assert.AreEqual(sqlOutput, parameterizedSql.UserInputVariables["field1"]);
}
public void BuildPhraseQuery_OneValidInput_ValidParameter()
{
// Arrange
var sqlQueryBuilder = new SqlServerQueryBuilder();
// Act
var parameterizedSql = sqlQueryBuilder.BuildSqlWhereClause("\"abc def\"");
// Assert
Assert.AreEqual("ABC DEF", parameterizedSql.UserInputVariables["field1"]);
}
