Mercurial > bms / file comparison

comparison: bmsd/mysql.c

bmsd/mysql.c

changeset 383
2395bdfac387
parent 334
26c6f8e5d58e
child 405
ef3f0274a1ea
equal deleted inserted replaced
382:547c23b50d00 383:2395bdfac387
353 node->temperature, node->humidity, node->barometer, node->gps_latitude, node->gps_longitude, node->gps_altitude, 353 node->temperature, node->humidity, node->barometer, node->gps_latitude, node->gps_longitude, node->gps_altitude,
354 node->net_address, node->net_ifname, node->net_rssi); 354 node->net_address, node->net_ifname, node->net_rssi);
355 355
356 if (mysql_query(con, query)) { 356 if (mysql_query(con, query)) {
357 syslog(LOG_NOTICE, "MySQL: INSERT INTO mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con)); 357 syslog(LOG_NOTICE, "MySQL: INSERT INTO mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
358 syslog(LOG_NOTICE, query);
358 } else { 359 } else {
359 syslog(LOG_NOTICE, "MySQL: insert new node %s", node->node); 360 syslog(LOG_NOTICE, "MySQL: insert new node %s", node->node);
360 } 361 }
361 362
362 free(query); 363 free(query);
381 node->temperature, node->humidity, node->barometer, node->gps_latitude, node->gps_longitude, node->gps_altitude, 382 node->temperature, node->humidity, node->barometer, node->gps_latitude, node->gps_longitude, node->gps_altitude,
382 node->net_address, node->net_ifname, node->net_rssi, node->uuid); 383 node->net_address, node->net_ifname, node->net_rssi, node->uuid);
383 384
384 if (mysql_query(con, query)) { 385 if (mysql_query(con, query)) {
385 syslog(LOG_NOTICE, "MySQL: UPDATE mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con)); 386 syslog(LOG_NOTICE, "MySQL: UPDATE mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
387 syslog(LOG_NOTICE, query);
386 } 388 }
387 389
388 free(query); 390 free(query);
389 } 391 }
390 392
393 void node_mysql_death(char *node) 395 void node_mysql_death(char *node)
394 { 396 {
395 char *query = malloc(512); 397 char *query = malloc(512);
396 398
397 snprintf(query, 511, "UPDATE mon_nodes SET online='N' WHERE node='%s'", node); 399 snprintf(query, 511, "UPDATE mon_nodes SET online='N' WHERE node='%s'", node);
398 // printf("%s\n", query);
399 400
400 if (mysql_query(con, query)) { 401 if (mysql_query(con, query)) {
401 syslog(LOG_NOTICE, "MySQL: UPDATE mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con)); 402 syslog(LOG_NOTICE, "MySQL: UPDATE mon_nodes error %u (%s))", mysql_errno(con), mysql_error(con));
403 syslog(LOG_NOTICE, query);
402 } 404 }
403 405
404 free(query); 406 free(query);
405 } 407 }
406 408
443 fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent, 445 fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent,
444 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, 446 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low,
445 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, 447 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi,
446 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light); 448 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light);
447 449
448 // printf("%s\n", query);
449
450 if (mysql_query(con, query)) { 450 if (mysql_query(con, query)) {
451 syslog(LOG_NOTICE, "MySQL: INSERT INTO mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con)); 451 syslog(LOG_NOTICE, "MySQL: INSERT INTO mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
452 syslog(LOG_NOTICE, query);
452 } else { 453 } else {
453 syslog(LOG_NOTICE, "MySQL: insert new fermenter %s/%s", fermenter->node, fermenter->alias); 454 syslog(LOG_NOTICE, "MySQL: insert new fermenter %s/%s", fermenter->node, fermenter->alias);
454 } 455 }
455 456
456 free(query); 457 free(query);
492 fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent, 493 fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent,
493 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, 494 fermenter->profile_inittemp_high, fermenter->profile_inittemp_low,
494 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, 495 fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi,
495 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light, fermenter->uuid); 496 fermenter->webcam_url ? fermenter->webcam_url : "", fermenter->webcam_light, fermenter->uuid);
496 497
497 // printf("%s\n", query);
498
499 if (mysql_query(con, query)) { 498 if (mysql_query(con, query)) {
500 syslog(LOG_NOTICE, "MySQL: UPDATE mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con)); 499 syslog(LOG_NOTICE, "MySQL: UPDATE mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
500 syslog(LOG_NOTICE, query);
501 } 501 }
502 502
503 free(query); 503 free(query);
504 } 504 }
505 505
514 else 514 else
515 snprintf(query, 511, "UPDATE mon_fermenters SET online='N' WHERE node='%s'", node); 515 snprintf(query, 511, "UPDATE mon_fermenters SET online='N' WHERE node='%s'", node);
516 516
517 if (mysql_query(con, query)) { 517 if (mysql_query(con, query)) {
518 syslog(LOG_NOTICE, "MySQL: UPDATE mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con)); 518 syslog(LOG_NOTICE, "MySQL: UPDATE mon_fermenters error %u (%s))", mysql_errno(con), mysql_error(con));
519 syslog(LOG_NOTICE, query);
519 } 520 }
520 521
521 free(query); 522 free(query);
522 } 523 }
523 524

Mercurial Repository: bms

mercurial