public void Equals_GivenConditionValues_ShouldReturnTrue(string leftConditionTableName, string leftConditionColumnName, EqualityOperators leftConditionOperator, object leftConditionValue,
BooleanOperator booleanOperator,
string rightConditionTableName, string rightConditionColumnName, EqualityOperators rightConditionOperator, object rightConditionValue)
{
//---------------Set up test pack-------------------
var leftCondition = new ConditionModel(leftConditionTableName, leftConditionColumnName, leftConditionOperator, leftConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var rightCondition = new ConditionModel(rightConditionTableName, rightConditionColumnName, rightConditionOperator, rightConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var conditionModel = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compareCondition = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var equalResult = conditionModel.Equals(compareCondition);
//---------------Test Result -----------------------
Assert.IsTrue(equalResult);
}
public void ToString_GivenConditionValues_ShouldReturnExpectedStatement(string leftConditionTableName, string leftConditionColumnName, EqualityOperators leftConditionOperator, object leftConditionValue,
BooleanOperator booleanOperator,
string rightConditionTableName, string rightConditionColumnName, EqualityOperators rightConditionOperator, object rightConditionValue,
string expectedStatement)
{
//---------------Set up test pack-------------------
var leftCondition = new ConditionModel(leftConditionTableName, leftConditionColumnName, leftConditionOperator, leftConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var rightCondition = new ConditionModel(rightConditionTableName, rightConditionColumnName, rightConditionOperator, rightConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compoundCondition = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var selectStatement = compoundCondition.ToString();
//---------------Test Result -----------------------
Assert.AreEqual(expectedStatement, selectStatement);
}
public void Constructor()
{
//---------------Set up test pack-------------------
var leftCondition = Substitute.For <IConditionModel>();
var rightCondition = Substitute.For <IConditionModel>();
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var model = new CompoundConditionModel(leftCondition, BooleanOperator.And, rightCondition);
//---------------Test Result -----------------------
Assert.IsNotNull(model);
}
public void GetHashCode_ShouldReturnStringHashCode()
{
//---------------Set up test pack-------------------
var leftCondition = new ConditionModel("Table1", "DifferentColumn1", EqualityOperators.GreaterThan, "Unknown1")
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var rightCondition = new ConditionModel("Table2", "DifferentColumn2", EqualityOperators.LessThan, "Unknown2")
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var condition = new CompoundConditionModel(leftCondition, BooleanOperator.And, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var hashCode = 0;
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
Assert.DoesNotThrow(() => hashCode = condition.GetHashCode());
//---------------Test Result -----------------------
Assert.IsNotNull(hashCode);
}
public void Equals_GivenDifferentConditionValues_ShouldReturnFalse(string leftConditionTableName, string leftConditionColumnName, EqualityOperators leftConditionOperator, object leftConditionValue,
BooleanOperator booleanOperator,
string rightConditionTableName, string rightConditionColumnName, EqualityOperators rightConditionOperator, object rightConditionValue)
{
//---------------Set up test pack-------------------
var leftCondition = new ConditionModel(leftConditionTableName, leftConditionColumnName, leftConditionOperator, leftConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var rightCondition = new ConditionModel(rightConditionTableName, rightConditionColumnName, rightConditionOperator, rightConditionValue)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var conditionModel = new CompoundConditionModel(leftCondition, booleanOperator, rightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var differentLeftCondition = new ConditionModel("", "DifferentColumn1", EqualityOperators.GreaterThan, "Unknown1")
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var differentRightCondition = new ConditionModel("", "DifferentColumn2", EqualityOperators.LessThan, "Unknown2")
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
var compareCondition = new CompoundConditionModel(differentLeftCondition, BooleanOperator.Or, differentRightCondition)
{
DatabaseProvider = new SqlServerDatabaseProvider()
};
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var equalResult = conditionModel.Equals(compareCondition);
//---------------Test Result -----------------------
Assert.IsFalse(equalResult);
}
