public void Matches_AnyIDbCommandAsActualAndAnyPathAsExpectation_EngineCompareTheTwoResultSetsPreviouslyCreated()
{
var rsActual = new ResultSetCsvReader().Parse("a;b;c");
var rsExpect = new ResultSetCsvReader().Parse("x;y;z");
var cmd = new SqlCommand();
var rsbStub = new Mock <IResultSetBuilder>();
rsbStub.Setup(engine => engine.Build(It.IsAny <IDbCommand>()))
.Returns(rsActual);
rsbStub.Setup(engine => engine.Build(It.IsAny <string>()))
.Returns(rsExpect);
var rsbFake = rsbStub.Object;
var rscMock = new Mock <IResultSetComparer>();
rscMock.Setup(engine => engine.Compare(rsActual, rsExpect))
.Returns(ResultSetCompareResult.NotMatching);
var rsc = rscMock.Object;
var equalToConstraint = new EqualToConstraint("my path for expectation")
{
ResultSetBuilder = rsbFake, Engine = rsc
};
//Method under test
equalToConstraint.Matches(cmd);
//Test conclusion
//Test conclusion
rscMock.Verify(engine => engine.Compare(rsActual, rsExpect), Times.Once());
}
public void Matches_TwoDifferentResultSets_ReturnFalse()
{
var rsActual = new ResultSetCsvReader().Parse("a;b;1");
var rsExpect = new ResultSetCsvReader().Parse("a;X;1");
var cmd = new SqlCommand();
var rsbMock = new Mock <IResultSetBuilder>();
rsbMock.Setup(engine => engine.Build(It.IsAny <IDbCommand>()))
.Returns(rsActual);
rsbMock.Setup(engine => engine.Build(rsExpect))
.Returns(rsExpect);
var rsb = rsbMock.Object;
var equalToConstraint = new EqualToConstraint(rsExpect)
{
ResultSetBuilder = rsb
};
//Method under test
var res = equalToConstraint.Matches(cmd);
//Test conclusion
rsbMock.Verify(engine => engine.Build(rsExpect), Times.Once());
Assert.That(res, Is.False);
}
public void Matches_IDbCommandAsActualAndPathAsExpectation_ResulSetBuildersCreateResultSetsUsingActualAndExpectationProvided()
{
var rsActual = new ResultSetCsvReader().Parse("a;b;1");
var rsExpect = new ResultSetCsvReader().Parse("x;y;2");
var cmd = new SqlCommand();
var rsbMock = new Mock <IResultSetBuilder>();
rsbMock.Setup(engine => engine.Build(cmd))
.Returns(rsActual);
rsbMock.Setup(engine => engine.Build("my path for expectation"))
.Returns(rsExpect);
var rsb = rsbMock.Object;
var equalToConstraint = new EqualToConstraint("my path for expectation")
{
ResultSetBuilder = rsb
};
//Method under test
equalToConstraint.Matches(cmd);
//Test conclusion
//Test conclusion
rsbMock.Verify(engine => engine.Build(cmd), Times.Once());
rsbMock.Verify(engine => engine.Build("my path for expectation"), Times.Once());
}
public void Matches_AnyResultSets_EngineCalledOnceResultSetBuilderTwice()
{
var rs = new ResultSetCsvReader().Parse("a;b;c");
var cmd = new SqlCommand();
var rsbMock = new Mock <ResultSetBuilder>();
rsbMock.Setup(engine => engine.Build(It.IsAny <object>()))
.Returns(rs);
var rsb = rsbMock.Object;
var rscMock = new Mock <IResultSetComparer>();
rscMock.Setup(engine => engine.Compare(It.IsAny <ResultSet>(), It.IsAny <ResultSet>()))
.Returns(new ResultSetCompareResult()
{
Difference = ResultSetDifferenceType.None
});
var rsc = rscMock.Object;
var equalToConstraint = new EqualToConstraint(rs)
{
Engine = rsc, ResultSetBuilder = rsb
};
equalToConstraint.ResultSetBuilder = rsb;
//Method under test
equalToConstraint.Matches(cmd);
//Test conclusion
//Test conclusion
rscMock.Verify(engine => engine.Compare(It.IsAny <ResultSet>(), It.IsAny <ResultSet>()), Times.Once());
rsbMock.Verify(engine => engine.Build(It.IsAny <object>()), Times.Exactly(2));
}
public void Parse_ValidRaw_SplitCorrectly()
{
//Buiding object used during test
var reader = new ResultSetCsvReader();
string csv = "\"A\";\"B\";\"10\";\r\n\"C\";\"D\";\"11\";\r\n";
//Call the method to test
var rs = reader.Parse(csv);
//Assertion
Assert.That(rs.Columns.Count, Is.EqualTo(3));
Assert.That(rs.Rows.Count, Is.EqualTo(2));
Assert.That(rs.Rows[0].ItemArray[0], Is.EqualTo((object)"A"));
Assert.That(rs.Rows[0].ItemArray[1], Is.EqualTo((object)"B"));
Assert.That(rs.Rows[0].ItemArray[2], Is.EqualTo((object)"10"));
Assert.That(rs.Rows[1].ItemArray[0], Is.EqualTo((object)"C"));
Assert.That(rs.Rows[1].ItemArray[1], Is.EqualTo((object)"D"));
Assert.That(rs.Rows[1].ItemArray[2], Is.EqualTo((object)"11"));
}