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