xonecas.io
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}