aboutsummaryrefslogtreecommitdiff
path: root/tests/test_migration_env.py
blob: 7ae09bbdc5421b2bd5d529b1e5c4163bd56e6f00 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
# 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()