"""接口测试公共夹具。 两条硬规矩: 1. **绝不碰 data/board.db**:在 import 业务模块之前把 DATABASE_URL 指到临时库里 (`app.db` 在 import 时建 engine,`app.main` 在 import 时建表 + 补内置角色,晚一步就来不及了); 2. **每个用例一个干净库**:清表重建 + 重新补种内置角色/管理员,用例之间不互相污染 (权限类用例会故意停用账号、改角色,没有隔离就没法稳定断言)。 """ from __future__ import annotations import os import sys import tempfile from pathlib import Path import pytest from fastapi.testclient import TestClient ROOT = Path(__file__).resolve().parent.parent if str(ROOT) not in sys.path: sys.path.insert(0, str(ROOT)) _TMP_DIR = tempfile.mkdtemp(prefix="unis-dms-test-") os.environ["DATABASE_URL"] = f"sqlite:///{_TMP_DIR}/test.db" os.environ["ADMIN_USERNAME"] = "admin" os.environ["ADMIN_PASSWORD"] = "admin123" os.environ["AI_API_KEY"] = "" # 不配 Key:/ai 走本地规则解析,测试不联网 from app import security # noqa: E402 from app.db import Base, SessionLocal, engine # noqa: E402 from app.main import app # noqa: E402 from app.routers import auth as auth_router # noqa: E402 ADMIN_USER = "admin" ADMIN_PASS = "admin123" DEFAULT_PW = "pw123456" @pytest.fixture(autouse=True) def clean_db(): """每个用例重建表结构 + 补种内置数据,并清掉登录失败计数(限流是进程内的)。""" Base.metadata.drop_all(bind=engine) Base.metadata.create_all(bind=engine) engine.dispose() # 丢掉连接池里的旧连接,避免 SQLite 结构缓存 with SessionLocal() as db: security.ensure_seed(db) auth_router._failures.clear() yield @pytest.fixture() def client(clean_db): """未登录的裸客户端。""" with TestClient(app) as c: yield c @pytest.fixture() def db(clean_db): """直接操作数据库(造脏数据、绕开接口校验用)。""" with SessionLocal() as s: yield s class Harness: """一组顺手的小工具:建角色/建账号/登录/造业务数据,测试里只写断言。""" def __init__(self): self.app = app self.anon = TestClient(app) self.admin = self.login(ADMIN_USER, ADMIN_PASS) # ------------------------------------------------------------- 账号 def login(self, username: str, password: str | None = None) -> TestClient: # 内置管理员用 seed 密码,其它测试账号统一用默认初始密码 password = password or (ADMIN_PASS if username == ADMIN_USER else DEFAULT_PW) c = TestClient(self.app) r = c.post("/api/auth/login", json={"username": username, "password": password}) assert r.status_code == 200, f"登录失败 {username}: {r.status_code} {r.text}" return c def roles(self) -> dict[str, dict]: return {x["name"]: x for x in self.admin.get("/api/rbac/roles").json()} def role(self, name: str, menus: dict | None = None, **kw) -> dict: body = {"name": name, "menus": menus or {}} body.update(kw) r = self.admin.post("/api/rbac/roles", json=body) assert r.status_code == 200, r.text return r.json() def user(self, username: str, *, name: str | None = None, password: str = DEFAULT_PW, menus: dict | None = None, role_ids: list[int] | None = None, active: bool = True) -> dict: """建账号。给了 menus 就先建一个同名角色挂上去;不给角色则走后端默认「部门成员」。""" ids = role_ids if menus is not None: ids = [self.role(f"角色-{username}", menus)["id"]] body = {"name": name or username, "username": username, "password": password, "active": active} if ids is not None: body["role_ids"] = ids r = self.admin.post("/api/rbac/users", json=body) assert r.status_code == 200, r.text return r.json() def user_client(self, username: str, **kw) -> TestClient: """建账号并登录,直接返回带会话的客户端。""" password = kw.get("password", DEFAULT_PW) self.user(username, password=password, **{k: v for k, v in kw.items() if k != "password"}) return self.login(username, password) # ------------------------------------------------------------- 周期 def periods(self) -> dict: r = self.admin.get("/api/periods") assert r.status_code == 200, r.text return r.json() def period(self, year: int, month: int, week: int = 1) -> dict: r = self.admin.post("/api/periods", json={"year": year, "month": month, "week": week}) assert r.status_code == 200, r.text return r.json()["period"] @property def today_period_id(self) -> int: data = self.periods() pid = data["today_id"] assert pid, "今天所在的周应当自动建出来" return pid # ------------------------------------------------------------- 业务数据 def project(self, name: str, **kw) -> dict: r = self.admin.post("/api/projects", json={"name": name, **kw}) assert r.status_code == 200, r.text return r.json() def category(self, name: str, **kw) -> dict: r = self.admin.post("/api/categories", json={"name": name, **kw}) assert r.status_code == 200, r.text return r.json() def custom(self, name: str, **kw) -> dict: r = self.admin.post("/api/custom/projects", json={"name": name, **kw}) assert r.status_code == 200, r.text return r.json() def custom_update(self, custom_project_id: int, period_id: int, **kw) -> dict: r = self.admin.post("/api/custom/updates", json={"custom_project_id": custom_project_id, "period_id": period_id, **kw}) assert r.status_code == 200, r.text return r.json() def update(self, project_id: int, period_id: int, **kw) -> dict: body = {"project_id": project_id, "period_id": period_id, "content": kw.pop("content", "推进中"), **kw} r = self.admin.post("/api/updates", json=body) assert r.status_code == 200, r.text return r.json() def staff(self, name: str, **kw) -> dict: r = self.admin.post("/api/staff", json={"name": name, **kw}) assert r.status_code == 200, r.text return r.json() def focus(self, content: str, **kw) -> dict: r = self.admin.post("/api/focus", json={"content": content, **kw}) assert r.status_code == 200, r.text return r.json() @pytest.fixture() def h(clean_db) -> Harness: return Harness()