aboutsummaryrefslogtreecommitdiff
path: root/tests/test_migration_env.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/test_migration_env.py')
-rw-r--r--tests/test_migration_env.py57
1 files changed, 57 insertions, 0 deletions
diff --git a/tests/test_migration_env.py b/tests/test_migration_env.py
new file mode 100644
index 0000000..07462dc
--- /dev/null
+++ b/tests/test_migration_env.py
@@ -0,0 +1,57 @@
+# SPDX-FileCopyrightText: 2026 Dennis Fink <me+coding@dennisfink.me>
+#
+# 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()