public async Task AddUser_ValidData_UserAdded()
{
var expectedData = new DataSetRow
{
["FirstName"] = "Jamie",
["LastName"] = Comparisons.NotMatchesRegex(".*@.*"),
["EmailAddress"] = Comparisons.MatchesRegex(".*@.*"),
["CreatedDate"] = Comparisons.IsUtcNow(),
["StartDate"] = Comparisons.IsDay("01-Mar-2020 00:10:00"),
["IsActive"] = true,
["NumberOfHats"] = 14L,
["HatType"] = null,
["Cost"] = 15.87m
};
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));
await TestRunner.ExecuteStoredProcedureNonQueryAsync("dbo.AddUser",
new SqlQueryParameter("FirstName", "AAA"),
new SqlQueryParameter("LastName", "FFF"),
new SqlQueryParameter("EmailAddress", "*****@*****.**"),
new SqlQueryParameter("StartDate", DateTime.Parse("01-Jan-2020")),
new SqlQueryParameter("NumberOfHats", 3),
new SqlQueryParameter("Cost", 34));
QueryResult data = await TestRunner.ExecuteTableAsync("dbo.Users");
data.AssertRowCount(2);
data.AssertColumnsExist("FirstName", "LastName", "EmailAddress", "CreatedDate");
data.AssertColumnsNotExist("Age", "JobTitle");
data.AssertValue(0, "FirstName", "Jamie");
data
.ValidateRow(0)
.AssertValues(expectedData);
data
.AssertRowValues(0, expectedData);
data
.ValidateRow(0)
.AssertValue("FirstName", "Jamie");
data
.ValidateRow(0)
.AssertValue("FirstName", Comparisons.HasLength(5));
data
.AssertRowValues(0, new DataSetRow
{
{ "FirstName", "Jamie" },
{ "LastName", "Burns" }
})
.AssertRowValues(1, new DataSetRow
{
{ "FirstName", "AAA" },
{ "LastName", "FFF" }
});
data
.AssertRowExists(new DataSetRow
{
{ "FirstName", "Jamie" },
{ "LastName", "Burns" }
});
data
.AssertRowDoesNotExist(new DataSetRow
{
{ "FirstName", "Jeff" },
{ "LastName", "Burns" }
});
}