comparison: bmsd/mysql.c
bmsd/mysql.c
- changeset 628
- a42166cbb19a
- parent 587
- 31caffee8c9c
- child 680
- 0bb48333d133
equal
deleted
inserted
replaced
| 627:f1a7c14d5601 | 628:a42166cbb19a |
|---|---|
| 727 { | 727 { |
| 728 char *query = malloc(2560); | 728 char *query = malloc(2560); |
| 729 | 729 |
| 730 snprintf(query, 2559, | 730 snprintf(query, 2559, |
| 731 "INSERT INTO mon_ispindels SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', alarm='%d', " \ | 731 "INSERT INTO mon_ispindels SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', alarm='%d', " \ |
| 732 "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d'", | 732 "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d', og_gravity='0.0'", |
| 733 ispindel->uuid, ispindel->alias, ispindel->node, ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, | 733 ispindel->uuid, ispindel->alias, ispindel->node, ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, |
| 734 ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval); | 734 ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval); |
| 735 | 735 |
| 736 if (bms_mysql_query(query) == 0) { | 736 if (bms_mysql_query(query) == 0) { |
| 737 syslog(LOG_NOTICE, "MySQL: insert new ispindel %s", ispindel->node); | 737 syslog(LOG_NOTICE, "MySQL: insert new ispindel %s", ispindel->node); |
| 745 { | 745 { |
| 746 char *query = malloc(2560); | 746 char *query = malloc(2560); |
| 747 | 747 |
| 748 snprintf(query, 2559, | 748 snprintf(query, 2559, |
| 749 "UPDATE mon_ispindels SET online='%d', mode='%s', alarm='%d', " \ | 749 "UPDATE mon_ispindels SET online='%d', mode='%s', alarm='%d', " \ |
| 750 "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d' WHERE uuid='%s'", | 750 "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d', og_gravity=GREATEST(og_gravity, '%.5f') WHERE uuid='%s'", |
| 751 ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, | 751 ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, |
| 752 ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval, ispindel->uuid); | 752 ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval, ispindel->gravity, ispindel->uuid); |
| 753 | 753 |
| 754 bms_mysql_query(query); | 754 bms_mysql_query(query); |
| 755 free(query); | 755 free(query); |
| 756 } | 756 } |
| 757 | 757 |
