2026-09-20 02:01:08 +08:00
|
|
|
|
"""Migration runner coverage: discovery order, registration, idempotency,
|
2026-10-23 09:30:02 +00:00
|
|
|
|
and failure propagation. Runs the REAL migrations (001-008) against an
|
2026-09-20 02:01:08 +08:00
|
|
|
|
in-memory database — the same code path a deployment upgrade takes.
|
|
|
|
|
|
"""
|
|
|
|
|
|
import pytest
|
|
|
|
|
|
from tortoise import Tortoise
|
|
|
|
|
|
|
|
|
|
|
|
from core.database import execute_migrations
|
|
|
|
|
|
from tests.helpers import MEMORY_DB_CONFIG, close_db
|
|
|
|
|
|
|
2026-10-23 09:30:02 +00:00
|
|
|
|
EXPECTED = [f"migrations_{i:03d}.py" for i in range(1, 9)]
|
2026-09-20 02:01:08 +08:00
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@pytest.fixture
|
|
|
|
|
|
async def fresh_db():
|
|
|
|
|
|
"""全新内存库:不 generate_schemas(schema 由迁移本身建立——部署真实形态),
|
|
|
|
|
|
只建 runner 依赖的 migrates 登记表。"""
|
|
|
|
|
|
from tortoise import Tortoise
|
|
|
|
|
|
|
|
|
|
|
|
import apps.base.config as config_module
|
|
|
|
|
|
|
|
|
|
|
|
config_module._config_cached_until = 0.0
|
|
|
|
|
|
if Tortoise._inited:
|
|
|
|
|
|
await Tortoise.close_connections() # 清掉前一个用例的 :memory: 连接
|
|
|
|
|
|
await Tortoise.init(config=MEMORY_DB_CONFIG)
|
|
|
|
|
|
await Tortoise.get_connection("default").execute_script(
|
|
|
|
|
|
"CREATE TABLE IF NOT EXISTS migrates ("
|
|
|
|
|
|
"id INTEGER PRIMARY KEY AUTOINCREMENT, "
|
|
|
|
|
|
"migration_file VARCHAR(255) NOT NULL UNIQUE, "
|
|
|
|
|
|
"executed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP)"
|
|
|
|
|
|
)
|
|
|
|
|
|
yield
|
|
|
|
|
|
await close_db()
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
async def _registered() -> list[str]:
|
|
|
|
|
|
conn = Tortoise.get_connection("default")
|
|
|
|
|
|
_, rows = await conn.execute_query(
|
|
|
|
|
|
"SELECT migration_file FROM migrates ORDER BY id"
|
|
|
|
|
|
)
|
|
|
|
|
|
return [row[0] for row in rows]
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
@pytest.mark.asyncio
|
|
|
|
|
|
class TestMigrationRunner:
|
|
|
|
|
|
async def test_full_run_executes_all_in_filename_order(self, fresh_db):
|
|
|
|
|
|
await execute_migrations()
|
|
|
|
|
|
registered = await _registered()
|
|
|
|
|
|
assert registered == EXPECTED, "迁移必须按文件名序完整执行并登记"
|
|
|
|
|
|
|
|
|
|
|
|
async def test_rerun_is_idempotent(self, fresh_db):
|
|
|
|
|
|
"""重复执行:已登记的迁移全部跳过,登记不重复。"""
|
|
|
|
|
|
await execute_migrations()
|
|
|
|
|
|
before = await _registered()
|
|
|
|
|
|
await execute_migrations()
|
|
|
|
|
|
after = await _registered()
|
|
|
|
|
|
assert after == before == EXPECTED
|
|
|
|
|
|
|
|
|
|
|
|
async def test_pre_registered_subset_skips_those(self, fresh_db):
|
|
|
|
|
|
"""部分已登记(模拟中途升级):只执行缺口,顺序保持。"""
|
|
|
|
|
|
conn = Tortoise.get_connection("default")
|
|
|
|
|
|
await conn.execute_query("DELETE FROM migrates")
|
2026-10-23 09:30:02 +00:00
|
|
|
|
# 预登记 006/007/008(模拟已执行过末尾迁移的库),验证 runner 只跑缺口
|
|
|
|
|
|
# 001-005 且跳过已登记的 006/007/008(跳过语义 = 不再执行其 DDL)
|
|
|
|
|
|
for name in EXPECTED[-3:]:
|
2026-09-20 02:01:08 +08:00
|
|
|
|
await conn.execute_query(
|
|
|
|
|
|
"INSERT INTO migrates (migration_file) VALUES (?)", [name]
|
|
|
|
|
|
)
|
|
|
|
|
|
await execute_migrations()
|
|
|
|
|
|
registered = await _registered()
|
2026-10-23 09:30:02 +00:00
|
|
|
|
# 预登记的 006/007/008 占据登记序前列——断言用集合:全部登记、无重复
|
2026-09-20 02:01:08 +08:00
|
|
|
|
assert sorted(registered) == sorted(EXPECTED)
|
|
|
|
|
|
assert len(registered) == len(EXPECTED)
|
|
|
|
|
|
tables = {
|
|
|
|
|
|
row[0]
|
|
|
|
|
|
for row in (
|
|
|
|
|
|
await conn.execute_query(
|
|
|
|
|
|
"SELECT name FROM sqlite_master WHERE type='table'"
|
|
|
|
|
|
)
|
|
|
|
|
|
)[1]
|
|
|
|
|
|
}
|
|
|
|
|
|
assert "filecodes" in tables # 001 执行了
|
|
|
|
|
|
assert "storagereservation" not in tables # 006 被跳过(其 DDL 未执行)
|
|
|
|
|
|
|
|
|
|
|
|
async def test_real_migrations_produce_expected_schema(self, fresh_db):
|
|
|
|
|
|
"""真实迁移链跑完后的 schema 抽查(与部署形态对齐)。"""
|
|
|
|
|
|
await execute_migrations()
|
|
|
|
|
|
conn = Tortoise.get_connection("default")
|
|
|
|
|
|
tables = {
|
|
|
|
|
|
row[0]
|
|
|
|
|
|
for row in (
|
|
|
|
|
|
await conn.execute_query(
|
|
|
|
|
|
"SELECT name FROM sqlite_master WHERE type='table'"
|
|
|
|
|
|
)
|
|
|
|
|
|
)[1]
|
|
|
|
|
|
}
|
|
|
|
|
|
assert {
|
|
|
|
|
|
"filecodes",
|
|
|
|
|
|
"keyvalue",
|
|
|
|
|
|
"uploadchunk",
|
|
|
|
|
|
"presignuploadsession",
|
|
|
|
|
|
"storagereservation",
|
|
|
|
|
|
"migrates",
|
|
|
|
|
|
} <= tables
|
|
|
|
|
|
|
|
|
|
|
|
async def test_failure_propagates_and_halts(self, fresh_db, monkeypatch):
|
|
|
|
|
|
"""迁移执行失败必须向上抛(启动失败可见),不能静默吞掉。"""
|
|
|
|
|
|
import importlib
|
|
|
|
|
|
|
2026-10-23 09:30:02 +00:00
|
|
|
|
# 构造一个会失败的执行缺口:008 未登记,且其模块 migrate 抛错
|
2026-09-20 02:01:08 +08:00
|
|
|
|
conn = Tortoise.get_connection("default")
|
|
|
|
|
|
await conn.execute_query("DELETE FROM migrates")
|
|
|
|
|
|
for name in EXPECTED[:-1]:
|
|
|
|
|
|
await conn.execute_query(
|
|
|
|
|
|
"INSERT INTO migrates (migration_file) VALUES (?)", [name]
|
|
|
|
|
|
)
|
|
|
|
|
|
real_import = importlib.import_module
|
|
|
|
|
|
|
|
|
|
|
|
def fake_import(name):
|
2026-10-23 09:30:02 +00:00
|
|
|
|
if name.endswith("migrations_008"):
|
2026-09-20 02:01:08 +08:00
|
|
|
|
class FakeMod:
|
|
|
|
|
|
@staticmethod
|
|
|
|
|
|
async def migrate():
|
|
|
|
|
|
raise RuntimeError("boom")
|
|
|
|
|
|
|
|
|
|
|
|
return FakeMod()
|
|
|
|
|
|
return real_import(name)
|
|
|
|
|
|
|
|
|
|
|
|
monkeypatch.setattr(importlib, "import_module", fake_import)
|
|
|
|
|
|
with pytest.raises(RuntimeError, match="boom"):
|
|
|
|
|
|
await execute_migrations()
|
|
|
|
|
|
# 失败的迁移不得登记
|
2026-10-23 09:30:02 +00:00
|
|
|
|
assert "migrations_008.py" not in await _registered()
|