diff -r 307640ba6ab6 -r 047ead629d4a bmsd/mysql.c --- a/bmsd/mysql.c Wed Feb 27 14:40:05 2019 +0100 +++ b/bmsd/mysql.c Wed Feb 27 22:13:07 2019 +0100 @@ -205,6 +205,8 @@ fermenter->profile_steps = xstrcpy(row[42]); } fermenter->stage = xstrcpy(row[43]); + fermenter->yeast_lo = atof(row[45]); + fermenter->yeast_hi = atof(row[46]); if (fermenters == NULL) { fermenters = fermenter; @@ -418,7 +420,8 @@ "psu_address='%s', psu_state='%d', " \ "mode='%s', alarm='%d', setpoint_high='%.3f', setpoint_low='%.3f', " \ "profile_uuid='%s', profile_name='%s', profile_state='%s', profile_percent='%d', " \ - "profile_inittemp_high='%.3f', profile_inittemp_low='%.3f', profile_steps='%s', stage='%s'", + "profile_inittemp_high='%.3f', profile_inittemp_low='%.3f', profile_steps='%s', stage='%s', " \ + "yeast_lo='%.1f', yeast_hi='%.1f'", fermenter->uuid, fermenter->alias, fermenter->node, fermenter->online ? "Y":"N", fermenter->beercode ? fermenter->beercode : "", fermenter->beername ? fermenter->beername : "", fermenter->beeruuid ? fermenter->beeruuid : "", @@ -435,7 +438,7 @@ fermenter->profile_uuid ? fermenter->profile_uuid : "", fermenter->profile_name ? fermenter->profile_name : "", fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent, fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, - fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage); + fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi); // printf("%s\n", query); @@ -466,7 +469,8 @@ "psu_address='%s', psu_state='%d', " \ "mode='%s', alarm='%d', setpoint_high='%.3f', setpoint_low='%.3f', " \ "profile_uuid='%s', profile_name='%s', profile_state='%s', profile_percent='%d', " \ - "profile_inittemp_high='%.3f', profile_inittemp_low='%.3f', profile_steps='%s', stage='%s' WHERE uuid='%s'", + "profile_inittemp_high='%.3f', profile_inittemp_low='%.3f', profile_steps='%s', stage='%s', " \ + "yeast_lo='%.1f', yeast_hi='%.1f' WHERE uuid='%s'", fermenter->online ? "Y":"N", fermenter->beercode ? fermenter->beercode : "", fermenter->beername ? fermenter->beername : "", fermenter->beeruuid ? fermenter->beeruuid : "", fermenter->air_address ? fermenter->air_address : "", fermenter->air_state ? fermenter->air_state : "", fermenter->air_temperature, @@ -482,7 +486,7 @@ fermenter->profile_uuid ? fermenter->profile_uuid : "", fermenter->profile_name ? fermenter->profile_name : "", fermenter->profile_state ? fermenter->profile_state : "", fermenter->profile_percent, fermenter->profile_inittemp_high, fermenter->profile_inittemp_low, - fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->uuid); + fermenter->profile_steps ? fermenter->profile_steps : "", fermenter->stage, fermenter->yeast_lo, fermenter->yeast_hi, fermenter->uuid); // printf("%s\n", query);