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())
