unis_hrms/tests/test_maintenance.py

126 lines
5.0 KiB
Python

"""系统数据维护:概况、备份、导出、清空数据。"""
from __future__ import annotations
import asyncio
import io
import json
import zipfile
from openpyxl import load_workbook
API = "/api/v1"
def test_maintenance_is_admin_only(client, admin, hr):
assert client.get(f"{API}/system/maintenance/overview", headers=hr).status_code == 403
resp = client.get(f"{API}/system/maintenance/overview", headers=admin)
assert resp.status_code == 200, resp.text
body = resp.json()
assert body["tables"] and body["table_count"] == len(body["tables"])
assert any(t["kept"] for t in body["tables"])
def test_backup_and_export_payloads(client, admin):
backup = client.get(f"{API}/system/maintenance/backup", headers=admin)
assert backup.status_code == 200, backup.text
assert backup.headers["content-type"] == "application/zip"
archive = zipfile.ZipFile(io.BytesIO(backup.content))
names = set(archive.namelist())
assert {"manifest.json", "database.json"} <= names
assert "database.sqlite" in names
manifest = json.loads(archive.read("manifest.json"))
assert manifest["tables"]["sys_user"] > 0
database = json.loads(archive.read("database.json"))
assert database["tables"]["hr_employee"]
exported = client.get(f"{API}/system/maintenance/export", headers=admin)
assert exported.status_code == 200, exported.text
workbook = load_workbook(io.BytesIO(exported.content), read_only=True)
assert "说明" in workbook.sheetnames
assert "sys_user" in workbook.sheetnames
assert "hr_employee" in workbook.sheetnames
def test_purge_requires_exact_confirm_phrase_and_leaves_data_intact(client, admin):
resp = client.post(
f"{API}/system/maintenance/purge",
headers=admin,
json={"confirm": "清空全部数据"},
)
assert resp.status_code == 400
assert resp.json()["code"] == "confirm_required"
total = client.get(f"{API}/employees", headers=admin, params={"page_size": 1}).json()["total"]
assert total > 0
def test_purge_accepts_unis_hrms_phrase(client, admin, monkeypatch):
"""确认短语放行逻辑单独验证,替换破坏性清理函数,避免影响共享测试库。"""
from app.services import maintenance
called = False
async def fake_purge(_session):
nonlocal called
called = True
return {"kept_users": ["admin"], "deleted_rows": 0}
monkeypatch.setattr(maintenance, "purge_all_data", fake_purge)
resp = client.post(
f"{API}/system/maintenance/purge",
headers=admin,
json={"confirm": "unis_hrms"},
)
assert resp.status_code == 200, resp.text
assert resp.json()["deleted_rows"] == 0
assert called
def test_purge_keeps_only_superuser(tmp_path, monkeypatch):
"""用独立临时库验证清理逻辑,避免破坏测试会话共享的数据库。"""
from sqlalchemy import func, select
from sqlalchemy.ext.asyncio import async_sessionmaker, create_async_engine
from app.db.base import Base
from app.models.employee import Employee
from app.models.rbac import Announcement, Role, User, UserRole
from app.services import maintenance
monkeypatch.setattr(maintenance.settings, "upload_dir", tmp_path / "uploads")
async def scenario():
engine = create_async_engine(f"sqlite+aiosqlite:///{tmp_path / 'purge.db'}")
async with engine.begin() as conn:
await conn.run_sync(Base.metadata.create_all)
session_factory = async_sessionmaker(engine, expire_on_commit=False)
async with session_factory() as session:
admin = User(username="admin", password_hash="x", name="管理员", is_superuser=True)
other = User(username="hr", password_hash="x", name="人事", is_superuser=False)
role = Role(code="super_admin", name="超级管理员", data_scope="all",
is_builtin=True, is_active=True, sort=1)
session.add_all([admin, other, role])
await session.flush()
session.add_all([
UserRole(user_id=admin.id, role_id=role.id),
UserRole(user_id=other.id, role_id=role.id),
Employee(name="张三", work_no="E9001", status="active"),
Announcement(title="公告", content="内容"),
])
await session.commit()
result = await maintenance.purge_all_data(session)
assert result["deleted_rows"] > 0
async with session_factory() as session:
users = (await session.execute(select(User))).scalars().all()
assert [u.username for u in users] == ["admin"]
assert (await session.execute(select(func.count()).select_from(Employee))).scalar() == 0
assert (await session.execute(select(func.count()).select_from(Announcement))).scalar() == 0
assert (await session.execute(select(func.count()).select_from(UserRole))).scalar() == 1
assert (await session.execute(select(func.count()).select_from(Role))).scalar() == 1
await engine.dispose()
asyncio.run(scenario())