Sonnet 4.5 の退役まで 43 日 — 呼び出し元は grep ではなく、Usage の CSV から数えました

#!/usr/bin/env python3
"""model_inventory.py — コード内のモデル ID と、Console の Usage CSV を同じ表で突き合わせる。
使い方: python3 model_inventory.py <ディレクトリ> [--code] [--csv usage.csv]
  --code  設定・コードの拡張子だけを見る（記事本文やタグの文字列を拾わない）
"""
import csv, re, sys, pathlib, collections
 
# 公式 model-deprecations の「Model status」表（2026-10-18 取得）から、期限のあるものだけ
RETIRE = {
    "claude-sonnet-4-5-20250929": ("2026-11-30", "claude-sonnet-5-5"),
    "claude-opus-4-5-20251101":   ("2026-11-24以降(最短)", "claude-opus-5-5"),
    "claude-haiku-4-5-20251001":  ("2026-10-15以降(最短)", "claude-haiku-5-5"),
}
SKIP_DIRS = {".git", "node_modules", ".next", "dist", "build", "__pycache__", "generated"}
CODE_EXT = {".py", ".js", ".mjs", ".ts", ".tsx", ".sh", ".yaml", ".yml", ".toml", ".env", ".cfg", ".ini"}
SKIP_EXT = {".png", ".jpg", ".jpeg", ".gif", ".webp", ".pdf", ".zip", ".lock", ".woff", ".woff2"}
# 数字で終わる ID だけを拾う。slug（claude-opus-4-6-release など）を巻き込まない
ID_RE = re.compile(
    r"claude-(?:(?:sonnet|opus|haiku|fable|mythos)-\d+(?:-\d+)?(?:-\d{8})?"
    r"|3-(?:5-haiku|haiku|7-sonnet)-\d{8})(?![A-Za-z0-9]|-[A-Za-z0-9])"
)
 
def scan(root, code_only=False):
    hits = collections.defaultdict(list)
    for p in pathlib.Path(root).rglob("*"):
        if not p.is_file() or p.suffix.lower() in SKIP_EXT:
            continue
        if any(part in SKIP_DIRS for part in p.parts):
            continue
        if code_only and p.suffix.lower() not in CODE_EXT and p.name != ".env":
            continue
        try:
            text = p.read_text(encoding="utf-8")
        except (UnicodeDecodeError, OSError):
            continue
        for n, line in enumerate(text.splitlines(), 1):
            for m in ID_RE.findall(line):
                hits[m].append(f"{p}:{n}")
    return hits
 
def read_usage(path):
    """model を含む見出しの列でグループ化し、数値列を合計する。列名は固定しない。"""
    with open(path, newline="", encoding="utf-8-sig") as f:
        rows = list(csv.DictReader(f))
    if not rows:
        return {}
    cols = rows[0].keys()
    mcol = next((c for c in cols if "model" in c.lower()), None)
    if mcol is None:
        sys.exit("model を含む列が見つかりません: " + ", ".join(cols))
    numeric = [c for c in cols if c != mcol and all(_num(r[c]) is not None for r in rows if r[c] != "")]
    out = collections.defaultdict(lambda: collections.Counter())
    for r in rows:
        for c in numeric:
            v = _num(r[c])
            if v is not None:
                out[r[mcol]][c] += v
    return out
 
def _num(s):
    try:
        return float(str(s).replace(",", ""))
    except ValueError:
        return None
 
def main():
    args = sys.argv[1:]
    root = args[0] if args else "."
    csv_path = args[args.index("--csv") + 1] if "--csv" in args else None
    hits = scan(root, code_only="--code" in args)
    print(f"== コード内のモデル ID（{root}）")
    for mid in sorted(hits, key=lambda k: (k not in RETIRE, k)):
        note = ""
        if mid in RETIRE:
            d, to = RETIRE[mid]
            note = f"  ← 期限 {d} / 置き換え先 {to}"
        print(f"{len(hits[mid]):4d}  {mid}{note}")
        if mid in RETIRE:
            for loc in hits[mid][:5]:
                print(f"        {loc}")
    if csv_path:
        print(f"\n== Usage CSV（{csv_path}）")
        for model, cnt in read_usage(csv_path).items():
            flag = "  ← 期限あり" if model in RETIRE else ""
            print(model + flag)
            for c, v in cnt.items():
                print(f"    {c}: {v:,.0f}")
 
if __name__ == "__main__":
    main()

python3 model_inventory.py ~/repos/claudelab.net --code

date,api_key,model,input_tokens,output_tokens
2026-10-01,key_wallpaper_batch,claude-sonnet-4-5-20250929,1200000,210000
2026-10-01,key_wallpaper_batch,claude-sonnet-5-5,300000,52000
2026-10-01,key_translate,claude-haiku-4-5-20251001,880000,140000
2026-10-02,key_translate,claude-haiku-4-5-20251001,910000,150000
2026-10-02,key_wallpaper_batch,claude-sonnet-4-5-20250929,1100000,190000

python3 model_inventory.py ~/repos/claudelab.net --code --csv usage_sample.csv

== Usage CSV（usage_sample.csv）
claude-sonnet-4-5-20250929  ← 期限あり
    input_tokens: 2,300,000
    output_tokens: 400,000
claude-sonnet-5-5
    input_tokens: 300,000
    output_tokens: 52,000
claude-haiku-4-5-20251001  ← 期限あり
    input_tokens: 1,790,000
    output_tokens: 290,000