# SPDX-FileCopyrightText: 2026 Dennis Fink # # SPDX-License-Identifier: BSD-3-Clause """Test Alembic's offline configuration and legacy Flask-SQLAlchemy fallback.""" import runpy from contextlib import nullcontext from pathlib import Path from types import SimpleNamespace from unittest.mock import Mock import pytest from alembic import context from flask import Flask def test_offline_migration_uses_legacy_engine_url_and_metadata( app: Flask, monkeypatch: pytest.MonkeyPatch ) -> None: class LegacyURL: def __str__(self) -> str: return "sqlite:///legacy%20database.sqlite" metadata = object() legacy_db = SimpleNamespace( engine=SimpleNamespace(url=LegacyURL()), metadata=metadata ) config = Mock() config.get_main_option.return_value = "sqlite:///offline.sqlite" configure = Mock() run_migrations = Mock() with app.app_context(), monkeypatch.context() as patcher: patcher.setattr(app.extensions["migrate"], "db", legacy_db) patcher.setattr(context, "config", config, raising=False) patcher.setattr(context, "is_offline_mode", Mock(return_value=True)) patcher.setattr(context, "configure", configure, raising=False) patcher.setattr(context, "begin_transaction", lambda: nullcontext()) patcher.setattr(context, "run_migrations", run_migrations, raising=False) runpy.run_path( str(Path(__file__).parents[1] / "webmentions_ssg" / "migrations" / "env.py") ) config.set_main_option.assert_called_once_with( "sqlalchemy.url", "sqlite:///legacy%%20database.sqlite" ) configure.assert_called_once_with( url="sqlite:///offline.sqlite", target_metadata=metadata, literal_binds=True ) run_migrations.assert_called_once_with()