bmsd/fermenters.c

changeset 799
cf145b35d65f
parent 791
b7c7dc0a65c9
child 852
71f0fa38b634
equal deleted inserted replaced
798:67e0384c0e63 799:cf145b35d65f
934 */ 934 */
935 if (log->event && strlen(log->event)) 935 if (log->event && strlen(log->event))
936 trigger = true; 936 trigger = true;
937 if (trigger) { 937 if (trigger) {
938 snprintf(query, 511, 938 snprintf(query, 511,
939 "INSERT INTO log_fermenter SET code='%s', datetime='%s', mode='%s', stage='%s', " \ 939 "INSERT IGNORE INTO log_fermenter SET code='%s', datetime='%s', mode='%s', stage='%s', " \
940 "temp_air='%.4f', temp_beer='%.4f', temp_chiller='%.4f', temp_room='%.3f', " \ 940 "temp_air='%.4f', temp_beer='%.4f', temp_chiller='%.4f', temp_room='%.3f', " \
941 "sp_low='%.3f', sp_high='%.3f', heater_power='%d', cooler_power='%d', " \ 941 "sp_low='%.3f', sp_high='%.3f', heater_power='%d', cooler_power='%d', " \
942 "event='%s', fermenter_uuid='%s'", 942 "event='%s', fermenter_uuid='%s'",
943 log->product_code, log->datetime, log->mode, log->stage, log->temperature_air, 943 log->product_code, log->datetime, log->mode, log->stage, log->temperature_air,
944 log->temperature_beer, log->temperature_chiller, log->temperature_room, 944 log->temperature_beer, log->temperature_chiller, log->temperature_room,

mercurial