438 |
438 |
439 /* |
439 /* |
440 * Build the MySQL log |
440 * Build the MySQL log |
441 */ |
441 */ |
442 if (trigger) { |
442 if (trigger) { |
443 snprintf(query, 511, "INSERT INTO log_co2pressure SET code='%s', datetime='%s', temperature='%.4f', " \ |
443 snprintf(query, 511, "INSERT IGNORE INTO log_co2pressure SET code='%s', datetime='%s', temperature='%.4f', " \ |
444 "pressure='%.4f', uuid='%s'", |
444 "pressure='%.4f', uuid='%s'", |
445 log->product_code, log->datetime, log->temperature, log->pressure, log->uuid); |
445 log->product_code, log->datetime, log->temperature, log->pressure, log->uuid); |
446 //syslog(LOG_NOTICE, "%s", query); |
446 //syslog(LOG_NOTICE, "%s", query); |
447 bms_mysql_query(query); |
447 bms_mysql_query(query); |
448 } |
448 } |