private async void InsertValues(
object state)
{
if (_running)
{
_logger.LogInformation(4444, $"Job is already running");
return;
}
_running = true;
var lastTimestamp = _repository.LastTimestamp();
var currentTimestamp = lastTimestamp.AddMinutes(1);
while (currentTimestamp < DateTime.Now.CutSeconds())
{
_ = _repository.AddTimestamp(currentTimestamp.CutSeconds());
currentTimestamp = currentTimestamp.AddMinutes(1);
}
_ = await _repository.SaveChangesAsync();
var targets = new List <MeasureValue>();
var delete = new List <MqttMessage>();
// Filter relevant messages
var messages =
await _repository
.GetMessagesAsQueryable()
.Where(msg => !msg.Topic.EndsWith("neo7m"))
.OrderBy(msg => msg.Created)
.ToListAsync();
foreach (var message in messages)
{
if (!double.TryParse(message.Message, out var v))
{
delete.Add(message);
continue;
}
var fields = message.Topic.Split('/');
if (fields.Length != 4)
{
delete.Add(message);
continue;
}
var tmpTimestamp = message.Created.CutSeconds();
var timestamp = _repository.GetTimestamp(tmpTimestamp);
if (timestamp == null)
{
_logger.LogInformation($"Timestamp {tmpTimestamp.ToString()} not exist");
continue;
}
var room = _repository.GetRoom(fields[1]);
var measureType = _repository.GetMeasureType(fields[2]);
var sensorType = _repository.GetSensorType(fields[3]);
if (room == null && measureType == null && sensorType == null)
{
_logger.LogError(6666, $"Error with types");
continue;
}
var value = new MeasureValue
{
MeasureTimeTimestamp = timestamp.Timestamp,
SensorTypeName = sensorType.Name,
RoomName = room?.Name,
MeasureTypeName = measureType?.Name,
Value = v
};
if (targets.FirstOrDefault(
msg =>
msg.RoomName == value.RoomName &&
msg.SensorTypeName == value.SensorTypeName &&
msg.MeasureTypeName == value.MeasureTypeName &&
msg.MeasureTimeTimestamp == value.MeasureTimeTimestamp) != null)
{
_logger.LogError(4444, $"Value are duplicate in MqttMessages");
delete.Add(message);
continue;
}
targets.Add(value);
delete.Add(message);
}
foreach (var target in targets)
{
if (!_repository.MeasureExists(
target.RoomName,
target.MeasureTypeName,
target.SensorTypeName,
target.MeasureTimeTimestamp))
{
_repository.AddMeasureValue(target);
}
}
foreach (var dMessage in delete)
{
_repository.DeleteMessage(dMessage);
}
_ = await _repository.SaveChangesAsync();
_running = false;
}