Python MySQL.get_shopping_lists 예제들

예제 #1

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)

예제 #2

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"

예제 #3

파일: addItem.py 프로젝트: KitchenWizard/Backend

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"

예제 #4

파일: getListID.py 프로젝트: KitchenWizard/Backend

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)

예제 #5

파일: getListID.py 프로젝트: mr7657/Backend

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)