def test_insert_and_get_message(self):
        """Test if we can insert and retrieve a message"""
        message_id = "message1"
        session_id = "session1"
        sender_id = "user1"
        receiver_id = "user2"
        timestamp = "2023-08-28 12:30:00"
        content = "Hello, world!"
        status = 0

        self.chat_db.insert_message(message_id, session_id, sender_id, receiver_id, timestamp, content, status)
        message = self.chat_db.get_message_by_id(message_id)

        self.assertEqual(message, (message_id, session_id, sender_id, receiver_id, timestamp, content, status))
Test if we can insert and retrieve a message
test/chatsession_test.py