/// <inheritdoc />
public IConditionBuilder WithCondition(string leftConditionTable, string leftConditionColumn, EqualityOperators equalityOperator, string rightConditionTable, string rightConditionColumn)
{
var columnConditionModel = new ColumnConditionModel(leftConditionTable, leftConditionColumn, equalityOperator, rightConditionTable, rightConditionColumn);
_buildConditions.Add(_conditionNumber++, columnConditionModel);
return(this);
}
public void Constructor()
{
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var selectColumn = new ColumnConditionModel("SourceTable", "SourceColumn", EqualityOperators.Equals, "CompareTable", "CompareColumn");
//---------------Test Result -----------------------
Assert.IsNotNull(selectColumn);
}
public void ToString_GivenConditionValues_ShouldReturnExpectedStatement(string sourceTable, string sourceColumn,
EqualityOperators equalityOperator,
string compareTable, string compareColumn, string expectedStatement)
{
//---------------Set up test pack-------------------
var conditionColumn = new ColumnConditionModel(sourceTable, sourceColumn, equalityOperator, compareTable, compareColumn)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var selectStatement = conditionColumn.ToString();
//---------------Test Result -----------------------
Assert.AreEqual(expectedStatement, selectStatement);
}
public void Equals_GivenDifferentConditionData_ShouldReturnTrue(string sourceTable, string sourceColumn,
EqualityOperators equalityOperator,
string compareTable, string compareColumn)
{
//---------------Set up test pack-------------------
var conditionModel = new ColumnConditionModel(sourceTable, sourceColumn, equalityOperator, compareTable, compareColumn)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compareCondition = new ColumnConditionModel("unknownTable", "illegalColumn", EqualityOperators.StartsWith, "UnknownCompareTable", "UnknownCompareColumn")
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var equalResult = conditionModel.Equals(compareCondition);
//---------------Test Result -----------------------
Assert.IsFalse(equalResult);
}
public void Equals_GivenSameConditionData_ShouldReturnTrue(string sourceTable, string sourceColumn,
EqualityOperators equalityOperator,
string compareTable, string compareColumn)
{
//---------------Set up test pack-------------------
var conditionModel = new ColumnConditionModel(sourceTable, sourceColumn, equalityOperator, compareTable, compareColumn)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compareCondition = new ColumnConditionModel(sourceTable, sourceColumn, equalityOperator, compareTable, compareColumn)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var equalResult = conditionModel.Equals(compareCondition);
//---------------Test Result -----------------------
Assert.IsTrue(equalResult);
}