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_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 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_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 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); }