MCPcopy Create free account
hub / github.com/DeusData/codebase-memory-mcp / cbm_activity_open

Function cbm_activity_open

src/ui/activity.c:18–96  ·  view source on GitHub ↗

Source from the content-addressed store, hash-verified

16#define EVENT_MAX 16384
17
18sqlite3 *cbm_activity_open(const char *path) {
19 sqlite3 *db = NULL;
20 if (sqlite3_open_v2(path, &db,
21 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_FULLMUTEX,
22 NULL) != SQLITE_OK) {
23 sqlite3_close(db);
24 return NULL;
25 }
26#ifndef _WIN32
27 if (strcmp(path, ":memory:"))
28 (void)chmod(path, 0600);
29#endif
30 sqlite3_busy_timeout(db, 1000);
31 sqlite3_stmt *version_stmt = NULL;
32 int version = 0;
33 if (sqlite3_prepare_v2(db, "PRAGMA user_version", -1, &version_stmt, NULL) == SQLITE_OK &&
34 sqlite3_step(version_stmt) == SQLITE_ROW)
35 version = sqlite3_column_int(version_stmt, 0);
36 sqlite3_finalize(version_stmt);
37 if (version > 4) {
38 sqlite3_close(db);
39 return NULL;
40 }
41 /* An additive, versioned migration; graph schema/rebuilds never erase logs. */
42 const char *schema =
43 "PRAGMA journal_mode=WAL; PRAGMA synchronous=NORMAL; BEGIN IMMEDIATE;"
44 "CREATE TABLE IF NOT EXISTS activity_meta(key TEXT PRIMARY KEY,value TEXT NOT NULL);"
45 "INSERT OR IGNORE INTO activity_meta VALUES('generation',lower(hex(randomblob(16))));"
46 "CREATE TABLE IF NOT EXISTS agent_events("
47 "id INTEGER PRIMARY KEY AUTOINCREMENT,project TEXT NOT NULL,run TEXT NOT NULL,"
48 "seq INTEGER NOT NULL,payload TEXT NOT NULL,UNIQUE(project,run,seq));"
49 "CREATE INDEX IF NOT EXISTS agent_events_project ON agent_events(project,id);"
50 "CREATE TABLE IF NOT EXISTS agent_retention(project TEXT PRIMARY KEY,pruned_through "
51 "INTEGER NOT NULL);"
52 "CREATE TABLE IF NOT EXISTS agent_retired(project TEXT NOT NULL,run TEXT NOT NULL,max_seq "
53 "INTEGER NOT NULL,PRIMARY KEY(project,run));"
54 "CREATE TABLE IF NOT EXISTS ui_log_retired(session TEXT PRIMARY KEY,max_seq INTEGER NOT "
55 "NULL);"
56 "CREATE TABLE IF NOT EXISTS daemon_logs(id INTEGER PRIMARY KEY AUTOINCREMENT,"
57 "ts TEXT NOT NULL,level INTEGER NOT NULL,source TEXT NOT NULL,message TEXT NOT NULL);"
58 "CREATE INDEX IF NOT EXISTS daemon_logs_level ON daemon_logs(level,id);";
59 if (sqlite3_exec(db, schema, NULL, NULL, NULL) != SQLITE_OK) {
60 sqlite3_close(db);
61 return NULL;
62 }
63 sqlite3_stmt *columns = NULL;
64 bool has_event_key = false, has_project = false, has_origin = false;
65 if (sqlite3_prepare_v2(db, "PRAGMA table_info(daemon_logs)", -1, &columns, NULL) == SQLITE_OK) {
66 while (sqlite3_step(columns) == SQLITE_ROW) {
67 const char *column = (const char *)sqlite3_column_text(columns, 1);
68 has_event_key |= !strcmp(column, "event_key");
69 has_project |= !strcmp(column, "project");
70 has_origin |= !strcmp(column, "origin");
71 }
72 }
73 sqlite3_finalize(columns);
74 if ((!has_event_key && sqlite3_exec(db, "ALTER TABLE daemon_logs ADD COLUMN event_key TEXT",
75 NULL, NULL, NULL) != SQLITE_OK) ||

Callers 2

activity_db_lockedFunction · 0.85
test_httpd.cFile · 0.85

Calls

no outgoing calls

Tested by

no test coverage detected