def updateUserProfileById(self, userid, form):
dao = ResearcherDAO()
if not dao.getUserInformationById(userid):
return jsonify(Error="User not found"), 404
else:
if len(form) != 8:
return jsonify(Error="Malformed update request"), 400
else:
rname = form['rname']
rlast_name = form['rlast_name']
remail = form['remail']
rpassword = form['rpassword']
rvocation = form['rvocation']
rdepartment = form['rdepartment']
rinstitution = form['rinstitution']
rcity = form['rcity']
if rname and rlast_name and remail and rpassword and rvocation and rdepartment and rinstitution and rcity:
dao.updateUserProfileById(userid, rname, rlast_name,
remail, rpassword, rvocation,
rdepartment, rinstitution, rcity)
result = self.build_researcher_attributes(
userid, rname, rlast_name, remail, rpassword,
rvocation, rdepartment, rinstitution, rcity)
return jsonify(Researcher=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def getExperimentFromUserById(self, userid, experimentid):
dao = ResearcherDAO()
result = dao.getExperimentFromUserById(userid, experimentid)
if result is None:
return jsonify(Error="Experiment doesn't exist!")
else:
result_map = self.build_experiment_dict(result)
return jsonify(Users=result_map)
def getAllExperimentsFromUserById(self, userid):
dao = ResearcherDAO()
experiments_list = dao.getAllExperimentsFromUserById(userid)
result_map = []
for row in experiments_list:
result = self.build_experiment_dict(row)
result_map.append(result)
return jsonify(Experiments=result_map)
def getUserProfileById(self, userid):
dao = ResearcherDAO()
result = dao.getUserProfileById(userid)
if result is None:
return jsonify(Error="User doesn't exist!")
else:
result_map = self.build_researcher_dict(result)
return jsonify(Users=result_map)
def deleteUserById(self, userid):
dao = ResearcherDAO()
if not dao.getUserInformationById(userid):
return jsonify(Error="User not found."), 404
else:
self.deleteAllExperimentsFromUserById(userid)
dao.deleteUserById(userid)
return jsonify(DeleteStatus="OK"), 200
def getAllUsers(self):
dao = ResearcherDAO()
user_list = dao.getAllUsers()
result_map = []
for row in user_list:
result = self.build_researcher_dict(row)
result_map.append(result)
return jsonify(Users=result_map)
def loginResearcher(self, form):
if len(form) != 2:
return jsonify(Error="Malformed Post Request"), 400
else:
remail = form['remail']
rpassword = form['rpassword']
if remail and rpassword:
dao = ResearcherDAO()
result = dao.loginResearcher(remail, rpassword)
dict_map = self.build_researcher_dict(result)
return jsonify(User=dict_map)
else:
return jsonify(Error="Invalid email or password")
def storeExperimentFromUserById(self, userid, form):
dao = ResearcherDAO()
if len(form) != 4:
return jsonify(Error="Malformed post request"), 400
else:
rid = userid
ename = form['ename']
edescription = form['edescription']
etime = form['etime']
edate = form['edate']
if rid and ename and edescription and etime and edate:
eid = dao.storeExperimentFromUserById(rid, ename, edescription,
etime, edate)
result = self.build_experiment_attributes(
eid, rid, ename, edescription, etime, edate)
return jsonify(Experiment=result), 200
else:
return jsonify(
Error="Unexpected attributes in post request"), 400
def registerResearcher(self, form):
if len(form) != 8:
return jsonify(Error="Malformed Post Request"), 400
else:
rname = form['rname']
rlast_name = form['rlast_name']
remail = form['remail']
rpassword = form['rpassword']
rvocation = form['rvocation']
rdepartment = form['rdepartment']
rinstitution = form['rinstitution']
rcity = form['rcity']
if rname and rlast_name and remail and rpassword and rvocation and rdepartment and rinstitution and rcity:
dao = ResearcherDAO()
rid = dao.registerResearcher(rname, rlast_name, remail,
rpassword, rvocation, rdepartment,
rinstitution, rcity)
result = self.build_researcher_attributes(
rid, rname, rlast_name, remail, rpassword, rvocation,
rdepartment, rinstitution, rcity)
return jsonify(User=result), 201
else:
return jsonify(Error="Malformed Post Request"), 400
def updateExperimentInformationById(self, userid, experimentid, form):
dao = ResearcherDAO()
if not dao.getAllExperimentsFromUserById(userid):
return jsonify(Error="Experiment not found"), 404
else:
if len(form) != 4:
return jsonify(Error="Malformed update request"), 400
else:
ename = form['ename']
edescription = form['edescription']
etime = form['etime']
edate = form['edate']
if ename and edescription and etime and edate:
dao.updateExperimentInformationById(
userid, experimentid, ename, edescription, etime,
edate)
result = self.build_experiment_attributes(
userid, experimentid, ename, edescription, etime,
edate)
return jsonify(Experiment=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def deleteAllExperimentsFromUserById(self, userid):
dao = ResearcherDAO()
if not dao.getUserInformationById(userid):
return jsonify(Error="User not found."), 404
elif not dao.getAllExperimentsFromUserById(userid):
return jsonify(Error="No experiments found for this user."), 404
else:
if dao.getAllExperimentsFromUserById(userid):
experiment_table = dao.getAllExperimentsFromUserById(userid)
dao2 = ExperimentDAO()
for experiment in experiment_table:
dao2.deleteExperimentById(experiment[0])
return jsonify(DeleteStatus="OK"), 200
def deleteExperimentFromUserById(self, userid, experimentid):
dao = ResearcherDAO()
if not dao.getUserInformationById(userid):
return jsonify(Error="User not found."), 404
elif not dao.getAllExperimentsFromUserById(userid):
return jsonify(Error="No experiments found."), 404
else:
if dao.getAllPressurePointsFromMeasurementById(experimentid):
dao.deleteAllPressurePointsFromMeasurementById(experimentid)
if dao.getAllMeasurementsFromExperimentById(experimentid):
dao.deleteAllMeasurementsFromExperimentById(experimentid)
dao.deleteExperimentFromUserById(userid, experimentid)
return jsonify(DeleteStatus="OK"), 200