def api_get_all_tasks(): tasks = db_session.query(Tasks).all() task_list = [] for task in tasks: if not task.tisdeleted: task_list.append(task.serialize()) return jsonify(task_list)
def api_del_user(id): delete_user = db_session.query(Users).get(id) if delete_user is None: return {"msg": "user not found"} db_session.delete(delete_user) db_session.commit() return {"id": id, "msg": "user deleted successfully"}
def get_all_tasks(): tasks = db_session.query(Tasks).all() print("/n/n/n/n", tasks) task_list = [] for task in tasks: task_list.append(task.serialize()) return jsonify(task_list)
def api_get_all_users(): get_all_user_object = db_session.query(Users).all() if get_all_user_object == []: return {"msg": "no user found"} all_users_list = [] for users in get_all_user_object: all_users_list.append(users.serialize()) return jsonify(all_users_list)
def get_all_completed_tasks(): all_completed_tasks = db_session.query(Tasks).all() if all_completed_tasks is None: return '</h1>No completed task found</h1>' task_list = [] for task in all_completed_tasks: if task.tisdone is True and task.tisdeleted is False: task_list.append(task.serialize()) return render_template('completed_task.html', task_list=task_list)
def api_get_all_completed_tasks(): all_completed_tasks = db_session.query(Tasks).all() if all_completed_tasks is None: return {"msg": "no completed task found"} task_list = [] for task in all_completed_tasks: if task.tisdone is True and task.tisdeleted is False: task_list.append(task.serialize()) return jsonify(task_list)
def api_soft_delete(id): task_to_delete = db_session.query(Tasks).get(id) if task_to_delete is None: return {"msg": "task not found"} if task_to_delete.tisdeleted is True: return {"msg": "task not found"} task_to_delete.tisdeleted = True db_session.commit() return {"id": task_to_delete.tid, "msg": "task deleted successfully"}
def get_all_tasks(): tasks = db_session.query(Tasks).all() task_list = [] for task in tasks: # print(task.ttitle) if not task.tisdeleted: task_list.append(task.serialize()) print(task_list[0]) return render_template('home.html', task_list=task_list)
def api_test(id): task_by_id = db_session.query(Tasks).get(id) # if task_by_id is None: # return {"msg": "Task not found"} # print(task_by_id.serialize()) data = task_by_id.serialize() print(data['id']) # return 'none' return render_template('home.html', data='data')
def get_all_users(): get_all_user_object = db_session.query(Users).all() if get_all_user_object == []: return '<h1>no user found</h1>' all_users_list = [] for users in get_all_user_object: all_users_list.append(users.serialize()) return render_template('users.html', title='Users', all_users_list=all_users_list)
def api_task_as_done(id): task_obj = db_session.query(Tasks).get(id) if task_obj is None: return {"msg": "task not found"} if task_obj.tisdeleted is True: return {"msg": "You can not complete the tasks which are deleted"} task_obj.tisdone = True db_session.commit() return {"id": id, "msg": "task is completed"}
def api_hard_delete(id): delete_obj = db_session.query(Tasks).get(id) if delete_obj is None: return {"msg": "task not found"} if delete_obj.tisdeleted == True: db_session.delete(delete_obj) db_session.commit() return {"id": delete_obj.tid, "msg": "task deleted successfully"} else: return {"msg": "task can not be deleted first soft delete the task"}
def get_all_deleted_tasks(): all_del_task = db_session.query(Tasks).all() del_task_list = [] if all_del_task is None: return '<h1>No deleted task found1</h1>' for task in all_del_task: print(task.tisdeleted) if task.tisdeleted == False: continue del_task_list.append(task.serialize()) return render_template('deleted_task.html', del_task_list=del_task_list)
def api_get_all_deleted_tasks(): all_del_task = db_session.query(Tasks).all() del_task_list = [] if all_del_task is None: return {"msg": "no deleted task found1"} for task in all_del_task: print(task.tisdeleted) if task.tisdeleted == False: continue del_task_list.append(task.serialize()) return jsonify(del_task_list)
def api_get_user_by_id(id): user_object = db_session.query(Users).get(id) if user_object is None: return {"msg": "user not found"} return jsonify(user_object.serialize())
def api_get_task_by_id(id): task_by_id = db_session.query(Tasks).get(id) if task_by_id is None: return {"msg": "Task not found"} return jsonify(task_by_id.serialize())