别让 Coding Agent 重修旧 Bug：把本地会话变成可搜索的工程记忆

SessionRecord
  source       claude-code | codex | opencode
  session_id   原始会话标识
  project      项目路径或名称
  timestamp    消息时间
  role         user | assistant | tool
  content      可搜索文本
  origin       原始文件或数据库位置

#!/usr/bin/env python3
import argparse
import json
import sqlite3
from pathlib import Path

TEXT_SUFFIXES = {".jsonl", ".json", ".txt", ".md"}


def flatten(value):
    if isinstance(value, str):
        return [value]
    if isinstance(value, dict):
        parts = []
        for item in value.values():
            parts.extend(flatten(item))
        return parts
    if isinstance(value, list):
        parts = []
        for item in value:
            parts.extend(flatten(item))
        return parts
    return []


def read_document(path):
    text = path.read_text(encoding="utf-8", errors="replace")
    try:
        if path.suffix == ".jsonl":
            values = [json.loads(line) for line in text.splitlines() if line.strip()]
        elif path.suffix == ".json":
            values = [json.loads(text)]
        else:
            return text
        return "\n".join(part for value in values for part in flatten(value))
    except (json.JSONDecodeError, TypeError):
        return text


def open_index(path):
    db = sqlite3.connect(path)
    db.execute(
        "CREATE VIRTUAL TABLE IF NOT EXISTS sessions "
        "USING fts5(path UNINDEXED, content)"
    )
    return db


def build(source, index):
    db = open_index(index)
    db.execute("DELETE FROM sessions")
    count = 0
    for path in source.rglob("*"):
        if not path.is_file() or path.suffix.lower() not in TEXT_SUFFIXES:
            continue
        content = read_document(path)
        if content.strip():
            db.execute(
                "INSERT INTO sessions(path, content) VALUES (?, ?)",
                (str(path), content),
            )
            count += 1
    db.commit()
    print(f"indexed {count} files into {index}")


def search(index, query):
    db = open_index(index)
    rows = db.execute(
        "SELECT path, snippet(sessions, 1, '[', ']', ' ... ', 24) "
        "FROM sessions WHERE sessions MATCH ? ORDER BY rank LIMIT 20",
        (query,),
    )
    for path, snippet in rows:
        print(f"\n{path}\n  {snippet}")


def main():
    parser = argparse.ArgumentParser()
    sub = parser.add_subparsers(dest="command", required=True)

    build_cmd = sub.add_parser("build")
    build_cmd.add_argument("source", type=Path)
    build_cmd.add_argument("--index", type=Path, default=Path("agent-memory.db"))

    search_cmd = sub.add_parser("search")
    search_cmd.add_argument("query")
    search_cmd.add_argument("--index", type=Path, default=Path("agent-memory.db"))

    args = parser.parse_args()
    if args.command == "build":
        build(args.source.expanduser(), args.index)
    else:
        search(args.index, args.query)


if __name__ == "__main__":
    main()

find "$HOME" -maxdepth 4 \
  \( -iname '*.jsonl' -o -iname '*session*' -o -iname '*.sqlite' -o -iname '*.db' \) \
  2>/dev/null | head -100

python3 agent_memory.py build "$HOME/.local/share/my-agent/sessions"
python3 agent_memory.py search 'certificate verify failed'
python3 agent_memory.py search 'webpack AND memory'
python3 agent_memory.py search 'proxy OR NO_PROXY'

当前问题：CI 中执行 npm install 时偶发 ECONNRESET。

下面是本地历史会话的检索片段，仅作为线索，不要假设它仍然正确：
<历史片段>
...
</历史片段>

请完成：
1. 提取历史片段中的环境条件和验证命令。
2. 对照当前仓库配置，指出已经过时或无法确认的部分。
3. 给出最小复现步骤，再决定是否沿用历史方案。