def test_table_creation(self):
        """Test if the tables are created in the database"""
        conn = sqlite3.connect(self.db_file)
        cursor = conn.cursor()

        # Check if ChatSessions table exists
        cursor.execute("""
            SELECT count(name) FROM sqlite_master WHERE type='table' AND name='ChatSessions'
        """)
        self.assertEqual(cursor.fetchone()[0], 1)

        # Check if Messages table exists
        cursor.execute("""
            SELECT count(name) FROM sqlite_master WHERE type='table' AND name='Messages'
        """)
        self.assertEqual(cursor.fetchone()[0], 1)

        conn.close()
Test if the tables are created in the database
test/chatsession_test.py