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)
