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