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 api_add_user(): user_details = request.get_json() user_details_object = Users(user_details) db_session.add(user_details_object) db_session.commit() return { "id": user_details_object.uid, "msg": "user created successfully" }, 201
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 api_create_new_task(): # In post operation we first fetch the json received from client received_json = request.get_json() # Convert that Json into you object tasks_object = Tasks(received_json) tasks_object.tcreatedondate = datetime.now() db_session.add(tasks_object) db_session.commit() return {"id": tasks_object.tid, "msg": "task created"}, 201
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 useradd(): form = FormCreateUser() user_data = [] if form.validate_on_submit(): user_data.append(form.username.data) user_data.append(form.email.data) new_user = Users(user_data) db_session.add(new_user) db_session.commit() flash('You have been logged in!', 'success') return redirect(url_for('get_all_users')) else: flash('Login Unsuccessful. Please check username and password', 'danger') return render_template('useradd.html', title='Add User', form=form)
def api_upadate_task(id): task = Tasks.query.get(id) ttitle = request.json['ttitle'] tdesc = request.json['tdesc'] tcreatedbyuser = request.json['tcreatedbyuser'] tisdeleted = request.json['tisdeleted'] tisdone = request.json['tisdeleted'] task.tisdeleted = tisdeleted task.ttitle = ttitle task.tdesc = tdesc task.tcreatedbyuser = tcreatedbyuser task.tisdone = tisdone db_session.commit() return {"id": id, "msg": "task updated successfully"}
def taskadd(): form = FormCreateTask() data = [] isdeleted = False isdone = False creationdate = datetime.now() print(creationdate) if form.validate_on_submit(): data.append(form.username.data) data.append(form.title.data) data.append(form.description.data) data.append(isdeleted) data.append(isdone) data.append(creationdate) new_task = Tasks(data) db_session.add(new_task) db_session.commit() print(data) flash('You have been logged in!', 'success') return redirect(url_for('get_all_tasks')) else: flash('Login Unsuccessful. Please check username and password', 'danger') return render_template('taskadd.html', title='Add Task', form=form)