public void ScalarResult_AssertValue_ValueMatches_NoError()
{
ScalarResult <int> result = new ScalarResult <int>(_testFramework, 1001);
Assert.DoesNotThrow(() =>
result.AssertValue(1001));
}
public void ScalarResult_AssertValue_ValueDoesNotMatchExpectedIsNull_Error()
{
ScalarResult <int> result = new ScalarResult <int>(_testFramework, 1001);
var exception = Assert.Throws <Microsoft.VisualStudio.TestTools.UnitTesting.AssertFailedException>(() =>
result.AssertValue(null));
Assert.AreEqual("Assert.AreEqual failed. Expected:< (System.DBNull)>. Actual:<1001 (System.Int32)>. Scalar result has an unexpected value", exception.Message);
}
public async Task CountUsers_MatchEmailAddress_Return1_UseDefaultDataTemplateSetupIdentity()
{
await TestRunner.InsertTemplateAsync <UserTemplate>();
ScalarResult <int> result = await TestRunner.ExecuteStoredProcedureScalarAsync <int>("dbo.CountUsers", new DataSetRow
{
{ "EmailAddress", "*****@*****.**" }
});
result
.AssertValue(1);
}
public async Task CountUsers_NoMatchEmailAddress_Return1_ByCommand()
{
await TestRunner.ExecuteStoredProcedureNonQueryAsync("dbo.AddUser",
new SqlQueryParameter("FirstName", "Jamie"),
new SqlQueryParameter("LastName", "Burns"),
new SqlQueryParameter("EmailAddress", "*****@*****.**"),
new SqlQueryParameter("StartDate", DateTime.Parse("01-Mar-2020")),
new SqlQueryParameter("NumberOfHats", 14),
new SqlQueryParameter("Cost", 15.87));
ScalarResult <int> result = await TestRunner.ExecuteCommandScalarAsync <int>("EXEC dbo.CountUsers @EmailAddress", new SqlQueryParameter("EmailAddress", "*****@*****.**"));
result
.AssertValue(1);
}
public async Task CountUsers_MatchEmailAddress_Return1_UseDataSetupIdentity()
{
await TestRunner.InsertDataAsync("dbo.Users", new DataSetRow
{
{ "FirstName", "Jamie" },
{ "LastName", "Burns" },
{ "EmailAddress", "*****@*****.**" },
{ "StartDate", DateTime.Parse("01-Mar-2020") },
{ "NumberOfHats", 14 },
{ "Cost", 15.87 },
{ "CreatedDate", DateTime.Parse("01-Feb-2020") },
});
ScalarResult <int> result = await TestRunner.ExecuteStoredProcedureScalarAsync <int>("dbo.CountUsers", new SqlQueryParameter("EmailAddress", "*****@*****.**"));
result
.AssertValue(1);
}
public void ScalarResult_Ctor_ValueSet()
{
ScalarResult <int> result = new ScalarResult <int>(_testFramework, 1001);
Assert.AreEqual(1001, result.RawData);
}
