unis-oa/backend/scripts/check_embed_gc.py

142 lines
6.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
"""第三方隔天回写之前,那一趟留在 OA 手里的底稿不能被自家的清理删掉。
PYTHONPATH=. python3 scripts/check_embed_gc.py
用户那句原话是:"就是创建流程的时候没有活动的流程,导致第三方调用提交失败。"
开始环节那一路代发(``api/openapi.py:_delegate_start``)认的是嵌入会话那一行——
按 OA 自己排出去的单号找到那一趟,才知道该替谁发起、那张表单上填过些什么。那一行没了,
他那句裸 AGREE 就退化成「说是替谁发起」,而对方不改报文;真实节奏又确实是今天填、明后天审。
原来 :func:`app.service.embed_session._gc` 只认「过期一小时」这一条,跟那一趟到底
发起没发起没关系。钉这几句:
1. 过期两小时、占着一个**还没变成单**的号、带着整份表单底稿的那一行**留着**,
而且 ``by_serial`` 还认得它、``trip_form`` 还读得出那几格——这就是代发那一路要吃的东西;
2. 同一个号真的发起成一张单之后,那一行照旧一小时之后清掉:值都在 ``work.data`` 里了,
留着只是留痕;
3. 压根没占过号的那一行也照旧清,它不是任何一张还没发起的单的唯一底稿;
4. 多留有上界(``GC_HOLD_DAYS``),别让这张表长成另一个归档;
5. :func:`app.service.embed_session.touch`:刷新与"人走了补送那一次"把存活期往前挪一格。
原来只有重新打开那一页才续期,于是填一张长单跨过默认那两小时之后,他后面敲的那些值
就再也留不住(``match_prekey`` 与 ``find_open`` 都不认过期那一趟了)。
只碰自己造的那几行(都带这一趟专用的 prekey),跑完删干净。
"""
from __future__ import annotations
import pathlib
import sys
import time
from datetime import datetime, timedelta
sys.path.insert(0, str(pathlib.Path(__file__).resolve().parent.parent))
from sqlalchemy import delete, select # noqa: E402
from app import models # noqa: E402
from app.db import SessionLocal # noqa: E402
from app.service import embed_session # noqa: E402
STAMP = int(time.time())
SOURCE = f"GCX{STAMP}"
#: 那一趟专用的那几个号:清理只按 expires_at 删,靠这个前缀才能确认没顺手删掉别人的行
PK = {key: f"PK{STAMP}-{key}" for key in ("hold", "started", "noserial", "ancient", "touch")}
SER_HOLD = f"GCXHOLD{STAMP}"
SER_ANCIENT = f"GCXOLD{STAMP}"
PASSED = 0
FAILS: list[str] = []
def check(label: str, condition, detail: str = "") -> None:
global PASSED
if condition:
PASSED += 1
print(f" ok {label}")
return
FAILS.append(label)
print(f" FAIL {label}{(' ' + detail) if detail else ''}")
def make(db, key: str, *, serial: str, expires: datetime, form: dict | None = None):
row = models.EmbedSession(
token_hash=f"tok-{PK[key]}", prekey=PK[key], source=SOURCE, person="1",
field="embed_x", serial=serial, result={"_form": form} if form else {},
expires_at=expires,
)
db.add(row)
return row
def alive(db, key: str) -> bool:
return db.execute(select(models.EmbedSession.id).where(
models.EmbedSession.prekey == PK[key])).first() is not None
db = SessionLocal()
made_work = ""
try:
# 那一条"号已经变成一张单"的对照:库里随便找一个已经存在的正式号最省事,
# 一个都没有才自己造一张单(造了就得自己删)
two_hours_ago = datetime.now() - timedelta(hours=2)
serial_started = str(db.execute(
select(models.Work.serial).where(models.Work.serial != "").limit(1)).scalar() or "")
if not serial_started:
spare = models.Work(job=f"GCXJOB{STAMP}", process="0", title="清理自检那张单",
serial=f"GCXWORK{STAMP}")
db.add(spare)
db.flush()
serial_started = str(spare.serial)
made_work = str(spare.job)
make(db, "hold", serial=SER_HOLD, expires=two_hours_ago,
form={"payMethod": "转账", "accountProject": "底稿里那个项目"})
make(db, "started", serial=serial_started, expires=two_hours_ago)
make(db, "noserial", serial="", expires=two_hours_ago)
make(db, "ancient", serial=SER_ANCIENT, expires=datetime.now() - timedelta(days=8))
db.commit()
embed_session._gc(db, datetime.now())
db.commit()
check("占着号还没成单的那一趟,过期两小时之后底稿还在", alive(db, "hold"))
check("那个号已经发起成一张单了,那一行照旧清掉", not alive(db, "started"))
check("压根没占过号的那一行照旧清掉", not alive(db, "noserial"))
check("多留有上界,八天那一行一视同仁", not alive(db, "ancient"))
# 代发那一路真正要吃的两样:按号认回那一趟,再读出那份整张单的值
found = embed_session.by_serial(db, SER_HOLD)
check("by_serial 还认得那个号", found is not None and str(found.prekey) == PK["hold"])
check("那份整张单的底稿还读得出来",
embed_session.trip_form(found) == {"payMethod": "转账", "accountProject": "底稿里那个项目"},
str(embed_session.trip_form(found)))
check("那一趟占下的号还能接着用(代发不换号)",
embed_session.reserved_serial(db, found) == SER_HOLD)
# touch:那一趟还在被人用,存活期就该往前挪
row = db.execute(select(models.EmbedSession).where(
models.EmbedSession.prekey == PK["hold"])).scalar_one()
row.expires_at = datetime.now() + timedelta(seconds=30)
db.commit()
embed_session.touch(db, row)
db.commit()
left = (row.expires_at - datetime.now()).total_seconds()
check("刷新那一句把存活期挪回一整格 ttl",
embed_session.ttl() - 5 <= left <= embed_session.ttl() + 5, f"剩 {left:.0f}s")
embed_session.touch(db, None)
check("没有那一趟时 touch 什么都不做", True)
finally:
db.execute(delete(models.EmbedSession).where(models.EmbedSession.source == SOURCE))
if made_work:
db.execute(delete(models.Work).where(models.Work.job == made_work))
db.commit()
db.close()
print(f"\n通过 {PASSED} 条,失败 {len(FAILS)} 条")
if FAILS:
for one in FAILS:
print(f" - {one}")
sys.exit(1 if FAILS else 0)