pub const SQL_QUERY_WRITE_DATA: &str = "INSERT INTO data (Timestamp, Temperature, TemperatureFiltered, pH, pHFiltered, Conductivity, ConductivityFiltered, ConductivityCompensated, RefillInProgress, TankLevelSwitchPosition, TankLevelSwitchInvalid, TankLevelSwitchPositionStabilized, SurfaceVentilation, AmbTemp, AmbHum, Heater) VALUES (:timestamp, :temp, :temp_f, :ph, :ph_f, :cond, :cond_f, :cond_c, :refill, :tank_pos, :tank_inv, :tank_stab, :vent, :amb_temp, :amb_hum, :heater) ON DUPLICATE KEY UPDATE Temperature=VALUES(Temperature), TemperatureFiltered=VALUES(TemperatureFiltered), pH=VALUES(pH), pHFiltered=VALUES(pHFiltered), Conductivity=VALUES(Conductivity), ConductivityFiltered=VALUES(ConductivityFiltered), ConductivityCompensated=VALUES(ConductivityCompensated), RefillInProgress=VALUES(RefillInProgress), TankLevelSwitchPosition=VALUES(TankLevelSwitchPosition), TankLevelSwitchInvalid=VALUES(TankLevelSwitchInvalid), TankLevelSwitchPositionStabilized=VALUES(TankLevelSwitchPositionStabilized), SurfaceVentilation=VALUES(SurfaceVentilation), AmbTemp=VALUES(AmbTemp), AmbHum=VALUES(AmbHum), Heater=VALUES(Heater);";Expand description
Writes the time-based data into the database.