| 16 | #define EVENT_MAX 16384 |
| 17 | |
| 18 | sqlite3 *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) || |
no outgoing calls
no test coverage detected