def insertUser(self, form):
print("form: ", form)
if len(form) != 9:
return jsonify(Error="Malformed post request"), 400
else:
username = form['UserName']
password = form['Password']
email = form['Email']
cardid = form['CardID']
ulocation = form['ULocation']
firstname = form['FirstName']
lastname = form['LastName']
dateofbirth = form['DateofBirth']
gender = form['Gender']
if username and password and email and cardid and ulocation and firstname and lastname and dateofbirth and gender:
dao = UsersDAO()
userid = dao.insert(username, password, email, cardid,
ulocation, firstname, lastname,
dateofbirth, gender)
result = self.build_users_attributes(userid, username,
password, email, cardid,
ulocation, firstname,
lastname, dateofbirth,
gender)
return jsonify(Users=result), 201
else:
return jsonify(
Error="Unexpected attributes in post request"), 400
def deleteUser(self, uid):
dao = UsersDAO()
if not dao.getUserById(uid):
return jsonify(Error="User not found."), 404
else:
dao.delete(uid)
return jsonify(DeleteStatus="OK"), 200
def updateUser(self, userid, form):
dao = UsersDAO()
if not dao.getUserById(userid):
return jsonify(Error="User not found."), 404
else:
if len(form) != 4:
return jsonify(Error="Malformed update request"), 400
else:
username = form['UserName']
password = form['Password']
email = form['Email']
cardid = form['CardID']
ulocation = form['ULocation']
firstname = form['FirstName']
lastname = form['LastName']
dateofbirth = form['DateofBirth']
gender = form['Gender']
if username and password and email and cardid and ulocation and firstname and lastname and dateofbirth and gender:
dao.update(username, password, email, cardid, ulocation,
firstname, lastname, dateofbirth, gender)
result = self.build_users_attributes(
username, password, email, cardid, ulocation,
firstname, lastname, dateofbirth, gender)
return jsonify(Users=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def deleteContact(self, uid, cid):
dao = UsersDAO()
if not dao.getContact(uid, cid):
return jsonify(Error="Part not found."), 404
else:
dao.deleteContact(uid, cid)
return jsonify(DeleteStatus="OK"), 200
def insertUser(self, form):
print(len(form))
if len(form) != 7:
return jsonify(Error="Malformed post request"), 400
else:
username = form['username']
lastname = form['lastName']
firstname = form['firstName']
password = form['password']
phone = form['phone']
email = form['email']
#isAdmin = form['isAdmin']
address1 = form['address']['address1']
address2 = form['address']['address2']
zipcode = form['address']['zipcode']
region = form['address']['region']
country = form['address']['country']
city = form['address']['city']
if username and lastname and firstname and password and address1 and zipcode and region and country and city and email and phone:
dao = UsersDAO()
dao2 = AddressesDAO()
add_id = dao2.insert(address1, address2, zipcode, region,
country, city)
uid = dao.insert(username, lastname, firstname, password,
email, phone, add_id)
result = User().build_dict_from_row(dao.getUserById(uid))
return jsonify(result), 201
else:
return jsonify(
Error="Unexpected attributes in post request"), 400
def getAllUsers(self):
dao = UsersDAO()
result = dao.getAllUsers()
mapped_result = []
for r in result:
mapped_result.append(self.users_dict(r))
return jsonify(Users=mapped_result)
def getUserContactsById(self, uid):
dao = UsersDAO()
contact_list = dao.getUserContactsById(uid)
result_list = []
for row in contact_list:
result = self.build_user_dict(row)
result_list.append(result)
return jsonify(Contacts=result_list)
def getUserByLocation(self, ULocation):
dao = UsersDAO()
row = dao.getUserById(ULocation)
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 = UsersDAO()
users_list = dao.getAllUsers()
result_list = []
for row in users_list:
result = self.build_user_dict(row)
result_list.append(result)
return jsonify(Users=result_list)
def getAllUsers(self):
dao = UsersDAO()
user_list = dao.getAllUsers()
results = []
for row in user_list:
element = self.buildUserAttributes(row)
results.append(element)
return jsonify(Users=results), 200
def getDislikersByMessageId(self, mid):
dao = UsersDAO()
users_list = dao.getDislikersByMessageId(mid)
result_list = []
for row in users_list:
result = self.build_reaction_dict(row)
result_list.append(result)
return jsonify(Dislikers=result_list)
def showAllSuppliers(self):
dao = UsersDAO()
request_list = dao.showAllSuppliers()
result_list = []
for row in request_list:
result = self.build_user_dict(row)
result_list.append(result)
return jsonify(Suppliers=result_list)
def showSupplier(self, uid):
dao = UsersDAO()
row = dao.showSupplier(uid)
if not row:
return jsonify(Error = "Supplier Not Found"), 404
else:
supplier = self.build_user_dict(row)
return jsonify(Supplier = supplier)
def getAllUserTypes(self):
dao = UsersDAO()
location_list = dao.getAllUserTypes()
result_list = []
for row in location_list:
result = self.build_userType_dict(row)
result_list.append(result)
return jsonify(UserType=result_list)
def getUserRequestsByRequestID(self, rid):
dao = UsersDAO()
row = dao.getUserRequestsByRequestID(rid)
if not row:
return jsonify(Error="Request Not Found"), 404
else:
user = self.build_userRequest_dict(row)
return jsonify(User=user)
def getUserTypeByID(self, utid):
dao = UsersDAO()
row = dao.getUserTypeByID(utid)
if not row:
return jsonify(Error="User Type Not Found"), 404
else:
userType = self.build_userType_dict(row)
return jsonify(UserType=userType)
def getMembersByGroupId(self, gid):
dao = UsersDAO()
member_list = dao.getMembersByGroupId(gid)
result_list = []
for row in member_list:
result = self.build_user_dict(row)
result_list.append(result)
return jsonify(Members=result_list)
def chatOwner(self, cid):
dao = UsersDAO()
user_list = dao.chatOwner(cid)
result_list = []
for row in user_list:
result = self.build_user_dict(row)
result_list.append(result)
return jsonify(Users=result_list)
def getOwnerByGroupId(self, gid):
dao = UsersDAO()
row = dao.getOwnerByGroupId(gid)
if not row:
return jsonify(Error="Group Not Found"), 404
else:
owner = self.build_user_dict(row)
return jsonify(Owner=owner)
def chatOwner(self, cid):
dao = UsersDAO()
row = dao.chatOwner(cid)
if not row:
return jsonify(Error="User Not Found"), 404
else:
user = self.build_members(row)
return jsonify(User=user)
def getUserByID(self, id):
dao = UsersDAO()
result = dao.getUserById(id)
if result == None:
return jsonify(Error="USER NOT FOUND")
else:
mapped_results = self.users_dict(result)
return jsonify(User=mapped_results)
def getUserById(self, uid):
dao = UsersDAO()
row = dao.getUserById(uid)
if not row:
return jsonify(Error="User Not Found"), 404
else:
user = User().build_dict_from_row_noAdmin(row)
return jsonify(user)
def getInfoById(self, uid):
dao = UsersDAO()
row = dao.getUserById(uid)
if not row:
return jsonify(Error="User Not Found"), 404
else:
user = self.build_user_dict(row)
return jsonify(User=user)
def getUserByName(self, first_name, last_name):
dao = UsersDAO()
result = dao.getUserByName(first_name, last_name)
if result == None:
return jsonify(Error="USER NOT FOUND")
else:
mapped_results = self.users_dict(result)
return jsonify(User=mapped_results)
def getAllUserChats(self, uid):
dao = UsersDAO()
user_list = dao.getAllUserChats(uid)
result_list = []
for row in user_list:
result = self.build_user_chats(row)
result_list.append(result)
return jsonify(Chats=result_list)
def getUserByFirstName(self, first_name):
dao = UsersDAO()
row = dao.getUserByFirstName(first_name)
if not row:
return jsonify(Error="User Not Found"), 404
else:
user = self.build_user_dict(row)
return jsonify(User=user)
def getUserByUName(self, uname):
dao = UsersDAO()
result = dao.getUserByUName(uname)
if not result:
return jsonify(Error='User not found.'), 404
else:
user = self.buildUserAttributes(result)
return jsonify(User=user), 200
def getUserByEmail(self, email):
dao = UsersDAO()
row = dao.getUserByEmail(email)
if not row:
return jsonify(Error="User Not Found"), 404
else:
user = self.build_user_dict(row)
return jsonify(User=user)
def getUserById(self, uID):
dao = UsersDAO()
row = dao.getUserById(uID)
if not row:
return jsonify(Error="User not found"), 404
else:
user = self.build_user_dict(row)
return jsonify(User=user)
def login(self, email, password):
dao = UsersDAO()
row = dao.login(email, password)
if not row:
return jsonify(Error="Wrong email or password"), 404
else:
uid = self.buid_user_id_dict(row)
return jsonify(User=uid)
