cd ~/Projects/Billows/Audit-Manager/compliance-manager-be
for L in api app domain infra; do
  printf "%-8s %s 檔 / %s 行\n" "$L" \
    "$(git ls-files "$L" | grep '\.py$' | wc -l | tr -d ' ')" \
    "$(git ls-files "$L" | grep '\.py$' | xargs wc -l | tail -1 | awk '{print $1}')"
done

cd ~/Projects/Billows/Audit-Manager/compliance-manager-be
python3 - <<'PY'
import os, subprocess, collections
layers = ['api','app','domain','infra']
mods = {d for L in layers for d in os.listdir(L)
        if os.path.isdir(os.path.join(L,d)) and d != '__pycache__'}
cnt = collections.defaultdict(lambda: [0,0])
for p in subprocess.run(['git','ls-files']+layers, capture_output=True, text=True).stdout.split():
    parts = p.split('/')
    if len(parts) < 2 or not p.endswith('.py'):
        continue
    n = sum(1 for _ in open(p, encoding='utf-8', errors='ignore'))
    cnt[(parts[0], parts[1])][0] += 1
    cnt[(parts[0], parts[1])][1] += n
print(f"{'module':26}{'api':>12}{'app':>12}{'domain':>12}{'infra':>12}{'total':>13}")
for m in sorted(mods):
    row, tf, tl = [], 0, 0
    for L in layers:
        v = cnt.get((L,m))
        if v:
            row.append(f"{v[0]}/{v[1]}"); tf += v[0]; tl += v[1]
        else:
            row.append("—")
    print(f"{m:26}{row[0]:>12}{row[1]:>12}{row[2]:>12}{row[3]:>12}{f'{tf}f/{tl}L':>13}")
PY

cd ~/Projects/Billows/Audit-Manager/compliance-manager-be
python3 - <<'PY'
import os, ast
tot = 0
for d in sorted(os.listdir('api')):
    p = os.path.join('api', d)
    if not os.path.isdir(p) or d == '__pycache__':
        continue
    prefix, paths = set(), []
    for root, dirs, files in os.walk(p):
        dirs[:] = [x for x in dirs if x != '__pycache__']
        for f in sorted(files):
            if not f.endswith('.py'):
                continue
            try:
                tree = ast.parse(open(os.path.join(root,f), encoding='utf-8', errors='ignore').read())
            except SyntaxError:
                continue
            for node in ast.walk(tree):
                if not isinstance(node, ast.Call):
                    continue
                fn = node.func
                name = fn.attr if isinstance(fn, ast.Attribute) else (fn.id if isinstance(fn, ast.Name) else '')
                if name == 'add_resource' and len(node.args) >= 2:
                    paths += [a.value for a in node.args[1:] if isinstance(a, ast.Constant)]
                elif name == 'route' and node.args and isinstance(node.args[0], ast.Constant):
                    paths.append(node.args[0].value)
                elif name == 'Blueprint':
                    for kw in node.keywords:
                        if kw.arg == 'url_prefix' and isinstance(kw.value, ast.Constant):
                            prefix.add(kw.value.value)
    u = len(set(paths)); tot += u
    print(f"{d:24} routes={u:3}  prefix={sorted(prefix)[0] if prefix else '—'}")
print("api/ 合計：", tot)
PY

grep -rn "^\s*#.*add_resource" api/ --include='*.py'

grep -rn "add_resource" core/plugins/*.py

cd ~/Projects/Billows/Audit-Manager/compliance-manager-be
python3 -c "
import re
s = open('config/app_modules.py').read()
act = re.findall(r'^\s*\"([a-z_]+)\",\s*\$', s, re.M)
print('生效中：', len(act)); print(act)
"

FE=~/Projects/Billows/Audit-Manager/compliance-manager-fe
E2E=~/Projects/Billows/Audit-Manager/compliance-manager-test
BE=~/Projects/Billows/Audit-Manager/compliance-manager-be
KEY='<要查的端點片段，例如 google-drive>'

# ① FE api.js 常數
grep -n -- "$KEY" $FE/src/config/api/api.js

# ② FE 路由（掛著就打得進去，即使選單關了）
#    ⚠️ 這層要用**頁面路徑**（如 cloud-integrations）不是端點片段（如 google-drive）
#       ——兩者常常不同名。先用下面第二條找出是哪些 .vue 在用，再回頭查它們掛在哪條路由
grep -n -- "$KEY" $FE/src/config/router/index.js
grep -rln -- "$KEY" $FE/src/          # 全 FE repo（這條才是可靠的「有沒有人用」）

# ③ DB ui_routes —— 使用者實際看得到什麼的真相來源
#    🔴 欄位是 name / url / enable（不是 path）
cd $BE && export PGPASSWORD=$(grep -oE 'DB_PASSWORD=\S+' .env | cut -d= -f2)
psql -h localhost -p 5432 -U cmmgr -d guidant_ai_dev -At -F'|' \
  -c "select enable, name, url from public.ui_routes order by enable desc, url"

# ④ 🔴 非瀏覽器呼叫者 —— 最常被漏掉的一層
grep -rn -- "$KEY" $BE/bin/ $BE/scripts/ $BE/core/scheduler.py $BE/common/middleware/ 2>/dev/null
grep -rn -- "$KEY" $E2E --include='*.js' --include='*.feature' 2>/dev/null | grep -v node_modules

# a. 先讀模組 __init__.py 的 docstring。本 repo 的慣例是把去留理由寫在檔頭，
#    通常直接寫「route 已上移 jedi-xxx」或「刻意留主專案，理由是…」
cat api/<模組>/__init__.py app/<模組>/__init__.py 2>/dev/null

# b. 看該模組引用了哪些套件（引用多 ≠ 是殼，要看引用的是「資料層 primitive」還是「整支 service」）
grep -rhoE '(from|import) (jedi_[a-z_0-9]+)' api/<模組> app/<模組> domain/<模組> infra/<模組> 2>/dev/null | sort -u

# c. 開最大的 2-3 支 service，看它是自己實作、還是每個 method 一行轉呼叫
git ls-files app/<模組> | grep '\.py$' | xargs wc -l | sort -rn | head -5

cd ~/Projects/Billows/Audit-Manager/compliance-manager-be
grep -rn "__tablename__" --include='*.py' infra/ | grep -v __pycache__ | sed 's|infra/||' | sort

psql -h localhost -p 5432 -U cmmgr -d guidant_ai_dev -At -F'|' -c "
select table_schema, count(*) from information_schema.tables
where table_type='BASE TABLE' and table_schema not in ('pg_catalog','information_schema')
group by 1 order by 2 desc"