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