def FIND_SIDE(recipe):
'''finds the ingredients that go with a side dish recipe'''
rid = get_recipe_id(recipe)
intermediary.set_name(recipe)
intermediary.set_type(get_recipe_type(recipe))
# find the ingredients
IIDS = get_side_ingredients(rid)
INGREDIENTS = []
for iid in IIDS:
INGREDIENTS.append(get_ingredient_name(iid))
intermediary.set_ingredients(INGREDIENTS)
intermediary.set_recipe(get_recipe_text(recipe))
def Find_for_edit(recipe_name):
recipe_name = str(recipe_name).lower()
query = "select * from recipes where recipe_name = '%s'" % recipe_name
for row in cur.execute(query):
intermediary.set_name(recipe_name)
intermediary.set_meat(row[1])
intermediary.set_veggie1(row[2])
intermediary.set_veggie2(row[3])
intermediary.set_veggie3(row[4])
intermediary.set_veggie4(row[5])
intermediary.set_starch(row[6])
intermediary.set_recipe(row[7])
def FIND_MAIN(recipe):
'''finds the meat, veggies, and starch that go with a main dish recipe'''
rid = get_recipe_id(recipe)
intermediary.set_name(recipe)
intermediary.set_type(get_recipe_type(recipe))
#find the meat
mid = get_recipe_meat(rid)
if mid != 'None':
intermediary.set_meat(get_meat_name(get_recipe_meat(rid)))
#find the veggies
VEGGIES = []
VIDS = get_recipe_veggies(rid)
for vid in VIDS:
VEGGIES.append(get_veggie_name(vid))
intermediary.set_veggies(VEGGIES)
roar = intermediary.get_veggies()
#find the starch
sid = get_recipe_starch(rid)
if sid != None:
intermediary.set_starch(get_starch_name(sid))
#find the recipe
intermediary.set_recipe(get_recipe_text(recipe))