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