687
Oc
orc-code / files
orc-code / packages / orc-core / src / db.ts
1.8 KB
1import { existsSync, mkdirSync } from "node:fs"; 2import { join } from "node:path"; 3import { Database } from "bun:sqlite"; 4 5function getConfigDir(): string { 6 const xdg = process.env.XDG_CONFIG_HOME; 7 const base = xdg ?? join(process.env.HOME ?? "~", ".config"); 8 const dir = join(base, "orc-code"); 9 if (!existsSync(dir)) { 10 mkdirSync(dir, { recursive: true }); 11 } 12 return dir; 13} 14 15let _db: Database | null = null; 16 17function getDb(): Database { 18 if (_db) return _db; 19 20 const dbPath = join(getConfigDir(), "orc.db"); 21 _db = new Database(dbPath); 22 _db.run("PRAGMA journal_mode=WAL"); 23 24 _db.run(` 25 CREATE TABLE IF NOT EXISTS agents ( 26 name TEXT PRIMARY KEY, 27 command TEXT NOT NULL, 28 enabled INTEGER NOT NULL DEFAULT 1 29 ) 30 `); 31 32 _db.run(` 33 CREATE TABLE IF NOT EXISTS sessions ( 34 orc_session_id TEXT PRIMARY KEY, 35 agent_session_id TEXT, 36 agent_name TEXT NOT NULL, 37 title TEXT NOT NULL, 38 parent_orc_session_id TEXT, 39 created_at TEXT NOT NULL DEFAULT (datetime('now')) 40 ) 41 `); 42 43 return _db; 44} 45 46export function upsertAgent(name: string, command: string): void { 47 getDb().run( 48 "INSERT INTO agents (name, command) VALUES (?, ?) ON CONFLICT(name) DO UPDATE SET command = excluded.command", 49 [name, command], 50 ); 51} 52 53export function saveSession( 54 orcSessionId: string, 55 agentSessionId: string | null, 56 agentName: string, 57 title: string, 58 parentOrcSessionId?: string, 59): void { 60 getDb().run( 61 "INSERT INTO sessions (orc_session_id, agent_session_id, agent_name, title, parent_orc_session_id) VALUES (?, ?, ?, ?, ?)", 62 [orcSessionId, agentSessionId, agentName, title, parentOrcSessionId ?? null], 63 ); 64} 65 66export function updateSessionAgentId(orcSessionId: string, agentSessionId: string): void { 67 getDb().run("UPDATE sessions SET agent_session_id = ? WHERE orc_session_id = ?", [ 68 agentSessionId, 69 orcSessionId, 70 ]); 71}