private void _savetoDb(CountryStats countryStats)
{
string sqlServer = Environment.GetEnvironmentVariable("MS_SQL_SERVER");
DataTable dt = new DataTable();
using (SqlConnection sqlConn = new SqlConnection($"Server={sqlServer};Database=CovidTracker;User Id=sa;Password=Passw@rd!;"))
{
string sql = "insert_country";
using (SqlCommand sqlCmd = new SqlCommand(sql, sqlConn))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@last_update", countryStats.LastUpdated);
sqlCmd.Parameters.AddWithValue("@country", countryStats.Country);
sqlCmd.Parameters.AddWithValue("@country_abbreviation", countryStats.CountryAbbreviation);
sqlCmd.Parameters.AddWithValue("@total_cases", countryStats.TotalCases);
sqlCmd.Parameters.AddWithValue("@new_cases", countryStats.NewCases);
sqlCmd.Parameters.AddWithValue("@total_deaths", countryStats.TotalDeaths);
sqlCmd.Parameters.AddWithValue("@new_deaths", countryStats.NewDeaths);
sqlCmd.Parameters.AddWithValue("@total_recovered", countryStats.TotalRecovered);
sqlCmd.Parameters.AddWithValue("@active_cases", countryStats.TotalCases);
sqlCmd.Parameters.AddWithValue("@serious_critical", countryStats.SeriousCritical);
sqlCmd.Parameters.AddWithValue("@cases_per_mill_pop", countryStats.CasesPerMillPop);
sqlConn.Open();
using (SqlDataAdapter sqlAdapter = new SqlDataAdapter(sqlCmd))
{
sqlAdapter.Fill(dt);
}
}
}
}
protected override async Task ExecuteAsync(CancellationToken stoppingToken)
{
string rabbitMQHost = Environment.GetEnvironmentVariable("RABBIT_MQ_HOST");
_logger.LogInformation($"RABBIT_MQ_HOST is set to {rabbitMQHost}");
//for RabbitMQ messaging queue
var factory = new ConnectionFactory()
{
HostName = rabbitMQHost
};
using (var connection = factory.CreateConnection())
using (var channel = connection.CreateModel())
{
channel.QueueDeclare(queue: "covid-19-stats",
durable: true,
exclusive: false,
autoDelete: false,
arguments: null);
channel.BasicQos(prefetchSize: 0, prefetchCount: 1, global: false);
var consumer = new EventingBasicConsumer(channel);
consumer.Received += (model, ea) =>
{
var body = ea.Body.ToArray();
var message = Encoding.UTF8.GetString(body);
_logger.LogInformation(message);
CountryStats countryStats = JsonConvert.DeserializeObject <CountryStats>(message);
_processCoutryStats(countryStats);
channel.BasicAck(deliveryTag: ea.DeliveryTag, multiple: false);
};
channel.BasicConsume(queue: "covid-19-stats",
autoAck: false,
consumer: consumer);
_logger.LogInformation("Queue subscribed");
while (!stoppingToken.IsCancellationRequested)
{
_logger.LogInformation("Worker Hearthbeat at: {time}", DateTimeOffset.Now);
await Task.Delay(1000 * 60, stoppingToken);
}
}
}
private void _processCoutryStats(CountryStats countryStats)
{
_savetoDb(countryStats);
}
