public void Having_ConditionParam()
{
const string expected = "Having (F1 = 5 And F2 > 'a')";
var conditionGenerator = new ConditionGenerator();
var condition = conditionGenerator.Add("F1", FieldDataType.Numeric, RelationalOperators.Equal, 5)
.Add("F2", FieldDataType.Text, RelationalOperators.GreaterThan, "a");
Generator.HavingCondition(condition);
Assert.AreEqual(expected, Generator.ToString());
}
public void Where_WithFourConditionsCombinedWithOrAndAnd2_ToString()
{
const string expected = "Where ((F1 = 123 Or F2 = 456) And (F1 = 789 Or F2 = 98))";
var conditionGenerator = new ConditionGenerator();
conditionGenerator.BeginGroup(new Field("F1"), RelationalOperators.Equal, 123)
.Add(new Field("F2"), FieldDataType.Numeric, RelationalOperators.Equal, 456)
.ConcatOperator = LogicalOperator.Or;
conditionGenerator.BeginGroup(new Field("F1"), RelationalOperators.Equal, 789)
.Add(new Field("F2"), FieldDataType.Numeric, RelationalOperators.Equal, 98)
.ConcatOperator = LogicalOperator.Or;
var actual = Generator.Where(conditionGenerator).ToString();
Assert.AreEqual(expected, actual);
}
public void Where_WithFourConditionsCombinedWithOrAndAnd1_CheckString()
{
const string expected = "Where (((F1 = 123) And (F2 = 456)) Or ((F1 = 789) And (F2 = 98)))";
var conditionGenerator = new ConditionGenerator {
ConcatOperator = LogicalOperator.Or
};
conditionGenerator.BeginGroup(new Field("F1"), RelationalOperators.Equal, 123)
.Add(new Field("F2"), RelationalOperators.Equal, 456)
.ConcatOperator = LogicalOperator.And;
conditionGenerator.BeginGroup(new Field("F1"), RelationalOperators.Equal, 789)
.Add(new Field("F2"), RelationalOperators.Equal, 98)
.ConcatOperator = LogicalOperator.And;
var actual = _sqlGenerator.Where(conditionGenerator).ToString();
Assert.AreEqual(expected, actual);
}
public void TestInitialize()
{
_generator = new ConditionGenerator();
_generator.InjectDependency(_conditionalOperatorGenerator = new ConditionalOperatorGeneratorStub());
_generator.InjectDependency(_statementGenerator = new StatementGeneratorStub());
}
