public void SqlQueryReturnsNoRows()
{
using (var domain = new SqlQueryCheckDomain(new SqlQueryCheckConfig
{
ConnectionString = "WolfpackR",
Query = "SELECT * FROM master.sys.databases WHERE 1=2"
}))
{
Feature.WithScenario("returns no rows should create a successful result")
.Given(domain.TheAgentIsStarted)
.When(domain.TheHealthCheckIsInvoked)
.Then(domain.ThereShouldBe_HealthCheckNotificationsReceived, 1)
.And(domain.TheNotificationRecievedAtIndex_ShouldHaveResult_, 1, true)
.ExecuteWithReport();
}
}
public void SqlQueryHappyPath()
{
using (var domain = new SqlQueryCheckDomain(new SqlQueryCheckConfig
{
ConnectionString = "WolfpackR",
Query = "SELECT * FROM master.sys.databases"
}))
{
Feature.WithScenario("returns some rows")
.Given(domain.TheAgentIsStarted)
.When(domain.TheHealthCheckIsInvoked)
.Then(domain.ThereShouldBe_HealthCheckNotificationsReceived, 1)
.And(domain.TheNotificationRecievedAtIndex_ShouldHaveResult_, 1, false)
.ExecuteWithReport();
}
}
