def load(self, id):
steps = self.getSteps(id)
boil_time_alerts = self.getBoilAlerts(id)
name = self.getRecipeName(id)
self.api.set_config_parameter("brew_name", name)
boil_time = self.getBoilTime(id)
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 100 if cbpi.get_config_parameter("unit", "C") == "C" else 212
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
try:
for row in steps:
Step.insert(**{"name": row.get("name"), "type": mashstep_type, "config": {"kettle": mash_kettle, "temp": float(row.get("temp")), "timer": row.get("timer")}})
Step.insert(**{"name": "ChilStep", "type": "ChilStep", "config": {"timer": 15}})
## Add boiling step
Step.insert(**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle": boil_kettle,
"temp": boil_temp,
"timer": boil_time,
## Beer XML defines additions as the total time spent in boiling,
## CBP defines it as time-until-alert
## Also, The model supports five boil-time additions.
## Set the rest to None to signal them being absent
"hop_1": boil_time - boil_time_alerts[0] if len(boil_time_alerts) >= 1 else None,
"hop_2": boil_time - boil_time_alerts[1] if len(boil_time_alerts) >= 2 else None,
"hop_3": boil_time - boil_time_alerts[2] if len(boil_time_alerts) >= 3 else None,
"hop_4": boil_time - boil_time_alerts[3] if len(boil_time_alerts) >= 4 else None,
"hop_5": boil_time - boil_time_alerts[4] if len(boil_time_alerts) >= 5 else None
}
})
## Add Whirlpool step
Step.insert(**{"name": "Whirlpool", "type": "ChilStep", "config": {"timer": 15}})
StepView().reset()
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name, message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe", message=e.message, type="danger")
return ('', 500)
return ('', 204)
def VerifyConfigurations(self):
parameterName = "step_sparge_kettle"
parameterToVerify = cbpi.cache.get("config").get(parameterName)
if parameterToVerify is not None and parameterToVerify.value is not None:
mashKettle = cbpi.get_config_parameter("step_mash_kettle", None)
boilKettle = cbpi.get_config_parameter("step_boil_kettle", None)
# It may be a problem if the brewer have only two kettles and the boil kettle is used to sparge
if parameterToVerify.value == mashKettle or parameterToVerify == boilKettle:
cbpi.notify(
"Invalid kettle",
"Sparge Kettle cannot be the same mash or boil kettles",
timeout=5000)
return False
def load(self, id):
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
mashinstep_type = cbpi.get_config_parameter("step_mashin", "MashInStep")
chilstep_type = cbpi.get_config_parameter("step_chil", "ChilStep")
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 100 if cbpi.get_config_parameter("unit", "C") == "C" else 212
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
conn = None
try:
conn = sqlite3.connect(self.api.app.config['UPLOAD_FOLDER'] + '/kbh.db')
c = conn.cursor()
c.execute('SELECT EinmaischenTemp, Sudname FROM Sud WHERE ID = ?', (id,))
row = c.fetchone()
name = row[1]
self.api.set_config_parameter("brew_name", name)
Step.insert(**{"name": "MashIn", "type": mashinstep_type, "config": {"kettle": mash_kettle, "temp": row[0]}})
### add rest step
for row in c.execute('SELECT * FROM Rasten WHERE SudID = ?', (id,)):
Step.insert(**{"name": row[5], "type": mashstep_type, "config": {"kettle": mash_kettle, "temp": row[3], "timer": row[4]}})
Step.insert(**{"name": "Chil", "type": chilstep_type, "config": {"timer": 15}})
## Add cooking step
c.execute('SELECT max(Zeit) FROM Hopfengaben WHERE SudID = ?', (id,))
row = c.fetchone()
Step.insert(**{"name": "Boil", "type": boilstep_type, "config": {"kettle": boil_kettle, "temp": boil_temp, "timer": row[0]}})
## Add Whirlpool step
Step.insert(**{"name": "Whirlpool", "type": chilstep_type, "config": {"timer": 15}})
#setBrewName(name)
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name, message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe", message=e.message, type="danger")
return ('', 500)
finally:
if conn:
conn.close()
return ('', 204)
def load(self):
try:
data = request.json
name = data.get("name", "No Name")
self.api.set_config_parameter("brew_name", name)
chilstep_type = cbpi.get_config_parameter("step_chil", "ChilStep")
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 100 if cbpi.get_config_parameter("unit", "C") == "C" else 212
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
for step in data.get("steps"):
if step.get("type", None) == "MASH":
Step.insert(**{"name": step.get("name","Mash Step"), "type": mashstep_type, "config": {"kettle": mash_kettle, "temp": step.get("temp",0), "timer": step.get("timer",0)}})
elif step.get("type", None) == "CHIL":
Step.insert(**{"name": step.get("name","Chil"), "type": chilstep_type, "config": {"timer": step.get("timer")}})
elif step.get("type", None) == "BOIL":
Step.insert(**{"name": step.get("name", "Boil"), "type": boilstep_type, "config": {"kettle": boil_kettle, "timer": step.get("timer"), "temp": boil_temp}})
else:
pass
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name, message="")
except Exception as e:
self.api.notify(headline="Failed to load recipe", type="danger", message=str(e))
m = str(e.message)
return (str(e), 500)
return ('', 204)
def load(self, id):
name = self.getRecipeName(id)
self.api.set_config_parameter("brew_name", name)
steps = self.getSteps(id)
first_wort_hops = self.getFirstWortHops(id)
hops = self.getBoilAlerts(id)
boil_time = self.getBoilTime(id)
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
mash_in_temp = self.getMashin(id)
mash_out_temp = self.getMashout(id)
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 100 if cbpi.get_config_parameter("unit",
"C") == "C" else 212
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
try:
if 'modules.plugins.cbpi-SimpleUtilitySteps' in sys.modules:
Step.insert(
**{
"name": "Clear Logs",
"type": "SimpleClearLogsStep",
"config": {}
})
Step.insert(
**{
"name": "Mash in",
"type": "MashInStep",
"config": {
"kettle": mash_kettle,
"temp": mash_in_temp
}
})
for row in steps:
Step.insert(
**{
"name": row.get("name"),
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp")),
"timer": row.get("timer")
}
})
if 'modules.plugins.TelegramPushNotifications' in sys.modules:
Step.insert(
**{
"name": "Iodine Test",
"type": "IodineStep",
"config": {
"kettle": mash_kettle,
"temp": 72,
"timer": 10
}
})
Step.insert(
**{
"name": "Mash out",
"type": "MashInStep",
"config": {
"kettle": mash_kettle,
"temp": mash_out_temp
}
})
if 'modules.plugins.cbpi-SimpleUtilitySteps' in sys.modules:
if first_wort_hops is not "":
Step.insert(
**{
"name": "first wort hopping",
"type": "SimpleManualStep",
"config": {
"heading":
"first wort hopping",
"message":
"Adding these hops to the boiling kettle:\n" +
first_wort_hops + "\n press next button!",
"notifyType":
"success",
"proceed":
"Pause"
}
})
Step.insert(**{
"name": "ChilStep",
"type": "ChilStep",
"config": {
"timer": 45
}
})
if 'modules.plugins.cbpi-SimpleUtilitySteps' in sys.modules:
Step.insert(
**{
"name": "Measure Original Gravity",
"type": "SimpleManualStep",
"config": {
"heading": "Measure Original Gravity",
"message":
"what is the original gravity of the beer wort?",
"notifyType": "success",
"proceed": "Pause"
}
})
## Add boiling step
Step.insert(
**{
"name": "Boiling",
"type": boilstep_type,
"config": {
"kettle": boil_kettle,
"temp": boil_temp,
"temp_diff": 3,
"timer": boil_time,
## The model supports seven boil-time additions.
## Set the rest to None to signal them being absent
"hop_1": hops[0]["time"] if len(hops) >= 1 else None,
"hop_2": hops[1]["time"] if len(hops) >= 2 else None,
"hop_3": hops[2]["time"] if len(hops) >= 3 else None,
"hop_4": hops[3]["time"] if len(hops) >= 4 else None,
"hop_5": hops[4]["time"] if len(hops) >= 5 else None,
"hop_6": hops[5]["time"] if len(hops) >= 6 else None,
"hop_7": hops[6]["time"] if len(hops) >= 7 else None,
"hop_1_desc":
hops[0]["name"] if len(hops) >= 1 else None,
"hop_2_desc":
hops[1]["name"] if len(hops) >= 2 else None,
"hop_3_desc":
hops[2]["name"] if len(hops) >= 3 else None,
"hop_4_desc":
hops[3]["name"] if len(hops) >= 4 else None,
"hop_5_desc":
hops[4]["name"] if len(hops) >= 5 else None,
"hop_6_desc":
hops[5]["name"] if len(hops) >= 6 else None,
"hop_7_desc":
hops[6]["name"] if len(hops) >= 7 else None
}
})
if 'modules.plugins.cbpi-SimpleUtilitySteps' in sys.modules:
Step.insert(
**{
"name": "Measure Original Gravity",
"type": "SimpleManualStep",
"config": {
"heading": "Measure Original Gravity",
"message":
"what is the original gravity of the beer wort?",
"notifyType": "success",
"proceed": "Pause"
}
})
## Add Whirlpool step
Step.insert(**{
"name": "Whirlpool",
"type": "ChilStep",
"config": {
"timer": 15
}
})
if 'modules.plugins.cbpi-SimpleUtilitySteps' in sys.modules:
Step.insert(
**{
"name": "Save Logs",
"type": "SimpleSaveLogsStep",
"config": {}
})
StepView().reset()
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name,
message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe",
message=e.message,
type="danger")
return ('', 500)
return ('', 204)
def load(self, id):
if self.VerifyConfigurations() == False:
return
ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION = cbpi.get_config_parameter(
str(ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION),
str(FlowInAndMashInStepCreationEnum.DoNothing))
steps = self.getSteps(id)
boil_time_alerts = self.getBoilAlerts(id)
name = self.getRecipeName(id)
self.api.set_config_parameter("brew_name", name)
boil_time = self.getBoilTime(id)
mashInStep_type = cbpi.get_config_parameter("step_mashin",
MashStepTypes.MashinStep)
mashStep_type = cbpi.get_config_parameter("step_mash",
MashStepTypes.MashStep)
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 100 if cbpi.get_config_parameter("unit",
"C") == "C" else 212
# totalWaterAmount = self.getTotalWater(id)
spargeWaterAmount = self.getSpargeWaterVolume(id)
spargeTemperature = self.getSpargeTemperature(id)
# READ KBH DATABASE
# Don't erase existing steps if configurated. It allow us to merge recipes steps with equipament/process steps.
deleteSteps = cbpi.get_config_parameter(
ImportBehavior.CLEAR_RECIPE_ON_IMPORT, YesNo.Yes)
if deleteSteps == YesNo.Yes:
Step.delete_all()
StepView().reset()
try:
# MashSteps Only
for row in steps:
if row.get("type") == MashStepTypes.Flowmeter:
Step.insert(
**{
"name": row.get("name"),
"type": MashStepTypes.Flowmeter,
"config": {
"actorA": row.get("actorA"),
"sensor": row.get("sensor"),
"volume": float(row.get("volume")),
"resetFlowmeter": row.get("resetFlowmeter")
}
})
elif row.get("type") == MashStepTypes.MashinStep:
Step.insert(
**{
"name": row.get("name"),
"type": mashInStep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp"))
}
})
elif row.get("type") == MashStepTypes.MashStep:
Step.insert(
**{
"name": row.get("name"),
"type": mashStep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp")),
"timer": row.get("timer")
}
})
# pass
if self.PauseStepPluginIsInstalled() == True:
Step.insert(
**{
"name": "Pause for Sparge",
"type": "PauseStep",
"config": {
"initialMessage":
u"Sparge with %s of water at %s " %
(spargeWaterAmount, spargeTemperature),
"titleOfInitialMessage":
u"Sparge Insctruction",
"timer":
10
}
})
# Chil step need to be AFTER Boil!!!
# Step.insert(**{"name": "ChilStep",
# "type": "ChilStep",
# "config": {
# "timer": 15}
# })
## Add boiling step
Step.insert(
**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle":
boil_kettle,
"temp":
boil_temp,
"timer":
boil_time,
## Beer XML defines additions as the total time spent in boiling,
## CBP defines it as time-until-alert
## Also, The model supports five boil-time additions.
## Set the rest to None to signal them being absent
"hop_1":
boil_time - boil_time_alerts[0]
if len(boil_time_alerts) >= 1 else None,
"hop_2":
boil_time - boil_time_alerts[1]
if len(boil_time_alerts) >= 2 else None,
"hop_3":
boil_time - boil_time_alerts[2]
if len(boil_time_alerts) >= 3 else None,
"hop_4":
boil_time - boil_time_alerts[3]
if len(boil_time_alerts) >= 4 else None,
"hop_5":
boil_time - boil_time_alerts[4]
if len(boil_time_alerts) >= 5 else None
}
})
Step.insert(**{
"name": "ChilStep",
"type": "ChilStep",
"config": {
"timer": 15
}
})
## Add Whirlpool step
Step.insert(**{
"name": "Whirlpool",
"type": "ChilStep",
"config": {
"timer": 15
}
})
StepView().reset()
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name,
message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe",
message=e.message,
type="danger")
return ('', 500)
return ('', 204)
def getFlowMeterSensor(self):
flowMeterSensorName = cbpi.get_config_parameter(
"ADRI_FlowmeterSensor", None)
for idx, s in cbpi.cache.get("sensors").iteritems():
if s.name.lower() == flowMeterSensorName.lower():
return s.id
def getFlowMeterActor(self):
flowMeterActorName = cbpi.get_config_parameter("ADRI_FlowmeterActor",
None)
for idx, a in cbpi.cache.get("actors").iteritems():
if a.name.lower() == flowMeterActorName.lower():
return a.id
def getSteps(self, id):
e = xml.etree.ElementTree.parse(self.BEER_XML_FILE).getroot()
steps = []
totalWater = 0.0
unit = self.api.get_config_parameter("unit", "C")
if ((ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithStepInfusion
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithStepInfusionAndMashIn
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithTotalWater
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithTotalWaterAndMashIn)
and not self.FlowMeterPluginIsInstalled()):
cbpi.notify("Cannot found plugin Flowmeter",
"No Flowmeter step will be added during import.",
timeout=5000)
if ((ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithTotalWater
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithTotalWaterAndMashIn)
and self.FlowMeterPluginIsInstalled()):
totalWater = self.getTotalWater(id)
# Notify that no water elements were found on recipe
if totalWater > 0:
# Create a Flowmeter step
steps.append({
"name":
"Load Water(%s)" %
str(cbpi.get_config_parameter("ADRI_FlowmeterSensor",
None)),
"type":
MashStepTypes.Flowmeter,
"sensor":
self.getFlowMeterSensor(),
"actorA":
self.getFlowMeterActor(),
"volume":
totalWater,
"resetFlowmeter":
0
})
else:
cbpi.notify(
"Can't load water amounts from recipe",
"No water elements were found on recipe. Flowmeter step were not added.",
timeout=5000)
for e in e.findall('./RECIPE[%s]/MASH/MASH_STEPS/MASH_STEP' %
(str(id))):
if unit == "C":
temp = float(e.find("STEP_TEMP").text)
else:
temp = round(9.0 / 5.0 * float(e.find("STEP_TEMP").text) + 32,
2)
# Verify if there is a mashin step with water aditions
mashStepType = e.find('TYPE')
mashStepAmount = float(
str.replace(e.find('DISPLAY_INFUSE_AMT').text, " L", ""))
# create a mashin step, not a mashstep
if mashStepType is not None and mashStepType.text == "Infusion" and mashStepAmount is not None and mashStepAmount > 0:
if unit == "C":
infusionTemp = float(
e.find("INFUSE_TEMP").text.replace(" C", ""))
else:
infusionTemp = round(
9.0 / 5.0 *
float(e.find("INFUSE_TEMP").text.replace(" C", "")) +
32, 2)
if ((ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.FlowWithStepInfusion
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.
FlowWithStepInfusionAndMashIn)
and self.FlowMeterPluginIsInstalled()):
# Create a Flowmeter step
steps.append({
"name":
"Load Water(%s)" % str(
cbpi.get_config_parameter("ADRI_FlowmeterSensor",
None)),
"type":
MashStepTypes.Flowmeter,
"sensor":
self.getFlowMeterSensor(),
"actorA":
self.getFlowMeterActor(),
"volume":
mashStepAmount,
"resetFlowmeter":
0
})
# Add a mashin step with strike temp
if (ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.MashInOnly
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.
FlowWithStepInfusionAndMashIn
or ImportBehavior.FLOWIN_AND_MASHIN_STEP_CREATION
== FlowInAndMashInStepCreationEnum.
FlowWithTotalWaterAndMashIn):
steps.append({
"name": "Mash in",
"type": MashStepTypes.MashinStep,
"temp": infusionTemp
})
steps.append({
"name": e.find("NAME").text,
"type": MashStepTypes.MashStep,
"temp": temp,
"timer": float(e.find("STEP_TIME").text)
})
return steps
def load(self, id):
steps = self.getSteps(id)
name = self.getRecipeName(id)
self.api.set_config_parameter("brew_name", name)
boil_time = self.getBoilTime(id)
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 100 if cbpi.get_config_parameter("unit",
"C") == "C" else 212
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
try:
for row in steps:
Step.insert(
**{
"name": row.get("name"),
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp")),
"timer": row.get("timer")
}
})
Step.insert(**{
"name": "ChilStep",
"type": "ChilStep",
"config": {
"timer": 15
}
})
## Add cooking step
Step.insert(
**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle": boil_kettle,
"temp": boil_temp,
"timer": boil_time
}
})
## Add Whirlpool step
Step.insert(**{
"name": "Whirlpool",
"type": "ChilStep",
"config": {
"timer": 15
}
})
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name,
message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe",
message=e.message,
type="danger")
return ('', 500)
return ('', 204)
def load(self, id):
bm_recipe_creation = cbpi.get_config_parameter("bm_recipe_creation",
None)
self.api.notify(headline="Braumeister Recipe Upload",
message="Activated: %s" % bm_recipe_creation)
steps = self.getSteps(id)
boil_time_alerts = self.getBoilAlerts(id)
first_wort_alert = self.getFirstWortAlert(id)
name = self.getRecipeName(id)
self.api.set_config_parameter("brew_name", name)
boil_time = self.getBoilTime(id)
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
boil_temp = 99 if cbpi.get_config_parameter("unit",
"C") == "C" else 210
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
if bm_recipe_creation == "NO" or bm_recipe_creation is None:
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
else:
mashinstep_type = "BM_MashInStep"
mashstep_type = "BM_MashStep"
mashoutstep_type = "BM_ManualStep"
boilstep_type = "BM_BoilStep"
firstwortstep_type = "BM_ManualStep"
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
try:
if bm_recipe_creation == "NO" or bm_recipe_creation is None:
for row in steps:
Step.insert(
**{
"name": row.get("name"),
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp")),
"timer": row.get("timer")
}
})
Step.insert(
**{
"name": "ChilStep",
"type": "ChilStep",
"config": {
"timer": 15
}
})
First_Wort_Flag = len(first_wort_alert)
if First_Wort_Flag != 0:
Step.insert(
**{
"name": "First Wort Hopping",
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": 0,
"timer": 0
}
})
## Add boiling step
Step.insert(
**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle":
boil_kettle,
"temp":
boil_temp,
"timer":
boil_time,
## Beer XML defines additions as the total time spent in boiling,
## CBP defines it as time-until-alert
## Also, The model supports five boil-time additions.
## Set the rest to None to signal them being absent
"first_wort_hop":
'Yes' if First_Wort_Flag != 0 else 'No',
"hop_1":
boil_time_alerts[0]
if len(boil_time_alerts) >= 1 else None,
"hop_2":
boil_time_alerts[1]
if len(boil_time_alerts) >= 2 else None,
"hop_3":
boil_time_alerts[2]
if len(boil_time_alerts) >= 3 else None,
"hop_4":
boil_time_alerts[3]
if len(boil_time_alerts) >= 4 else None,
"hop_5":
boil_time_alerts[4]
if len(boil_time_alerts) >= 5 else None
}
})
## Add Whirlpool step
Step.insert(
**{
"name": "Whirlpool",
"type": "ChilStep",
"config": {
"timer": 15
}
})
StepView().reset()
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" %
name,
message="")
else:
MashIn_Flag = True
for row in steps:
if MashIn_Flag == True and row.get("timer") == 0:
Step.insert(
**{
"name": row.get("name"),
"type": mashinstep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp")),
"timer": row.get("timer")
}
})
MashIn_Flag = False
else:
Step.insert(
**{
"name": row.get("name"),
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": float(row.get("temp")),
"timer": row.get("timer")
}
})
## Add Step to remove malt pipe
Step.insert(
**{
"name": "Remove Malt Pipe",
"type": mashoutstep_type,
"config": {
"heading": "MashOut Step Completed!",
"message":
"Please remove Malt Pipe and Sparge. Press Next to continue",
"notifyType": "info",
"proceed": "Pause",
"kettle": mash_kettle
}
})
First_Wort_Flag = len(first_wort_alert)
## Add boiling step
Step.insert(
**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle":
boil_kettle,
"temp":
boil_temp,
"timer":
boil_time,
## Beer XML defines additions as the total time spent in boiling,
## CBP defines it as time-until-alert
## Also, The model supports five boil-time additions.
## Set the rest to None to signal them being absent
"first_wort_hop":
'Yes' if First_Wort_Flag != 0 else 'No',
"hop_1":
boil_time_alerts[0]
if len(boil_time_alerts) >= 1 else None,
"hop_2":
boil_time_alerts[1]
if len(boil_time_alerts) >= 2 else None,
"hop_3":
boil_time_alerts[2]
if len(boil_time_alerts) >= 3 else None,
"hop_4":
boil_time_alerts[3]
if len(boil_time_alerts) >= 4 else None,
"hop_5":
boil_time_alerts[4]
if len(boil_time_alerts) >= 5 else None
}
})
## Add Whirlpool step
Step.insert(
**{
"name": "Whirlpool",
"type": "ChilStep",
"config": {
"timer": 15
}
})
StepView().reset()
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" %
name,
message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe",
message=e.message,
type="danger")
return ('', 500)
return ('', 204)
def load(self, id):
bm_recipe_creation = cbpi.get_config_parameter("bm_recipe_creation",
None)
self.api.notify(headline="Braumeister Recipe Upload",
message="Activated: %s" % bm_recipe_creation)
if bm_recipe_creation == "YES" and KBH_VERSION == 2:
mashstep_type = "BM_MashStep"
mashinstep_type = "BM_MashInStep"
mashoutstep_type = "BM_ManualStep"
boilstep_type = "BM_BoilStep"
firstwortstep_type = "BM_ManualStep"
boil_temp = 99 if cbpi.get_config_parameter("unit",
"C") == "C" else 210
else:
mashstep_type = cbpi.get_config_parameter("step_mash", "MashStep")
mashinstep_type = cbpi.get_config_parameter(
"step_mashin", "MashInStep")
boilstep_type = cbpi.get_config_parameter("step_boil", "BoilStep")
boil_temp = 100 if cbpi.get_config_parameter("unit",
"C") == "C" else 212
chilstep_type = cbpi.get_config_parameter("step_chil", "ChilStep")
mash_kettle = cbpi.get_config_parameter("step_mash_kettle", None)
boil_kettle = cbpi.get_config_parameter("step_boil_kettle", None)
# READ KBH DATABASE
Step.delete_all()
StepView().reset()
conn = None
try:
conn = sqlite3.connect(self.api.app.config['UPLOAD_FOLDER'] +
'/kbh.db')
c = conn.cursor()
if KBH_VERSION == 1: # kbh database v1
c.execute(
'SELECT EinmaischenTemp, Sudname FROM Sud WHERE ID = ?',
(id, ))
row = c.fetchone()
name = row[1]
self.api.set_config_parameter("brew_name", name)
Step.insert(
**{
"name": "MashIn",
"type": mashinstep_type,
"config": {
"kettle": mash_kettle,
"temp": row[0]
}
})
for row in c.execute('SELECT * FROM Rasten WHERE SudID = ?',
(id, )):
Step.insert(
**{
"name": row[5],
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": row[3],
"timer": row[4]
}
})
Step.insert(**{
"name": "Chil",
"type": chilstep_type,
"config": {
"timer": 15
}
})
## Add cooking step
c.execute('SELECT max(Zeit) FROM Hopfengaben WHERE SudID = ?',
(id, ))
row = c.fetchone()
Step.insert(
**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle": boil_kettle,
"temp": boil_temp,
"timer": row[0]
}
})
else: # KBH Version 2 databse
c.execute('SELECT Sudname FROM Sud WHERE ID = ?', (id, ))
row = c.fetchone()
name = row[0]
self.api.set_config_parameter("brew_name", name)
c.execute(
'SELECT Temp FROM Rasten WHERE Typ = 0 AND SudID = ?',
(id, ))
row = c.fetchone()
Step.insert(
**{
"name": "MashIn",
"type": mashinstep_type,
"config": {
"kettle": mash_kettle,
"temp": row[0]
}
})
for row in c.execute(
'SELECT Name, Temp, Dauer FROM Rasten WHERE Typ <> 0 AND SudID = ?',
(id, )):
Step.insert(
**{
"name": row[0],
"type": mashstep_type,
"config": {
"kettle": mash_kettle,
"temp": row[1],
"timer": row[2]
}
})
## Add Step to remove malt pipe and eventually first wort hop step if BM recipe usage is defined
if bm_recipe_creation == "YES":
## Add Step to remove malt pipe
Step.insert(
**{
"name": "Remove Malt Pipe",
"type": mashoutstep_type,
"config": {
"heading": "MashOut Step Completed!",
"message":
"Please remove Malt Pipe and Sparge. Press Next to continue",
"notifyType": "info",
"proceed": "Pause",
"kettle": mash_kettle
}
})
## Check if first wort step needs to be added
first_wort_alert = self.getFirstWortAlert(id)
## Add boil step
boil_time_alerts = self.getBoilAlerts(id)
c.execute('SELECT Kochdauer FROM Sud WHERE ID = ?', (id, ))
row = c.fetchone()
## Add boiling step
Step.insert(
**{
"name": "Boil",
"type": boilstep_type,
"config": {
"kettle":
boil_kettle,
"temp":
boil_temp,
"timer":
row[0],
## Beer XML defines additions as the total time spent in boiling,
## CBP defines it as time-until-alert
## Also, The model supports five boil-time additions.
## Set the rest to None to signal them being absent
"first_wort_hop":
'Yes' if first_wort_alert == True else 'No',
"hop_1":
boil_time_alerts[0]
if len(boil_time_alerts) >= 1 else None,
"hop_2":
boil_time_alerts[1]
if len(boil_time_alerts) >= 2 else None,
"hop_3":
boil_time_alerts[2]
if len(boil_time_alerts) >= 3 else None,
"hop_4":
boil_time_alerts[3]
if len(boil_time_alerts) >= 4 else None,
"hop_5":
boil_time_alerts[4]
if len(boil_time_alerts) >= 5 else None
}
})
## Add Whirlpool step
Step.insert(
**{
"name": "Whirlpool",
"type": chilstep_type,
"config": {
"timer": 15
}
})
#setBrewName(name)
self.api.emit("UPDATE_ALL_STEPS", Step.get_all())
self.api.notify(headline="Recipe %s loaded successfully" % name,
message="")
except Exception as e:
self.api.notify(headline="Failed to load Recipe",
message=e.message,
type="danger")
return ('', 500)
finally:
if conn:
conn.close()
return ('', 204)