def insertUserJson(self, json): accounttypenumber = json['AccountTypeNumber'] firstname = json['FirstName'] lastname = json['LastName'] phone = json['Phone'] email = json['Email'] majornumber = json['MajorNumber'] aboutme = json['AboutMe'] yearofenrollment = json['YearofEnrollment'] creationdate = json['CreationDate'] lastlogin = json['LastLogin'] status = json['Status'] if accounttypenumber and firstname and lastname and phone and email and majornumber and aboutme and yearofenrollment and creationdate and lastlogin and status: dao = UserDao.UserDAO() userid = dao.insert(accounttypenumber, firstname, lastname, phone, email, majornumber, aboutme, yearofenrollment, creationdate, lastlogin, status) result = self.build_users_attributes(userid, accounttypenumber, firstname, lastname, phone, email, majornumber, aboutme, yearofenrollment, creationdate, lastlogin, status) return jsonify(Users=result), 201 else: return jsonify(Error="Unexpected attributes in post request"), 400
def updateUserJson(self, userid, json): dao = UserDao.UserDAO() if not dao.getUserById(userid): return jsonify(Error="Admin not found."), 404 else: accounttypenumber = json['AccountTypeNumber'] firstname = json['FirstName'] lastname = json['LastName'] phone = json['Phone'] email = json['Email'] majornumber = json['MajorNumber'] aboutme = json['AboutMe'] yearofenrollment = json['YearofEnrollment'] creationdate = json['CreationDate'] lastlogin = json['LastLogin'] status = json['Status'] if accounttypenumber and firstname and lastname and phone and email and majornumber and aboutme and yearofenrollment and creationdate and lastlogin and status: dao.update(accounttypenumber, firstname, lastname, phone, email, majornumber, aboutme, yearofenrollment, creationdate, lastlogin, status) result = self.build_users_attributes(userid, accounttypenumber, firstname, lastname, phone, email, majornumber, aboutme, yearofenrollment, creationdate, lastlogin, status) return jsonify(Users=result), 200
def deleteUser(self, userid): dao = UserDao.UserDAO() if not dao.getUserById(userid): return jsonify(Error="User not found."), 404 else: dao.delete(userid) return jsonify(DeleteStatus="OK"), 200
def getUserById(self, UserID): dao = UserDao.UserDAO() row = dao.getUserById(UserID) if not row: return jsonify(Error="User Not Found"), 404 else: users = self.build_users_dict(row) return jsonify(Users=users)
def getAllUsers(self): dao = UserDao.UserDAO() users_list = dao.getAllUsers() result_list = [] for row in users_list: result = self.build_users_dict(row) result_list.append(result) return jsonify(Users=result_list)
def insertUserSignUpJson(self, json): accounttypenumber = 1 firstname = json['FirstName'] lastname = json['LastName'] email = json['Email'] if firstname and lastname and email: phone = 0000000000 majornumber = 0 aboutme = '' yearofenrollment = 0000 creationdate = 0000 lastlogin = 0000 status = 1 dao = UserDao.UserDAO() userid = dao.insert(accounttypenumber, firstname, lastname, phone, email, majornumber, aboutme, yearofenrollment, creationdate, lastlogin, status) result = self.build_usersSignUp_attributes(userid) return jsonify(Users=result), 201 else: return jsonify(Error="Unexpected attributes in post request"), 400