131 lines
5.2 KiB
Python
131 lines
5.2 KiB
Python
#!/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())
|