def test_prefix(self) -> None:
        """Test that the table prefix is correctly used to name tables in the database."""

        db_types = ["sqlite_file"]  # , "postgres", "mysql", "sqlite_memory"
        # sqlite_memory might have problems with multithreading of tests

        for db_type in db_types:
            with self.subTest(msg=f"prefix for {db_type}"):
                with clean_db(db_type, table_prefix="test_") as db:
                    _test_db_consistency(self, db)

                    # Check that we have the correct table names.
                    with db.engine.begin() as conn:
                        df = pd.read_sql(
                            "SELECT * FROM test_alembic_version", conn
                        )
                        print(df)
Test that the table prefix is correctly used to name tables in the database.
tests/integration/test_database.py