def get_all_messages(sender, receiver):
view = []
try:
mycursor = DBManager.getCursor()
mycursor.execute("SELECT * FROM messages WHERE (sender_username = %(sender)s AND receiver_username = %(receiver)s) " +
"OR (receiver_username = %(sender)s AND sender_username = %(receiver)s)" +
"ORDER BY sending_date ASC", { 'sender': sender,
'receiver': receiver})
view = mycursor.fetchall()
DBManager.closeConnection()
except Exception as error:
print(f'error in get_all_messages: {str(error)}')
return view
def get_all_chats(sender_username):
view = []
try:
mycursor = DBManager.getCursor()
mycursor.execute("SELECT d.username FROM dogs d " +
"INNER JOIN likes l ON l.dog_id = d.dog_id " +
"WHERE l.username=%(sender)s " +
"AND d.dog_id NOT IN (SELECT dog_id FROM adopted) " +
"AND d.username <> %(sender)s " +
"AND l.answer='yes'" +
"UNION " +
"SELECT l.username FROM dogs d " +
"INNER JOIN likes l ON l.dog_id = d.dog_id " +
"WHERE d.username=%(sender)s " +
"AND l.username <> %(sender)s " +
"AND l.answer='yes'" +
"AND d.dog_id NOT IN (SELECT dog_id FROM adopted) " +
"ORDER BY 1 ASC", { 'sender': sender_username, })
view = mycursor.fetchall()
DBManager.closeConnection()
except Exception as error:
print(f'error in get_all_chats: {str(error)}')
return view