def add_item_to_list(gid, measurment, sid, session): userid = __get_userid_from_key(session) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if len(gid) == 0 or len(measurment) == 0 or len(sid) == 0: kwlog.log("Format of request is invaild") return "INVAILD_FORMAT" if not MySQL.is_vaild_group(gid): kwlog.log("Group ID is not vaild") return "INVAILD_GROUP" if not MySQL.is_vaild_shopping_list(sid, userid): kwlog.log("Invaild shopping list id") name = "%s list" % str(userid) createList.create_new_list(name, session) sid = MySQL.get_shopping_lists(userid)[0][0] if not MySQL.insert_item_to_list(sid, gid, measurment, userid): kwlog.log("Unable to add item to list") return "FAILED_TO_ADD_ITEM" else: return "ADD_ITEM_COMPLETE" return "INVAILD_SHOPPING_LIST" if not MySQL.insert_item_to_list(sid, gid, measurment, userid): kwlog.log("Unable to add item to list") return "FAILED_TO_ADD_ITEM" else: return "ADD_ITEM_COMPLETE"
def get_shopping_lists(session_key): userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: return __create_shopping_list(userid)
def get_item_list(session_key): # Get items for a userid # Return list kwlog.log("Get items for a user") userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Bad Session Key") return "BAD_KEY" else: user_list = __get_items_for_user(userid) return __create_response_list(user_list)
def remove_item(item_id, session_key): userid = __get_userid_from_key(session_key) item_id = int(item_id) if not __item_in_inventory(item_id, userid): kwlog.log("Item not in inventory") return False else: if __remove_item_from_db(item_id): kwlog.log("Item removed from DB") return True else: kwlog.log("Item failed to be removed") return False
def get_list_ID(session_key): userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: sid = MySQL.get_shopping_list_id_for_user(userid) if sid == "NONE": name = "%s list" % str(userid) createList.create_new_list(name, session_key) sid = MySQL.get_shopping_lists(userid)[0][0] print(sid) return str(sid)
def send_list(sid, session_key): userid = __get_userid_from_key(session_key) if userid == "BAD_KEY": kwlog.log("Invaild session key") return "BAD_KEY" if not MySQL.is_vaild_shopping_list(sid, userid): kwlog.log("Invaild Shopping List") return "BAD_LIST" if not __send_email(userid, sid): kwlog.log("Failed to send shopping list") return "SEND_FAILED" else: return "EMAIL_SENT"
def send_list(sid, session_key): userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" if not MySQL.is_vaild_shopping_list(sid, userid): kwlog.log("Invaild Shopping List") return "BAD_LIST" if not __send_email(userid, sid): kwlog.log("Failed to send shopping list") return "SEND_FAILED" else: return "EMAIL_SENT"
def update_recipe(rec_id, name, dis, image, prepT, cookT, items, itemAction, sessionkey): userid = __get_userid_from_key(sessionkey) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if len(itemAction) == 0 and len(items) > 0: return "INVAILD_FORMAT" elif not (itemAction == "ADD" or itemAction == "REMOVE" or itemAction == "UPDATE" or itemAction == ""): return "INVAILD_FORMAT" else: if MySQL.owned_by_user(userid, rec_id): if len(name) > 0: if not MySQL.update_recipe_name(name, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" if len(dis) > 0: if not MySQL.update_recipe_dis(dis, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" if len(image) > 0: if not MySQL.update_recipe_image(image, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" if len(prepT) > 0: if not MySQL.update_recipe_prep(prepT, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" if len(cookT) > 0: if not MySQL.update_recipe_cook(cookT, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" if len(itemAction) > 0: if itemAction == "ADD": if not MySQL.update_recipe_add_item(items, rec_id): kwlog.log("Add item to recipe failed") return "UPDATE_FAILED" elif itemAction == "REMOVE": if not MySQL.update_recipe_remove_item(items, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" else: if not MySQL.update_recipe_update_item(items, rec_id): kwlog.log("Update recipe name failed") return "UPDATE_FAILED" return "UPDATE_COMPLETE" else: return "BAD_REC_ID"
def create_new_list(name, sessionkey): if len(sessionkey) > 0: userid = __get_userid_from_key(sessionkey) else: return "INVAILD_FORMAT" if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if not len(name) > 0: return "INVAILD_FORMAT" if MySQL.create_new_shopping_list(name, userid): return "LIST_CREATED" else: return "FAILED_TO_CREATE_LIST"
def remove_all_items_from_list(rid, session): userid = __get_userid_from_key(session) print(rid) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if not MySQL.is_vaild_shopping_list(rid, userid): kwlog.log("List not owned by user") return "INVAILD_SHOPPING_LIST" else: if not MySQL.remove_all_items_from_shopping_list(rid): kwlog.log("Unable to remove items from list") return "UNABLE_TO_REMOVE_ITEMS" else: kwlog.log("Remove items complete") return "REMOVE_ITEMS_COMPLETE"
def remove_item_from_list(rid, gid, session): userid = __get_userid_from_key(session) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if not MySQL.is_vaild_group(gid): return "INVAILD_GROUP" if not MySQL.is_vaild_shopping_list(rid, userid): kwlog.log("List not owned by user") return "INVAILD_SHOPPING_LIST" else: if not MySQL.remove_item_from_shopping_list(gid, rid): return "UNABLE_TO_REMOVE_ITEM" else: return "REMOVE_ITEM_COMPLETE"
def get_list_of_ingredients(session_key, recipeid): try: userid = __get_userid_from_key(session_key) if userid == "BAD_KEY": kwlog.log("bad key") raise ingredients = get_ingredients_for_recipe(userid, recipeid) result = "" if ingredients is None: return "" for ingredient in ingredients: result += str(get_group_name_from_group_id(ingredient[0])[0])+ "-" + str(ingredient[1])+"\n" return result except: if kwlog.debug: raise return "Problem processing request"
def remove_recipe(recipe_id, session_key): userid = __get_userid_from_key(session_key) recipe_id = int(recipe_id) if not __recipe_in_inventory(recipe_id, userid): kwlog.log("Recipe not in inventory") return False else: if MySQL.remove_all_items_from_recipe(recipe_id): kwlog.log("removed all items") if __remove_recipe_from_db(recipe_id): kwlog.log("recipe removed from DB") return True else: kwlog.log("could not remove recipe") return False else: kwlog.log("failed to remove all items") return False
def get_list_of_recipes(session_key): try: userid = __get_userid_from_key(session_key) if userid == "BAD_KEY": kwlog.log("bad key") raise recipes = get_recipes_for_user(userid) recipe_arr = [] for recipe in recipes: recipe = list(recipe) recipe[7] = str(recipe[7]) recipe_arr.append(recipe) return recipe_arr except: if kwlog.debug: raise return "Problem processing request"
def remove_shopping_list(sid, session): if removeItem.remove_all_items_from_list(sid, session) == "REMOVE_ITEMS_COMPLETE": userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if len(sid) == 0: kwlog.log("Format of request is invaild") return "INVAILD_FORMAT" if not MySQL.is_vaild_shopping_list(sid, userid): kwlog.log("Invaild shopping list id") return "INVAILD_SHOPPING_LIST" if MySQL.remove_shopping_list(sid): return True else: return False else: return False
def remove_shopping_list(sid, session): if removeItem.remove_all_items_from_list( sid, session) == "REMOVE_ITEMS_COMPLETE": userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if len(sid) == 0: kwlog.log("Format of request is invaild") return "INVAILD_FORMAT" if not MySQL.is_vaild_shopping_list(sid, userid): kwlog.log("Invaild shopping list id") return "INVAILD_SHOPPING_LIST" if MySQL.remove_shopping_list(sid): return True else: return False else: return False
def add_recipe(session_key, recipe): # Adds a recipe for a user # Return string # recipe[] = [0:Name, 1:Discription, 2:[items], 3:image, 4:Prep Time, 5:Cook Time] # items[] = [gen_id, size] userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if (len(recipe[0]) > 0) and (len(recipe[1]) > 0) and (recipe[4] > 0) and (recipe[5] > 0): if not (__check_args(recipe)): return "INVAILD_FORMAT" if __create_recipe(recipe, userid): return "COMPLETE" else: return "FAILED_TO_ADD_RECIPE" else: return "BAD_ARGUMENTS"
def add_recipe(session_key, recipe): # Adds a recipe for a user # Return string # recipe[] = [0:Name, 1:Discription, 2:[items], 3:image, 4:Prep Time, 5:Cook Time] # items[] = [gen_id, size] userid = __get_userid_from_key(session_key) if userid == 'BAD_KEY': kwlog.log("Invaild session key") return "BAD_KEY" else: if (len(recipe[0]) > 0) and (len( recipe[1]) > 0) and (recipe[4] > 0) and (recipe[5] > 0): if not (__check_args(recipe)): return "INVAILD_FORMAT" if __create_recipe(recipe, userid): return "COMPLETE" else: return "FAILED_TO_ADD_RECIPE" else: return "BAD_ARGUMENTS"