unis-oa/backend/scripts/check_current_user.py

131 lines
5.2 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

#!/usr/bin/env python3
"""守住"认人只排一次队":人、部门、权限角色一趟 JOIN 取完,且口径与现查一字不差。
每个请求的第一步都是认人。原来是两条串行的语句:先取 ``users``(顺带 JOIN 部门),
再取这个人的权限角色(``oa_auth_role`` 经 ``oa_person_auth_role``)。库在另一台机器上时
这就是每个请求开头白排的两次队。现在角色跟着一起 JOIN 进来(``users.auth_roles``),
**权限仍然是每次现查**——改角色立刻生效的口径一字未动,少的只是排队。
风险全在"两份取角色的口径会不会走岔":关系上那份(只认启用的、按 ``sort, name`` 排)
与 :func:`app.permissions.roles_of` 那份必须完全一致,顺序还会进到 ``role_names`` 报文里。
所以这里不是抽样,是**把库里每个人**都拿来对一遍。::
cd backend && PYTHONPATH=. python3 scripts/check_current_user.py
"""
from __future__ import annotations
from sqlalchemy import event, select
from sqlalchemy.orm import joinedload
from app import deps, models, permissions as perm
from app.db import SessionLocal, engine
from app.service import personref
FAILS: list[str] = []
#: 只在本脚本里数语句条数,跑完就摘掉
COUNT = [0]
def eq(name: str, got, want) -> None:
if got != want:
FAILS.append(f"{name}:期望 {want!r},实得 {got!r}")
@event.listens_for(engine, "before_cursor_execute")
def _count(conn, cursor, statement, parameters, context, executemany) -> None:
COUNT[0] += 1
def role_shape(rows) -> list[tuple]:
return [(r.id, r.name, r.sort, r.data_scope, list(r.permissions or []), bool(r.enabled)) for r in rows]
def check_every_person(db) -> int:
"""每个人:JOIN 出来的角色 == 现查的角色;折出来的 CurrentUser 也一字不差。"""
ids = list(db.execute(select(models.User.id).order_by(models.User.id)).scalars().all())
for person_id in ids:
fresh = SessionLocal()
try:
person = fresh.get(models.User, person_id)
loaded = fresh.execute(
select(models.User)
.where(models.User.id == person_id)
.options(joinedload(models.User.unit), joinedload(models.User.auth_roles))
).unique().scalar_one()
eq(f"角色一致 users.id={person_id}",
role_shape(loaded.auth_roles), role_shape(perm.roles_of(fresh, person_id)))
ref = personref.ref_of(person)
with_preload = deps.CurrentUser.resolve(fresh, person, ref, roles=list(loaded.auth_roles))
fresh2 = SessionLocal()
without = deps.CurrentUser.resolve(fresh2, fresh2.get(models.User, person_id), ref)
fresh2.close()
for field in ("ref", "is_admin", "permissions", "data_scope", "role_names"):
eq(f"{field} 一致 users.id={person_id}", getattr(with_preload, field), getattr(without, field))
eq(f"data_grant 一致 users.id={person_id}", with_preload.data_grant, without.data_grant)
finally:
fresh.close()
return len(ids)
def check_one_roundtrip(db) -> int:
"""带上这两个 loader 之后,认人确实只排一次队。"""
person_id = db.execute(select(models.User.id).order_by(models.User.id).limit(1)).scalar_one()
fresh = SessionLocal()
try:
COUNT[0] = 0
person = fresh.get(
models.User,
person_id,
options=[joinedload(models.User.unit), joinedload(models.User.auth_roles)],
)
statements = COUNT[0]
eq("认人只用一条语句", statements, 1)
# 角色与部门都该已经在内存里,读它们不许再回库
COUNT[0] = 0
_ = [r.id for r in person.auth_roles]
_ = person.organization_name
eq("读已带出的角色与部门不再回库", COUNT[0], 0)
finally:
fresh.close()
return statements
def check_lazy_guard(db) -> bool:
"""没带 joinedload 就读 ``auth_roles`` 必须当场炸:这是防 N+1 的那道闸。"""
person_id = db.execute(select(models.User.id).order_by(models.User.id).limit(1)).scalar_one()
fresh = SessionLocal()
try:
person = fresh.get(models.User, person_id)
fresh.expire(person, ["auth_roles"])
try:
_ = person.auth_roles
except Exception: # noqa: BLE001 - 要的就是它炸
return True
FAILS.append("lazy=raise 没拦住:偷偷读 auth_roles 会长成 N+1")
return False
finally:
fresh.close()
def main() -> int:
db = SessionLocal()
try:
people = check_every_person(db)
statements = check_one_roundtrip(db)
guarded = check_lazy_guard(db)
finally:
db.close()
print(f"库里 {people} 个人逐个对过;认人 {statements} 条语句;lazy=raise {'拦得住' if guarded else '没拦住'}")
if FAILS:
print(f"\n不通过 {len(FAILS)} 条:")
for line in FAILS[:20]:
print(" -", line)
return 1
print("通过:权限角色跟着人员一趟取回,与现查一字不差,改角色立刻生效的口径没动。")
return 0
if __name__ == "__main__":
raise SystemExit(main())