public void UpdateKafkaLastReceived(TestLastReceived args)
{
using (var conn = new MySqlConnection(_connectionString))
{
conn.Open();
var cmd = conn.CreateCommand();
cmd.CommandText = @"
INSERT IGNORE INTO kafka_results_v2 (Guid, SendAt, LastReceivedAt, MessageCount, MessageByteSize, Topic)
VALUES (?guid, null, FROM_UNIXTIME(?lastReceivedAt * 0.001), null, null, null)
ON DUPLICATE KEY UPDATE
LastReceivedAt = FROM_UNIXTIME(?lastReceivedAt * 0.001);";
cmd.Parameters.AddWithValue("?lastReceivedAt", args.LastReceivedAt);
cmd.Parameters.AddWithValue("?guid", args.Guid);
cmd.ExecuteNonQuery();
}
}
public ServiceResponse UpdateKafkaResult(TestLastReceived args)
{
try
{
_logger.LogInformation($"UpdateKafkaResult : args.Guid={args.Guid}, args.LastReceivedAt={args.LastReceivedAt}");
_repository.UpdateKafkaLastReceived(args);
return(new ServiceResponse()
{
Success = true, Message = "Kafka result updated"
});
}
catch (Exception ex)
{
_logger.LogError($"UpdateKafkaResult : {ex.Message} \n {ex.InnerException}");
return(new ServiceResponse()
{
Success = false, Message = ex.Message
});
}
}
public ServiceResponse UpdateKafkaLastReceived(TestLastReceived args)
{
return(_service.UpdateKafkaResult(args));
}
