Method constructor

src/session/store.ts:150–195

(dbPath: string = QODEX_SESSION_DB)

  private getMessagesStmt: Database.Statement;

  constructor(dbPath: string = QODEX_SESSION_DB) {
    this.db = openDatabase(dbPath);
    this.db.exec(SCHEMA);

    // Migration: older DBs have session_facts without a `scope` column. Add it,
    // defaulting existing rows to 'project' (the only scope that existed before).
    const factCols = this.db.prepare(`PRAGMA table_info(session_facts)`).all() as Array<{ name: string }>;
    if (!factCols.some(c => c.name === 'scope')) {
      this.db.exec(`ALTER TABLE session_facts ADD COLUMN scope TEXT NOT NULL DEFAULT 'project'`);
    }
    // Safe now that the column is guaranteed to exist (new schema or just-migrated).
    this.db.exec(`CREATE INDEX IF NOT EXISTS idx_facts_scope ON session_facts(scope)`);

    this.initFactsFts();

    this.insertSession = this.db.prepare(`
      INSERT INTO sessions (id, cwd, model, title) VALUES (?, ?, ?, ?)
    `);
    // Bump turn_count only when this batch contains a user message
    this.updateSessionWithTurn = this.db.prepare(`
      UPDATE sessions SET
        updated_at = CURRENT_TIMESTAMP,
        total_input_tokens = total_input_tokens + ?,
        total_output_tokens = total_output_tokens + ?,
        total_cost_usd = total_cost_usd + ?,
        turn_count = turn_count + 1,
        title = COALESCE(title, ?)
      WHERE id = ?
    `);
    // Update usage without bumping turn_count (for assistant/tool messages)
    this.updateSessionNoTurn = this.db.prepare(`
      UPDATE sessions SET
        updated_at = CURRENT_TIMESTAMP,
        total_input_tokens = total_input_tokens + ?,
        total_output_tokens = total_output_tokens + ?,
        total_cost_usd = total_cost_usd + ?
      WHERE id = ?
    `);
    this.insertMessage = this.db.prepare(`
      INSERT INTO messages (session_id, turn_number, role, content, tool_calls_json, tool_call_id, name)
      VALUES (?, ?, ?, ?, ?, ?, ?)
    `);
    this.getMessagesStmt = this.db.prepare(`
      SELECT * FROM messages WHERE session_id = ? ORDER BY turn_number ASC, id ASC
    `);
  }

  createSession(cwd: string, model: string): string {
    const id = uuidv4();