Hello. I have strange issue with Arduino 2.3.2 on my PCs. So I have this code that I was developing on multiple PCs and MAC also depending where I was (work, home). And one day on all my PC i started getting error exit 1 status. Same code on MAC compile just fine. After months of searching what the issue can be I try to drill issue down and I found that it depends on how manny times I call some code in function. So I have code that send data to MySQL. Code is parsed on values that it sends. I found that I can send 55 of those values one after other and not get error. When add 56st value I get exit 1 status error. Only on PC..... how can I fix this please? ..... I think code is good as I can put any of 178 values into list of 55 and it compiles and work. Down attaching the code. Please help!
void postRunningDataSQL() {
String INSERT_SQL;
if (Debug) Serial.println("Connecting to MySQL...");
if (Debug) Serial.println();
if (conn.connectNonBlocking(server, server_port, user, password, database) != RESULT_FAIL) {
delay(500);
// Initiate the query class instance
MySQL_Query query_mem = MySQL_Query(&conn);
if (conn.connected()) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HeartBeat','" + HeartBeat + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
}
if (SSID != WiFi.SSID()) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SSID','" + String(WiFi.SSID()) + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SSID = WiFi.SSID();
Serial.println(SSID);
}
}
if (RSSI != WiFi.RSSI()) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RSSI','" + WiFi.RSSI() + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RSSI = WiFi.RSSI();
}
}
if (FreeHeap != ESP.getFreeHeap(), DEC) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','FreeHeap','" + FreeHeap + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
FreeHeap = ESP.getFreeHeap(), DEC;
}
}
if (ver != verSend) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ver','" + ver + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
verSend = ver;
}
}
if (connHealth != connHealthSend) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','connHealth','" + connHealth + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
connHealthSend = connHealth;
}
}
if (HeatPumpOnOffZone2 != HeatPumpOnOffZone2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HeatPumpOnOffZone2','" + HeatPumpOnOffZone2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HeatPumpOnOffZone2_local = HeatPumpOnOffZone2;
}
}
if (DhwOnOff != DhwOnOff_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DhwOnOff','" + DhwOnOff + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DhwOnOff_local = DhwOnOff;
}
}
if (HeatPumpOnOffZone1 != HeatPumpOnOffZone1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HeatPumpOnOffZone1','" + HeatPumpOnOffZone1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HeatPumpOnOffZone1_local = HeatPumpOnOffZone1;
}
}
if (FloorHeatingOnOff != FloorHeatingOnOff_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','FloorHeatingOnOff','" + FloorHeatingOnOff + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
FloorHeatingOnOff_local = FloorHeatingOnOff;
}
}
if (SetWorkingMode != SetWorkingMode_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SetWorkingMode','" + SetWorkingMode + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SetWorkingMode_local = SetWorkingMode;
}
}
if (SetT1sTemperature != SetT1sTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SetT1sTemperature','" + SetT1sTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SetT1sTemperature_local = SetT1sTemperature;
}
}
if (Zone1SetT1sTemperature != Zone1SetT1sTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Zone1SetT1sTemperature','" + Zone1SetT1sTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Zone1SetT1sTemperature_local = Zone1SetT1sTemperature;
}
}
if (Zone2SetT1sTemperature != Zone2SetT1sTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Zone2SetT1sTemperature','" + Zone2SetT1sTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Zone2SetT1sTemperature_local = Zone2SetT1sTemperature;
}
}
if (SetTsTemperature != SetTsTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SetTsTemperature','" + SetTsTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SetTsTemperature_local = SetTsTemperature;
}
}
if (SetDhwTemperature != SetDhwTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SetDhwTemperature','" + SetDhwTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SetDhwTemperature_local = SetDhwTemperature;
}
}
if (EnableCurveSetting != EnableCurveSetting_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableCurveSetting','" + EnableCurveSetting + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableCurveSetting_local = EnableCurveSetting;
}
}
if (EnableDhwRecycling != EnableDhwRecycling_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableDhwRecycling','" + EnableDhwRecycling + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableDhwRecycling_local = EnableDhwRecycling;
}
}
if (EnableEcoMode != EnableEcoMode_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableEcoMode','" + EnableEcoMode + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableEcoMode_local = EnableEcoMode;
}
}
if (EnableHolidayMode != EnableHolidayMode_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableHolidayMode','" + EnableHolidayMode + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableHolidayMode_local = EnableHolidayMode;
}
}
if (SilentModeLevel != SilentModeLevel_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SilentModeLevel','" + SilentModeLevel + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SilentModeLevel_local = SilentModeLevel;
}
}
if (EnableSilentMode != EnableSilentMode_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableSilentMode','" + EnableSilentMode + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableSilentMode_local = EnableSilentMode;
}
}
if (HolidayAway != HolidayAway_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HolidayAway','" + HolidayAway + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HolidayAway_local = HolidayAway;
}
}
if (Disinfect != Disinfect_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Disinfect','" + Disinfect + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Disinfect_local = Disinfect;
}
}
if (CurveSelection != CurveSelection_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','CurveSelection','" + CurveSelection + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
CurveSelection_local = CurveSelection;
}
}
if (ForcedWaterHeating != ForcedWaterHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ForcedWaterHeating','" + ForcedWaterHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ForcedWaterHeating_local = ForcedWaterHeating;
}
}
if (ForcedTBH != ForcedTBH_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ForcedTBH','" + ForcedTBH + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ForcedTBH_local = ForcedTBH;
}
}
if (ForcedIBH1 != ForcedIBH1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ForcedIBH1','" + ForcedIBH1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ForcedIBH1_local = ForcedIBH1;
}
}
if (t_SG_MAX != t_SG_MAX_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_SG_MAX','" + t_SG_MAX + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_SG_MAX_local = t_SG_MAX;
}
}
// OperatingFrequency
if (OperatingFrequency != OperatingFrequency_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OperatingFrequency','" + OperatingFrequency + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OperatingFrequency_local = OperatingFrequency;
}
}
// OperatingMode
if (OperatingMode != OperatingMode_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OperatingMode','" + OperatingMode + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OperatingMode_local = OperatingMode;
}
}
// FanSpeed
if (FanSpeed != FanSpeed_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','FanSpeed','" + FanSpeed + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
FanSpeed_local = FanSpeed;
}
}
// PmvOpenness
if (PmvOpenness != PmvOpenness_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','PmvOpenness','" + PmvOpenness + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
PmvOpenness_local = PmvOpenness;
}
}
// WaterInletTemperature
if (WaterInletTemperature != WaterInletTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WaterInletTemperature','" + WaterInletTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WaterInletTemperature_local = WaterInletTemperature;
}
}
// WaterOutletTemperature
if (WaterOutletTemperature != WaterOutletTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WaterOutletTemperature','" + WaterOutletTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WaterOutletTemperature_local = WaterOutletTemperature;
}
}
// CondenserTemperature
if (CondenserTemperature != CondenserTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','CondenserTemperature','" + CondenserTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
CondenserTemperature_local = CondenserTemperature;
}
}
// OutdoorTemperature
if (OutdoorTemperature != OutdoorTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OutdoorTemperature','" + OutdoorTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OutdoorTemperature_local = OutdoorTemperature;
}
}
// DischargeTemperature
if (DischargeTemperature != DischargeTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DischargeTemperature','" + DischargeTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DischargeTemperature_local = DischargeTemperature;
}
}
// ReturnAirTemperature
if (ReturnAirTemperature != ReturnAirTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ReturnAirTemperature','" + ReturnAirTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ReturnAirTemperature_local = ReturnAirTemperature;
}
}
// TotalWaterOutletTemperature
if (TotalWaterOutletTemperature != TotalWaterOutletTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TotalWaterOutletTemperature','" + TotalWaterOutletTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TotalWaterOutletTemperature_local = TotalWaterOutletTemperature;
}
}
// SystemTotalWaterOutletTemperature
if (SystemTotalWaterOutletTemperature != SystemTotalWaterOutletTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SystemTotalWaterOutletTemperature','" + SystemTotalWaterOutletTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SystemTotalWaterOutletTemperature_local = SystemTotalWaterOutletTemperature;
}
}
// RefrigerantLiquidTemperature
if (RefrigerantLiquidTemperature != RefrigerantLiquidTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RefrigerantLiquidTemperature','" + RefrigerantLiquidTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RefrigerantLiquidTemperature_local = RefrigerantLiquidTemperature;
}
}
// RefrigerantGasTemperature
if (RefrigerantGasTemperature != RefrigerantGasTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RefrigerantGasTemperature','" + RefrigerantGasTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RefrigerantGasTemperature_local = RefrigerantGasTemperature;
}
}
// RoomTemperature
if (RoomTemperature != RoomTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RoomTemperature','" + RoomTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RoomTemperature_local = RoomTemperature;
}
}
// WaterTankTemperature
if (WaterTankTemperature != WaterTankTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WaterTankTemperature','" + WaterTankTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WaterTankTemperature_local = WaterTankTemperature;
}
}
// OutdoorHighPressure
if (OutdoorHighPressure != OutdoorHighPressure_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OutdoorHighPressure','" + OutdoorHighPressure + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OutdoorHighPressure_local = OutdoorHighPressure;
}
}
// OutdoorLowPressure
if (OutdoorLowPressure != OutdoorLowPressure_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OutdoorLowPressure','" + OutdoorLowPressure + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OutdoorLowPressure_local = OutdoorLowPressure;
}
}
// OutdoorUnitCurrent
if (OutdoorUnitCurrent != OutdoorUnitCurrent_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OutdoorUnitCurrent','" + OutdoorUnitCurrent + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OutdoorUnitCurrent_local = OutdoorUnitCurrent;
}
}
// OutdoorUnitVoltage
if (OutdoorUnitVoltage != OutdoorUnitVoltage_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OutdoorUnitVoltage','" + OutdoorUnitVoltage + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OutdoorUnitVoltage_local = OutdoorUnitVoltage;
}
}
// CompresorOperatingTime
if (CompresorOperatingTime != CompresorOperatingTime_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','CompresorOperatingTime','" + CompresorOperatingTime + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
CompresorOperatingTime_local = CompresorOperatingTime;
}
}
// CurrentFault
if (CurrentFault != CurrentFault_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','CurrentFault','" + CurrentFault + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
CurrentFault_local = CurrentFault;
}
}
// Fault1
if (Fault1 != Fault1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Fault1','" + Fault1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Fault1_local = Fault1;
}
}
// Fault2
if (Fault2 != Fault2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Fault2','" + Fault2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Fault2_local = Fault2;
}
}
// Fault3
if (Fault3 != Fault3_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Fault3','" + Fault3 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Fault3_local = Fault3;
}
}
// EUV
if (EUV != EUV_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EUV','" + EUV + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EUV_local = EUV;
}
}
// SG
if (SG != SG_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SG','" + SG + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SG_local = SG;
}
}
// SolarEnergySignalInput
if (SolarEnergySignalInput != SolarEnergySignalInput_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SolarEnergySignalInput','" + SolarEnergySignalInput + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SolarEnergySignalInput_local = SolarEnergySignalInput;
}
}
// RoomTemperatureControllerCooling
if (RoomTemperatureControllerCooling != RoomTemperatureControllerCooling_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RoomTemperatureControllerCooling','" + RoomTemperatureControllerCooling + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RoomTemperatureControllerCooling_local = RoomTemperatureControllerCooling;
}
}
// RoomTemperatureControllerHeating
if (RoomTemperatureControllerHeating != RoomTemperatureControllerHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RoomTemperatureControllerHeating','" + RoomTemperatureControllerHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RoomTemperatureControllerHeating_local = RoomTemperatureControllerHeating;
}
}
// OutdoorUnitTestModeMark
if (OutdoorUnitTestModeMark != OutdoorUnitTestModeMark_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OutdoorUnitTestModeMark','" + OutdoorUnitTestModeMark + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OutdoorUnitTestModeMark_local = OutdoorUnitTestModeMark;
}
}
// RemoteOnOff
if (RemoteOnOff != RemoteOnOff_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RemoteOnOff','" + RemoteOnOff + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RemoteOnOff_local = RemoteOnOff;
}
}
// OilReturn
if (OilReturn != OilReturn_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','OilReturn','" + OilReturn + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
OilReturn_local = OilReturn;
}
}
// AntiFreeze
if (AntiFreeze != AntiFreeze_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','AntiFreeze','" + AntiFreeze + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
AntiFreeze_local = AntiFreeze;
}
}
// Defrosting
if (Defrosting != Defrosting_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','Defrosting','" + Defrosting + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
Defrosting_local = Defrosting;
}
}
// DEFROST
if (DEFROST != DEFROST_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DEFROST','" + DEFROST + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DEFROST_local = DEFROST;
}
}
// ExternalHeater
if (ExternalHeater != ExternalHeater_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ExternalHeater','" + ExternalHeater + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ExternalHeater_local = ExternalHeater;
}
}
// RUN
if (RUN != RUN_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RUN','" + RUN + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RUN_local = RUN;
}
}
// ALARM
if (ALARM != ALARM_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ALARM','" + ALARM + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ALARM_local = ALARM;
}
}
// SolarWaterPump
if (SolarWaterPump != SolarWaterPump_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SolarWaterPump','" + SolarWaterPump + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SolarWaterPump_local = SolarWaterPump;
}
}
// HEAT4
if (HEAT4 != HEAT4_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HEAT4','" + HEAT4 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HEAT4_local = HEAT4;
}
}
// SV2
if (SV2 != SV2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SV2','" + SV2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SV2_local = SV2;
}
}
// MixedWaterPumpP_c
if (MixedWaterPumpP_c != MixedWaterPumpP_c_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','MixedWaterPumpP_c','" + MixedWaterPumpP_c + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
MixedWaterPumpP_c_local = MixedWaterPumpP_c;
}
}
// WaterReturnWaterP_d
if (WaterReturnWaterP_d != WaterReturnWaterP_d_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WaterReturnWaterP_d','" + WaterReturnWaterP_d + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WaterReturnWaterP_d_local = WaterReturnWaterP_d;
}
}
// ExternalWaterPumpP_o
if (ExternalWaterPumpP_o != ExternalWaterPumpP_o_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ExternalWaterPumpP_o','" + ExternalWaterPumpP_o + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ExternalWaterPumpP_o_local = ExternalWaterPumpP_o;
}
}
// SV1
if (SV1 != SV1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SV1','" + SV1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SV1_local = SV1;
}
}
// WaterPumpPUMP_I
if (WaterPumpPUMP_I != WaterPumpPUMP_I_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WaterPumpPUMP_I','" + WaterPumpPUMP_I + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WaterPumpPUMP_I_local = WaterPumpPUMP_I;
}
}
// ElectricHeaterTBH
if (ElectricHeaterTBH != ElectricHeaterTBH_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ElectricHeaterTBH','" + ElectricHeaterTBH + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ElectricHeaterTBH_local = ElectricHeaterTBH;
}
}
// ElectricHeaterIBH1
if (ElectricHeaterIBH1 != ElectricHeaterIBH1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','ElectricHeaterIBH1','" + ElectricHeaterIBH1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
ElectricHeaterIBH1_local = ElectricHeaterIBH1;
}
}
// WholeUnitVersionNo
if (WholeUnitVersionNo != WholeUnitVersionNo_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WholeUnitVersionNo','" + WholeUnitVersionNo + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WholeUnitVersionNo_local = WholeUnitVersionNo;
}
}
// WiredControllerVersionNo
if (WiredControllerVersionNo != WiredControllerVersionNo_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WiredControllerVersionNo','" + WiredControllerVersionNo + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WiredControllerVersionNo_local = WiredControllerVersionNo;
}
}
// UnitTargetFrequency
if (UnitTargetFrequency != UnitTargetFrequency_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','UnitTargetFrequency','" + UnitTargetFrequency + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
UnitTargetFrequency_local = UnitTargetFrequency;
}
}
// DcBusCurrent
if (DcBusCurrent != DcBusCurrent_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DcBusCurrent','" + DcBusCurrent + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DcBusCurrent_local = DcBusCurrent;
}
}
// DcBusVoltage
if (DcBusVoltage != DcBusVoltage_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DcBusVoltage','" + DcBusVoltage + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DcBusVoltage_local = DcBusVoltage;
}
}
// TfModuleTemperature
if (TfModuleTemperature != TfModuleTemperature_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TfModuleTemperature','" + TfModuleTemperature + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TfModuleTemperature_local = TfModuleTemperature;
}
}
// HydraulicModuleCurveT1sCalculatedValue1
if (HydraulicModuleCurveT1sCalculatedValue1 != HydraulicModuleCurveT1sCalculatedValue1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HydraulicModuleCurveT1sCalculatedValue1','" + HydraulicModuleCurveT1sCalculatedValue1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HydraulicModuleCurveT1sCalculatedValue1_local = HydraulicModuleCurveT1sCalculatedValue1;
}
}
// HydraulicModuleCurveT1sCalculatedValue2
if (HydraulicModuleCurveT1sCalculatedValue2 != HydraulicModuleCurveT1sCalculatedValue2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HydraulicModuleCurveT1sCalculatedValue2','" + HydraulicModuleCurveT1sCalculatedValue2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HydraulicModuleCurveT1sCalculatedValue2_local = HydraulicModuleCurveT1sCalculatedValue2;
}
}
// WaterFlow
if (WaterFlow != WaterFlow_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','WaterFlow','" + WaterFlow + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
WaterFlow_local = WaterFlow;
}
}
// LimitSchemeOfOutdoorUnitCurrent
if (LimitSchemeOfOutdoorUnitCurrent != LimitSchemeOfOutdoorUnitCurrent_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','LimitSchemeOfOutdoorUnitCurrent','" + LimitSchemeOfOutdoorUnitCurrent + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
LimitSchemeOfOutdoorUnitCurrent_local = LimitSchemeOfOutdoorUnitCurrent;
}
}
// AbilityOfHydraulicModule
if (AbilityOfHydraulicModule != AbilityOfHydraulicModule_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','AbilityOfHydraulicModule','" + AbilityOfHydraulicModule + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
AbilityOfHydraulicModule_local = AbilityOfHydraulicModule;
}
}
// HomeApplianceType
if (HomeApplianceType != HomeApplianceType_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HomeApplianceType','" + HomeApplianceType + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HomeApplianceType_local = HomeApplianceType;
}
}
// TemperatureUpperLimitOfT1sCooling
if (TemperatureUpperLimitOfT1sCooling != TemperatureUpperLimitOfT1sCooling_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureUpperLimitOfT1sCooling','" + TemperatureUpperLimitOfT1sCooling + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureUpperLimitOfT1sCooling_local = TemperatureUpperLimitOfT1sCooling;
}
}
// TemperatureLowerLimitOfT1sCooling
if (TemperatureLowerLimitOfT1sCooling != TemperatureLowerLimitOfT1sCooling_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureLowerLimitOfT1sCooling','" + TemperatureLowerLimitOfT1sCooling + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureLowerLimitOfT1sCooling_local = TemperatureLowerLimitOfT1sCooling;
}
}
// TemperatureUpperLimitOfT1sHeating
if (TemperatureUpperLimitOfT1sHeating != TemperatureUpperLimitOfT1sHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureUpperLimitOfT1sHeating','" + TemperatureUpperLimitOfT1sHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureUpperLimitOfT1sHeating_local = TemperatureUpperLimitOfT1sHeating;
}
}
// TemperatureLowerLimitOfT1sHeating
if (TemperatureLowerLimitOfT1sHeating != TemperatureLowerLimitOfT1sHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureLowerLimitOfT1sHeating','" + TemperatureLowerLimitOfT1sHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureLowerLimitOfT1sHeating_local = TemperatureLowerLimitOfT1sHeating;
}
}
// TemperatureUpperLimitOfTsSetting
if (TemperatureUpperLimitOfTsSetting != TemperatureUpperLimitOfTsSetting_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureUpperLimitOfTsSetting','" + TemperatureUpperLimitOfTsSetting + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureUpperLimitOfTsSetting_local = TemperatureUpperLimitOfTsSetting;
}
}
// TemperatureLowerLimitOfTsSetting
if (TemperatureLowerLimitOfTsSetting != TemperatureLowerLimitOfTsSetting_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureLowerLimitOfTsSetting','" + TemperatureLowerLimitOfTsSetting + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureLowerLimitOfTsSetting_local = TemperatureLowerLimitOfTsSetting;
}
}
// TemperatureUpperLimitOfWaterHeating
if (TemperatureUpperLimitOfWaterHeating != TemperatureUpperLimitOfWaterHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureUpperLimitOfWaterHeating','" + TemperatureUpperLimitOfWaterHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureUpperLimitOfWaterHeating_local = TemperatureUpperLimitOfWaterHeating;
}
}
// TemperatureLowerLimitOfWaterHeating
if (TemperatureLowerLimitOfWaterHeating != TemperatureLowerLimitOfWaterHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','TemperatureLowerLimitOfWaterHeating','" + TemperatureLowerLimitOfWaterHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
TemperatureLowerLimitOfWaterHeating_local = TemperatureLowerLimitOfWaterHeating;
}
}
// PumpRunningTime
if (PumpRunningTime != PumpRunningTime_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','PumpRunningTime','" + PumpRunningTime + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
PumpRunningTime_local = PumpRunningTime;
}
}
// EnableWaterHeating
if (EnableWaterHeating != EnableWaterHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableWaterHeating','" + EnableWaterHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableWaterHeating_local = EnableWaterHeating;
}
}
// SupportWaterTankElectricHeaterTBH
if (SupportWaterTankElectricHeaterTBH != SupportWaterTankElectricHeaterTBH_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SupportWaterTankElectricHeaterTBH','" + SupportWaterTankElectricHeaterTBH + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SupportWaterTankElectricHeaterTBH_local = SupportWaterTankElectricHeaterTBH;
}
}
// SupportDisinfection
if (SupportDisinfection != SupportDisinfection_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SupportDisinfection','" + SupportDisinfection + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SupportDisinfection_local = SupportDisinfection;
}
}
// DhwPump
if (DhwPump != DhwPump_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DhwPump','" + DhwPump + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DhwPump_local = DhwPump;
}
}
// DhwPumpSupportPipeDisinfect
if (DhwPumpSupportPipeDisinfect != DhwPumpSupportPipeDisinfect_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DhwPumpSupportPipeDisinfect','" + DhwPumpSupportPipeDisinfect + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DhwPumpSupportPipeDisinfect_local = DhwPumpSupportPipeDisinfect;
}
}
// EnableCooling
if (EnableCooling != EnableCooling_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableCooling','" + EnableCooling + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableCooling_local = EnableCooling;
}
}
// T1sCoolingHighLowTemperatureSetting
if (T1sCoolingHighLowTemperatureSetting != T1sCoolingHighLowTemperatureSetting_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1sCoolingHighLowTemperatureSetting','" + T1sCoolingHighLowTemperatureSetting + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1sCoolingHighLowTemperatureSetting_local = T1sCoolingHighLowTemperatureSetting;
}
}
// EnableHeating
if (EnableHeating != EnableHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableHeating','" + EnableHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableHeating_local = EnableHeating;
}
}
// T1sHeatingHighLowTemperatureSetting
if (T1sHeatingHighLowTemperatureSetting != T1sHeatingHighLowTemperatureSetting_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1sHeatingHighLowTemperatureSetting','" + T1sHeatingHighLowTemperatureSetting + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1sHeatingHighLowTemperatureSetting_local = T1sHeatingHighLowTemperatureSetting;
}
}
// SupportT1Sensor
if (SupportT1Sensor != SupportT1Sensor_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SupportT1Sensor','" + SupportT1Sensor + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SupportT1Sensor_local = SupportT1Sensor;
}
}
// SupportRoomTemperatureSensorTa
if (SupportRoomTemperatureSensorTa != SupportRoomTemperatureSensorTa_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SupportRoomTemperatureSensorTa','" + SupportRoomTemperatureSensorTa + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SupportRoomTemperatureSensorTa_local = SupportRoomTemperatureSensorTa;
}
}
// SupportRoomThermostat
if (SupportRoomThermostat != SupportRoomThermostat_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SupportRoomThermostat','" + SupportRoomThermostat + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SupportRoomThermostat_local = SupportRoomThermostat;
}
}
// RoomThermostat
if (RoomThermostat != RoomThermostat_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RoomThermostat','" + RoomThermostat + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RoomThermostat_local = RoomThermostat;
}
}
// DualRoomThermostat
if (DualRoomThermostat != DualRoomThermostat_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DualRoomThermostat','" + DualRoomThermostat + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DualRoomThermostat_local = DualRoomThermostat;
}
}
// RoomCoolingHeatingFirst
if (RoomCoolingHeatingFirst != RoomCoolingHeatingFirst_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','RoomCoolingHeatingFirst','" + RoomCoolingHeatingFirst + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
RoomCoolingHeatingFirst_local = RoomCoolingHeatingFirst;
}
}
// DefineThePort
if (DefineThePort != DefineThePort_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DefineThePort','" + DefineThePort + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DefineThePort_local = DefineThePort;
}
}
// SmartGrid
if (SmartGrid != SmartGrid_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SmartGrid','" + SmartGrid + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SmartGrid_local = SmartGrid;
}
}
// EnableTw2
if (EnableTw2 != EnableTw2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EnableTw2','" + EnableTw2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EnableTw2_local = EnableTw2;
}
}
// SettingTheHighLowTemperatureOfCoolingModeT1s
if (SettingTheHighLowTemperatureOfCoolingModeT1s != SettingTheHighLowTemperatureOfCoolingModeT1s_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SettingTheHighLowTemperatureOfCoolingModeT1s','" + SettingTheHighLowTemperatureOfCoolingModeT1s + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SettingTheHighLowTemperatureOfCoolingModeT1s_local = SettingTheHighLowTemperatureOfCoolingModeT1s;
}
}
// SettingTheHighLowTemperatureOfHeatingModeT1s
if (SettingTheHighLowTemperatureOfHeatingModeT1s != SettingTheHighLowTemperatureOfHeatingModeT1s_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','SettingTheHighLowTemperatureOfHeatingModeT1s','" + SettingTheHighLowTemperatureOfHeatingModeT1s + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
SettingTheHighLowTemperatureOfHeatingModeT1s_local = SettingTheHighLowTemperatureOfHeatingModeT1s;
}
}
// DoubleZoneSettingIsValid
if (DoubleZoneSettingIsValid != DoubleZoneSettingIsValid_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','DoubleZoneSettingIsValid','" + DoubleZoneSettingIsValid + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
DoubleZoneSettingIsValid_local = DoubleZoneSettingIsValid;
}
}
// dT5_On
if (dT5_On != dT5_On_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT5_On','" + dT5_On + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT5_On_local = dT5_On;
}
}
// dT1S5
if (dT1S5 != dT1S5_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT1S5','" + dT1S5 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT1S5_local = dT1S5;
}
}
// T_Interval_DHW
if (T_Interval_DHW != T_Interval_DHW_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T_Interval_DHW','" + T_Interval_DHW + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T_Interval_DHW_local = T_Interval_DHW;
}
}
// T4DHWmax
if (T4DHWmax != T4DHWmax_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4DHWmax','" + T4DHWmax + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4DHWmax_local = T4DHWmax;
}
}
// T4DHWmin
if (T4DHWmin != T4DHWmin_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4DHWmin','" + T4DHWmin + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4DHWmin_local = T4DHWmin;
}
}
// t_TBH_delay
if (t_TBH_delay != t_TBH_delay_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_TBH_delay','" + t_TBH_delay + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_TBH_delay_local = t_TBH_delay;
}
}
// dT5_TBH_off
if (dT5_TBH_off != dT5_TBH_off_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT5_TBH_off','" + dT5_TBH_off + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT5_TBH_off_local = dT5_TBH_off;
}
}
// T4_TBH_on
if (T4_TBH_on != T4_TBH_on_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4_TBH_on','" + T4_TBH_on + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4_TBH_on_local = T4_TBH_on;
}
}
// T5s_DI
if (T5s_DI != T5s_DI_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T5s_DI','" + T5s_DI + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T5s_DI_local = T5s_DI;
}
}
// t_DI_max
if (t_DI_max != t_DI_max_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_DI_max','" + t_DI_max + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_DI_max_local = t_DI_max;
}
}
// t_DI_hightemp
if (t_DI_hightemp != t_DI_hightemp_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_DI_hightemp','" + t_DI_hightemp + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_DI_hightemp_local = t_DI_hightemp;
}
}
// t_interval_C
if (t_interval_C != t_interval_C_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_interval_C','" + t_interval_C + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_interval_C_local = t_interval_C;
}
}
// dT1SC
if (dT1SC != dT1SC_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT1SC','" + dT1SC + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT1SC_local = dT1SC;
}
}
// dTSC
if (dTSC != dTSC_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dTSC','" + dTSC + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dTSC_local = dTSC;
}
}
// T4cmax
if (T4cmax != T4cmax_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4cmax','" + T4cmax + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4cmax_local = T4cmax;
}
}
// T4cmin
if (T4cmin != T4cmin_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4cmin','" + T4cmin + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4cmin_local = T4cmin;
}
}
// t_interval_H
if (t_interval_H != t_interval_H_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_interval_H','" + t_interval_H + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_interval_H_local = t_interval_H;
}
}
// dT1SH
if (dT1SH != dT1SH_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT1SH','" + dT1SH + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT1SH_local = dT1SH;
}
}
// dTSH
if (dTSH != dTSH_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dTSH','" + dTSH + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dTSH_local = dTSH;
}
}
// T4hmax
if (T4hmax != T4hmax_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4hmax','" + T4hmax + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4hmax_local = T4hmax;
}
}
// T4hmin
if (T4hmin != T4hmin_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4hmin','" + T4hmin + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4hmin_local = T4hmin;
}
}
// T4_IBH_on
if (T4_IBH_on != T4_IBH_on_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4_IBH_on','" + T4_IBH_on + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4_IBH_on_local = T4_IBH_on;
}
}
// dT1_IBH_on
if (dT1_IBH_on != dT1_IBH_on_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT1_IBH_on','" + dT1_IBH_on + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT1_IBH_on_local = dT1_IBH_on;
}
}
// t_IBH_delay
if (t_IBH_delay != t_IBH_delay_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_IBH_delay','" + t_IBH_delay + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_IBH_delay_local = t_IBH_delay;
}
}
// T4_AHS_on
if (T4_AHS_on != T4_AHS_on_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4_AHS_on','" + T4_AHS_on + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4_AHS_on_local = T4_AHS_on;
}
}
// dT1_AHS_on
if (dT1_AHS_on != dT1_AHS_on_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','dT1_AHS_on','" + dT1_AHS_on + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
dT1_AHS_on_local = dT1_AHS_on;
}
}
// t_AHS_delay
if (t_AHS_delay != t_AHS_delay_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_AHS_delay','" + t_AHS_delay + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_AHS_delay_local = t_AHS_delay;
}
}
// t_DHWHP_max
if (t_DHWHP_max != t_DHWHP_max_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_DHWHP_max','" + t_DHWHP_max + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_DHWHP_max_local = t_DHWHP_max;
}
}
// t_DHWHP_restrict
if (t_DHWHP_restrict != t_DHWHP_restrict_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_DHWHP_restrict','" + t_DHWHP_restrict + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_DHWHP_restrict_local = t_DHWHP_restrict;
}
}
// T4autocmin
if (T4autocmin != T4autocmin_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4autocmin','" + T4autocmin + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4autocmin_local = T4autocmin;
}
}
// T4autohmax
if (T4autohmax != T4autohmax_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4autohmax','" + T4autohmax + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4autohmax_local = T4autohmax;
}
}
// T1S_H_A_H
if (T1S_H_A_H != T1S_H_A_H_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1S_H_A_H','" + T1S_H_A_H + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1S_H_A_H_local = T1S_H_A_H;
}
}
// T5S_H_A_DHW
if (T5S_H_A_DHW != T5S_H_A_DHW_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T5S_H_A_DHW','" + T5S_H_A_DHW + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T5S_H_A_DHW_local = T5S_H_A_DHW;
}
}
// t_DRYUP
if (t_DRYUP != t_DRYUP_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_DRYUP','" + t_DRYUP + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_DRYUP_local = t_DRYUP;
}
}
// t_HIGHPEAK
if (t_HIGHPEAK != t_HIGHPEAK_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_HIGHPEAK','" + t_HIGHPEAK + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_HIGHPEAK_local = t_HIGHPEAK;
}
}
// t_DRYD
if (t_DRYD != t_DRYD_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_DRYD','" + t_DRYD + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_DRYD_local = t_DRYD;
}
}
// T_DRYPEAK
if (T_DRYPEAK != T_DRYPEAK_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T_DRYPEAK','" + T_DRYPEAK + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T_DRYPEAK_local = T_DRYPEAK;
}
}
// t_firstFH
if (t_firstFH != t_firstFH_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','t_firstFH','" + t_firstFH + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
t_firstFH_local = t_firstFH;
}
}
// T1S_FirstFloorHeating
if (T1S_FirstFloorHeating != T1S_FirstFloorHeating_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1S_FirstFloorHeating','" + T1S_FirstFloorHeating + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1S_FirstFloorHeating_local = T1S_FirstFloorHeating;
}
}
// T1SetC1
if (T1SetC1 != T1SetC1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1SetC1','" + T1SetC1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1SetC1_local = T1SetC1;
}
}
// T1SetC2
if (T1SetC2 != T1SetC2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1SetC2','" + T1SetC2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1SetC2_local = T1SetC2;
}
}
// T4C1
if (T4C1 != T4C1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4C1','" + T4C1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4C1_local = T4C1;
}
}
// T4C2
if (T4C2 != T4C2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4C2','" + T4C2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4C2_local = T4C2;
}
}
// T1SetH1
if (T1SetH1 != T1SetH1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1SetH1','" + T1SetH1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1SetH1_local = T1SetH1;
}
}
// T1SetH2
if (T1SetH2 != T1SetH2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T1SetH2','" + T1SetH2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T1SetH2_local = T1SetH2;
}
}
// T4H1
if (T4H1 != T4H1_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4H1','" + T4H1 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4H1_local = T4H1;
}
}
// T4H2
if (T4H2 != T4H2_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T4H2','" + T4H2 + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T4H2_local = T4H2;
}
}
// PowerLimitation
if (PowerLimitation != PowerLimitation_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','PowerLimitation','" + PowerLimitation + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
PowerLimitation_local = PowerLimitation;
}
}
// HB_t_T4_FRESH_C
if (HB_t_T4_FRESH_C != HB_t_T4_FRESH_C_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HB_t_T4_FRESH_C','" + HB_t_T4_FRESH_C + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HB_t_T4_FRESH_C_local = HB_t_T4_FRESH_C;
}
}
// HB_t_T4_FRESH_H
if (HB_t_T4_FRESH_H != HB_t_T4_FRESH_H_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','HB_t_T4_FRESH_H','" + HB_t_T4_FRESH_H + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
HB_t_T4_FRESH_H_local = HB_t_T4_FRESH_H;
}
}
// T_PUMPI_DELAY
if (T_PUMPI_DELAY != T_PUMPI_DELAY_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','T_PUMPI_DELAY','" + T_PUMPI_DELAY + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
T_PUMPI_DELAY_local = T_PUMPI_DELAY;
}
}
// EmissionType
if (EmissionType != EmissionType_local) {
INSERT_SQL = String("INSERT INTO ") + tableScValueRead + " (swID, hwID, paramID, paramValue, paramValueAt) VALUES ('" + SN + "','" + ESP.getChipId() + "','EmissionType','" + EmissionType + "','" + TimeStamp + "')";
Serial.println(INSERT_SQL);
if (!query_mem.execute(INSERT_SQL.c_str())) {
if (Debug) Serial.println("Insert error");
} else {
if (Debug) Serial.println("Data Inserted.");
EmissionType_local = EmissionType;
}
}
} else {
Serial.println("Disconnected from Server. Can't insert.");
}
conn.close(); // close the connection
} else {
Serial.println("\nConnect failed. Trying again on next iteration.");
ESP.restart();
}
}
This procedure is not intended to solve the problem. The purpose is to gather more information.
) on the post composer toolbar:
