Пример #1
0
def update_task(id_task):

    if request.method == "POST":

        # query for check id task
        query_db = db.read("tasks", "id", id_task)
        task = query_db[0] if len(query_db) == 1 else None
        if task == None:
            return jsonify(error(404, "Task not exists"))

        else:
            json = request.get_json()

            id = task["id"]
            title = json["title"]
            description = json["description"]
            date = task["date"]
            id_list = task["id_list"]
            status = json["status"]

            task = Task(
                id=id,
                id_list=id_list,
                title=title,
                description=description,
                date=date,
                status=status,
            )

            if db.update("tasks", id_task, task.to_dict()):
                return jsonify(task.to_dict())

            else:
                return jsonify(error(203, "Not Allowed"))
Пример #2
0
def delete_list(id_list):
    if request.method == "DELETE":
        # query for check list
        query_db = db.read("lists", "id", id_list)
        list_user = query_db[0] if len(query_db) == 1 else None
        if list_user == None:
            return jsonify(error(404, "List not exists"))

        else:
            if db.delete("lists", id_list):

                # delete all tasks
                tasks = db.read("tasks", "id_list", id_list)
                if len(tasks) > 0:
                    for task in tasks:
                        db.delete("tasks", task["id"])

                return jsonify(error(200, "Removed"))

            else:
                return jsonify(error(400, "Not removed"))
Пример #3
0
def delete_task(id_task):
    if request.method == "DELETE":
        # query for check task
        query_db = db.read("tasks", "id", id_task)
        task = query_db[0] if len(query_db) == 1 else None
        if task == None:
            return jsonify(error(404, "Task not exists"))

        else:
            if db.delete("tasks", id_task):

                return jsonify(error(200, "Removed"))

            else:
                return jsonify(error(400, "Not removed"))
Пример #4
0
def update_list(id_list):
    if request.method == "POST":
        # query for check username
        query_db = db.read("lists", "id", id_list)
        list_user = query_db[0] if len(query_db) == 1 else None
        if list_user == None:
            return jsonify(error(404, "List not exists"))

        else:
            json = request.get_json()

            id = list_user["id"]
            title = json["title"]
            date = list_user["date"]
            id_user = list_user["id_user"]
            link = list_user["link"]

            list_user = List(id, id_user, title, date)

            if db.update("lists", id_list, list_user.to_dict()):
                return jsonify(list_user.to_dict())

            else:
                return jsonify(error(203, "Not Allowed"))
Пример #5
0
def get_list(id_list):
    return jsonify(db.read("lists", "id", id_list))
Пример #6
0
def get_lists_by_user(id_user):
    return jsonify(db.read("lists", "id_user", id_user))
Пример #7
0
def get_tasks_by_list(id_list):
    return jsonify(db.read("tasks", "id_list", id_list))
Пример #8
0
def get_task(id_task):
    return jsonify(db.read("tasks", "id", id_task))