def __create_shopping_list(userid): final = [] slist = MySQL.get_shopping_lists(userid) for s in slist: k = [s[0], s[1], __get_list(s[0]), s[2], str(s[3])] final.append(list(k)) return list(final)
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_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)