Method ensureOpen

src/utils/telemetry.ts:93–134

Lazy init — only opens the DB the first time something tries to record.

()

  /** Lazy init — only opens the DB the first time something tries to record. */
  private ensureOpen(): Database.Database | null {
    if (!this.enabled) return null;
    if (this.db) return this.db;
    try {
      this.db = new Database(QODEX_TELEMETRY_DB);
      this.db.pragma('journal_mode = WAL');
      this.db.exec(`
        CREATE TABLE IF NOT EXISTS tool_events (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          ts INTEGER NOT NULL,
          cwd TEXT NOT NULL,
          tool TEXT NOT NULL,
          duration_ms INTEGER NOT NULL,
          success INTEGER NOT NULL,
          error_class TEXT
        );
        CREATE INDEX IF NOT EXISTS idx_tool_events_tool ON tool_events(tool);
        CREATE INDEX IF NOT EXISTS idx_tool_events_cwd ON tool_events(cwd);

        CREATE TABLE IF NOT EXISTS llm_events (
          id INTEGER PRIMARY KEY AUTOINCREMENT,
          ts INTEGER NOT NULL,
          cwd TEXT NOT NULL,
          provider TEXT NOT NULL,
          model TEXT NOT NULL,
          role TEXT NOT NULL,
          input_tokens INTEGER NOT NULL,
          output_tokens INTEGER NOT NULL,
          duration_ms INTEGER NOT NULL,
          cost_usd REAL NOT NULL,
          success INTEGER NOT NULL
        );
        CREATE INDEX IF NOT EXISTS idx_llm_events_model ON llm_events(model);
        CREATE INDEX IF NOT EXISTS idx_llm_events_role ON llm_events(role);
      `);
      return this.db;
    } catch (e: any) {
      logger.warn('Telemetry DB open failed; disabling for this session', { err: e?.message });
      this.enabled = false;
      return null;
    }
  }

  setEnabled(enabled: boolean, anonymize = false): void {
    this.enabled = enabled;