public void UnHealthilyTest()
{
SqlServerHealthCheckOptions options = new SqlServerHealthCheckOptions();
options.ConnectionString = ConnectionString2;
options.Sql = "SELECT 1";
SqlServerHealthCheck healthCheck = new SqlServerHealthCheck(options);
var response = healthCheck.IsHealthily();
Assert.True(response.GetType() == typeof(UnHealthilyResponse));
}
protected override IJob Build()
{
var job = new PipelineJob(Logger, "SqlServerCheck");
job.RaiseJobExceptionEvent += Job_RaiseJobExceptionEvent;
var dbServerIP = IPAddress.Parse("127.0.0.1");
var policy = Policy.Handle <HttpRequestException>().WaitAndRetryAsync(new[]
{
TimeSpan.FromSeconds(1),
TimeSpan.FromSeconds(2),
TimeSpan.FromSeconds(3)
});
job.Use((_) =>
{
var sqlQueryCheck = new SqlServerHealthCheck <int>(new DbHealthCheckParams <int>(
connectionString: "Server=(localdb)\\mssqllocaldb;Database=WatusiHangfire;Trusted_Connection=True;"
, query: "SELECT 1"
, decideStatus: r => r == 1?HealthCheckStatus.Healthy:HealthCheckStatus.Unhealthy
, notify: (m, r) => Console.WriteLine(m)));
return(sqlQueryCheck.Beat());
}, policy)
.Use((_) =>
{
var telnetCheck = new TelnetHealthCheck(new TelnetHealthCheckParams(
ipAddress: dbServerIP
, dnsName: null
, port: 1433
, retryCount: 3
, notify: (m, r) => Console.WriteLine(m)));
return(telnetCheck.Beat());
}, policy);
return(job);
}
public AzureSqlHealthChecker(IConfiguration configuration)
{
_checker = new SqlServerHealthCheck(configuration["Settings:AzureSql"], "SELECT 1;");
}
