unis-oa/backend/scripts/prune_design.py

175 lines
7.3 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
"""只保留指定前缀(默认「烤机」)的表单与流程设计数据,其余删掉。
删的是设计数据:流程定义(连带它的环节与路由)、版本快照、表单,以及指向被删流程的
草稿与单号计数器;顺手把早就悬空的数据(流程被删了但环节 / 路由 / 版本还留着)一起清掉。
在途实例先按正常终止收尾(引擎会连带它的嵌入子流程一起收),免得删掉定义后留下一堆
没人认领、点开没内容的孤儿待办。已归档的历史单据一概不动——那是审计凭据。
python3 scripts/prune_design.py # 干跑:只列出要删什么
python3 scripts/prune_design.py --apply # 真删
python3 scripts/prune_design.py --keep 验收 --apply
"""
from __future__ import annotations
import argparse
import sys
from pathlib import Path
sys.path.insert(0, str(Path(__file__).resolve().parents[0].parent))
from sqlalchemy import select # noqa: E402
from app import models # noqa: E402
from app.db import SessionLocal # noqa: E402
from app.engine import engine as engine_module # noqa: E402
from app.engine.engine import Actor # noqa: E402
def admin_actor(db):
"""拿内置超管当收尾人:终止需要发起人或管理员身份。"""
person = db.execute(
select(models.User).where(models.User.role == models.ROLE_ADMIN).order_by(models.User.id)
).scalars().first()
if person is None:
raise SystemExit("库里找不到内置超管账号,无法代为终止在途实例")
return Actor.from_ref(db, person)
def inventory(db, prefixes):
"""算出这次要留什么、删什么,返回一组待删清单。"""
def kept(name: str) -> bool:
return any(str(name or "").startswith(p) for p in prefixes)
processes = list(db.execute(select(models.Process)).scalars())
keep_processes = [p for p in processes if kept(p.name)]
doomed_processes = [p for p in processes if not kept(p.name)]
keep_ids = {p.id for p in keep_processes}
# 保留流程还在用的表单一个都不能碰,哪怕名字对不上前缀
referenced: set[str] = {p.latest_form for p in keep_processes if p.latest_form}
referenced |= {
a.form
for a in db.execute(select(models.Activity).where(models.Activity.process.in_(keep_ids))).scalars()
if a.form
}
forms = list(db.execute(select(models.FormElement)).scalars())
doomed_forms = [f for f in forms if not kept(f.name) and f.id not in referenced]
alive = keep_ids | {p.id for p in doomed_processes}
orphan_activities = [
a for a in db.execute(select(models.Activity)).scalars() if a.process not in alive
]
orphan_routes = [r for r in db.execute(select(models.Route)).scalars() if r.process not in alive]
orphan_versions = [
v for v in db.execute(select(models.ProcessVersion)).scalars() if v.process not in alive
]
doomed_versions = [v for v in db.execute(select(models.ProcessVersion)).scalars()
if v.process in {p.id for p in doomed_processes}]
doomed_ids = {p.id for p in doomed_processes}
drafts = [d for d in db.execute(select(models.Draft)).scalars() if d.process in doomed_ids]
running = [
w
for w in db.execute(
select(models.Work).where(models.Work.status == "running").order_by(models.Work.serial)
).scalars()
if w.process in doomed_ids
]
return {
"keep_processes": keep_processes,
"doomed_processes": doomed_processes,
"doomed_forms": doomed_forms,
"doomed_versions": doomed_versions,
"orphan_activities": orphan_activities,
"orphan_routes": orphan_routes,
"orphan_versions": orphan_versions,
"drafts": drafts,
"running": running,
}
def report(items) -> None:
print("保留的流程:")
for p in items["keep_processes"]:
print(f" {p.name}({p.alias})")
if not items["keep_processes"]:
print(" (没有——前缀写错了?先别 --apply)")
sections = [
("要删的流程", [p.name for p in items["doomed_processes"]]),
("要先终止的在途实例", [f"{w.serial} {w.title}" for w in items["running"]]),
("要删的表单", [f.name for f in items["doomed_forms"]]),
("要删的版本快照", [f"{v.process[:8]} v{v.version}" for v in items["doomed_versions"]]),
("要清的悬空环节(流程早就不在了)", [f"{a.process[:8]}/{a.name}" for a in items["orphan_activities"]]),
("要清的悬空路由(流程早就不在了)", [f"{r.process[:8]}/{r.name}" for r in items["orphan_routes"]]),
("要清的悬空版本快照", [f"{v.process[:8]} v{v.version}" for v in items["orphan_versions"]]),
("要删的草稿", [d.title for d in items["drafts"]]),
]
for title, rows in sections:
print(f"\n{title}:{len(rows)} 项")
for row in rows[:12]:
print(f" - {row}")
if len(rows) > 12:
print(f" …… 另外 {len(rows) - 12} 项")
def apply_prune(db, items, actor) -> None:
for work in items["running"]:
engine_module.terminate(db, job=work.job, actor=actor, opinion="清理非保留流程的在途实例")
db.commit()
for draft in items["drafts"]:
db.delete(draft)
for form in items["doomed_forms"]:
db.delete(form)
for version in items["doomed_versions"] + items["orphan_versions"]:
db.delete(version)
for activity in items["orphan_activities"]:
db.delete(activity)
for route in items["orphan_routes"]:
db.delete(route)
for process in items["doomed_processes"]:
db.delete(process)
keep_ids = {p.id for p in items["keep_processes"]}
for counter in list(db.execute(select(models.SerialNumber)).scalars()):
if counter.process not in keep_ids:
db.delete(counter)
db.commit()
def main() -> int:
parser = argparse.ArgumentParser(description="只保留指定前缀的表单与流程设计数据")
parser.add_argument("--keep", action="append", default=None,
help="保留前缀,可重复;默认只留「烤机」开头的")
parser.add_argument("--apply", action="store_true", help="真的删;不加就只列清单")
args = parser.parse_args()
prefixes = args.keep or ["烤机"]
db = SessionLocal()
try:
items = inventory(db, prefixes)
report(items)
if not args.apply:
print("\n这是干跑,数据没动。确认无误加 --apply。")
return 0
if not items["keep_processes"]:
print("\n保留清单是空的,拒绝执行——否则会把设计数据删光。")
return 1
apply_prune(db, items, admin_actor(db))
print("\n已删除。")
remaining = inventory(db, prefixes)
print(f"复核:流程 {len(remaining['keep_processes'])} 条 / "
f"待删流程 {len(remaining['doomed_processes'])} 条 / "
f"待删表单 {len(remaining['doomed_forms'])} 张 / "
f"悬空设计数据 {len(remaining['orphan_activities']) + len(remaining['orphan_routes']) + len(remaining['orphan_versions'])} 行")
return 0
finally:
db.close()
if __name__ == "__main__":
sys.exit(main())