def getAllReplies(self):
dao = ReplyDAO()
dao1 = MessageDAO()
dao2 = MessageDAO()
userDAO = UserDAO()
chatDAO = ChatDAO()
result = dao.getAllReplies()
mapped_result = []
for r in result:
reply_info = []
result1 = dao1.getMessageById(r[0]) # array de mensaje-reply
result2 = dao2.getMessageById(r[1]) # array de mensaje original
reply_info.append(result1[1]) #replyer_text
reply_info.append(result2[1]) #original_text
# buscar user con user id
# result1[3] - replyer_id
replyer = userDAO.getUserById(result1[3])
reply_info.append(replyer[1] + ' ' +replyer[2])
# buscar chat con chat id
# result1[4] - chat_id
chat_name = chatDAO.getChatById(result1[4])
reply_info.append(chat_name[1])
reply_info.append(result1[2]) #reply_date
reply_info.append(result2[2]) #original_message_date
mapped_result.append(self.mapToDict(reply_info))
return jsonify(Replies=mapped_result)
def getChatByID(self, id):
dao = ChatDAO()
result = dao.getChatById(id)
if result == None:
return jsonify(Error="CHAT NOT FOUND")
else:
mapped = self.mapToDict(result)
return jsonify(Chat=mapped)
def getAllMemberships(self):
dao = MemberDAO()
dao1 = UserDAO()
dao2 = ChatDAO()
result = dao.getAllMemberships()
mapped_result = []
for r in result:
result2 = dao1.getUserById(r[0])
result3 = dao2.getChatById(r[1])
r[0] = result2[1] + " " + result2[2]
r[1] = result3[1]
mapped_result.append(self.mapToDict(r))
return jsonify(Members=mapped_result)
def getMembershipByUID(self, user_id):
dao = MemberDAO()
dao1 = UserDAO()
dao2 = ChatDAO()
result = dao.getMembershipByUserID(user_id)
if result == None:
return jsonify(Error="MEMBERSHIP NOT FOUND")
else:
mapped_result = []
for r in result:
result2 = dao1.getUserById(r[0])
result3 = dao2.getChatById(r[1])
r[0] = result2[1] + " " + result2[2]
r[1] = result3[1]
mapped_result.append(self.mapToDict(r))
return jsonify(Members=mapped_result)
def getChatsAdministratedByUser(self, user_id):
dao = AdminDAO()
dao1 = UserDAO()
dao2 = ChatDAO()
result = dao.getChatsAdministratedByUser(user_id)
if result == None:
return jsonify(Error="CHAT NOT FOUND")
else:
mapped_result = []
for r in result:
result2 = dao1.getUserById(r[0])
result3 = dao2.getChatById(r[1])
r[0] = result2[1] + " " + result2[2]
r[1] = result3[1]
mapped_result.append(self.mapToDict(r))
return jsonify(Admins=mapped_result)
def getAdminByChatID(self, chat_id):
dao = AdminDAO()
dao1 = UserDAO()
dao2 = ChatDAO()
result = dao.getAdminsByChatID(chat_id)
# print(result)
if result == None:
return jsonify(Error="ADMIN NOT FOUND")
else:
mapped_result = []
for r in result:
result2 = dao1.getUserById(r[0])
result3 = dao2.getChatById(r[1])
r[0] = result2[1] + " " + result2[2]
r[1] = result3[1]
mapped_result.append(self.mapToDict(r))
return jsonify(Admins=mapped_result)