1
"""Migrasi data agentgit dari SQLite lama ke kilat (tanpa kehilangan token).
3
Token hanya tersimpan sebagai hash, jadi migrasi menyalin token_hash apa adanya —
4
token yang sudah beredar tetap valid.
6
from __future__ import annotations
11
from pathlib import Path
13
sys.path.insert(0, str(Path(__file__).resolve().parent.parent))
14
from agentgit.db import Store # noqa: E402
17
def main(old: str, new: str) -> None:
18
src = sqlite3.connect(old)
19
src.row_factory = sqlite3.Row
22
for r in src.execute("SELECT id,name,email,token_hash,created_at FROM users"):
23
st._put("users", str(r["id"]), {k: r[k] for k in
24
("id", "name", "email", "token_hash", "created_at")})
25
for r in src.execute("SELECT id,user_id,name,description,model,token_hash,created_at,last_seen,calls FROM agents"):
26
st._put("agents", str(r["id"]), {k: r[k] for k in
27
("id", "user_id", "name", "description", "model", "token_hash",
28
"created_at", "last_seen", "calls")})
29
for r in src.execute("SELECT * FROM projects"):
30
st._put("projects", str(r["id"]), {
31
"id": r["id"], "user_id": r["user_id"], "name": r["name"], "url": r["url"],
32
"ref": r["ref"], "path": r["path"], "visibility": r["visibility"],
33
"status": r["status"], "error": r["error"], "commit_sha": r["commit_sha"],
34
"files": r["files"], "bytes": r["bytes"], "chunks": r["chunks"],
35
"indexed_at": r["indexed_at"], "created_at": r["created_at"],
37
docs = src.execute("SELECT * FROM docs").fetchall()
39
key = f'{r["project_id"]}/{r["path"]}#{r["start_line"]}'
40
st.k.put_indexed("docs", key, r["body"])
41
st._put("docmeta", key, {"project_id": r["project_id"], "path": r["path"],
42
"lang": r["lang"], "start_line": r["start_line"],
43
"end_line": r["end_line"], "body": r["body"]})
44
for r in src.execute("SELECT * FROM notes"):
45
st.k.put_indexed("notes", str(r["id"]), f'{r["body"]} {r["tags"]}')
46
st._put("notemeta", str(r["id"]), {"id": r["id"], "agent_id": r["agent_id"],
47
"project_id": r["project_id"], "body": r["body"],
48
"tags": r["tags"], "created_at": r["created_at"]})
49
for r in src.execute("SELECT * FROM jobs"):
50
st._put("jobs", str(r["id"]), {k: r[k] for k in
51
("id", "project_id", "status", "message", "created_at",
52
"started_at", "finished_at")})
54
for r in src.execute("SELECT * FROM events ORDER BY id"):
56
st._put("events", f"{ev:010d}", {"ts": r["ts"], "agent_id": r["agent_id"],
57
"tool": r["tool"], "ok": r["ok"], "ms": r["ms"],
58
"detail": r["detail"]})
59
for coll in ("users", "agents", "projects", "jobs", "notes"):
60
n = src.execute(f"SELECT COALESCE(MAX(id),0) FROM {coll}").fetchone()[0]
61
st.k.put("meta", f"seq.{coll}", str(n))
62
st.k.put("meta", "seq.events", str(ev))
64
print(json.dumps({"docs": len(docs), "events": ev, "target": new}, indent=1))
67
if __name__ == "__main__":
68
if len(sys.argv) != 3:
69
raise SystemExit("pakai: migrate_sqlite.py <sqlite-lama> <kilat-baru>")
70
main(sys.argv[1], sys.argv[2])