142 lines
6.2 KiB
Python
142 lines
6.2 KiB
Python
#!/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)
|