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, |