def sendMessage(self, receiverId, senderId, message):
self.myCursor = self.connection.cursor()
userController = UserController(self.connection)
self.myCursor.execute(
"INSERT INTO Message(receiverId, senderId, message) VALUES(%s, %s, %s);",
(receiverId, senderId, message))
self.connection.commit()
self.myCursor.execute(
"SELECT * from message where (receiverId = %s and senderId = %s) or (receiverId = %s and senderId = %s) ORDER BY id;",
(receiverId, senderId, senderId, receiverId))
resultSet = self.myCursor.fetchall()
if resultSet != []:
for chat in resultSet:
receiver = userController.findById(chat[0])
sender = userController.findById(chat[1])
receiverName = receiver.getName()
senderName = sender.getName()
conversation = senderName + " to " + receiverName + ": " + chat[
3]
print(conversation)
conversation = ''
# receiverName = testUserController.findUserById(chat[0]).getName()
# senderName = testUserController.findUserById(chat[1]).getName()
# print(f"{senderName} to {receiverName}: {message.getMessage()}.\n")
return None
def findConversationBetweenSenderAndReceiver(self, receiverId, senderId):
# userController = UserController(self.connection)
# receiver = userController.findUserById(receiverId)
# sender = userController.findUserById(senderId)
userController = UserController(self.connection)
self.myCursor = self.connection.cursor()
self.myCursor.execute(
"SELECT receiverId, senderId, message from message where (receiverId = %s and senderId = %s) or (receiverId = %s and senderId = %s) ORDER BY id;",
(receiverId, senderId, senderId, receiverId))
resultSet = self.myCursor.fetchall()
if resultSet != []:
for chat in resultSet:
receiver = userController.findById(chat[0])
sender = userController.findById(chat[1])
receiverName = receiver.getName()
senderName = sender.getName()
message = receiverName + " to " + senderName + ": " + chat[2]
print(message)
message = ""
return None
