--- 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);
