126 lines
5.0 KiB
Python
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())
|