public void Insert(MqttRequest mqttRequest)
{
string sql = @"INSERT
INTO ta_pegando_fogo.Medicao
(DispositivoId,
Temperatura,
Fumaca,
Gas,
UmidadeAr,
DataAtualizacao,
Risco)
VALUES
(@DispositivoId,
@Temperatura,
@Fumaca,
@Gas,
@Umidade,
@DataAtualizacao,
@Risco)";
var param = new DynamicParameters();
param.Add("@Temperatura", mqttRequest.measurement.Temperature, DbType.Double);
param.Add("@Fumaca", mqttRequest.measurement.Smoke, DbType.Double);
param.Add("@Gas", mqttRequest.measurement.Gas, DbType.Double);
param.Add("@Umidade", mqttRequest.measurement.AirHumidity, DbType.Double);
param.Add("@DataAtualizacao", DateTime.UtcNow, DbType.DateTime);
param.Add("@Risco", 0, DbType.Double);
param.Add("@DispositivoId", mqttRequest.measurement.IdDispositivo, DbType.Int32);
using var connection = _helper.GetConnection();
connection.Execute(sql, param);
}
public void Execute(MqttRequest request)
{
if (request == null)
{
return;
}
_measurementRepository.Insert(request);
}
