Method constructor

src/codegraph/schema.ts:77–98

(dbPath: string)

  private deleteFileByPath: Database.Statement;

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

    this.upsertFile = this.db.prepare(`
      INSERT INTO files (path, language, mtime_ms, size_bytes, content_hash, indexed_at)
      VALUES (?, ?, ?, ?, ?, CURRENT_TIMESTAMP)
      ON CONFLICT(path) DO UPDATE SET
        language=excluded.language,
        mtime_ms=excluded.mtime_ms,
        size_bytes=excluded.size_bytes,
        content_hash=excluded.content_hash,
        indexed_at=CURRENT_TIMESTAMP
    `);
    this.deleteSymbolsForFile = this.db.prepare(`DELETE FROM symbols WHERE file_id = ?`);
    this.insertSymbol = this.db.prepare(`
      INSERT INTO symbols (file_id, name, kind, start_line, end_line, start_col, parent_symbol_id, signature)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?)
    `);
    this.findFileByPath = this.db.prepare(`SELECT * FROM files WHERE path = ?`);
    this.deleteFileByPath = this.db.prepare(`DELETE FROM files WHERE path = ?`);
  }

  /** Returns true if the file's mtime+size+hash match our cached entry → can be skipped. */
  isFileFresh(path: string, mtimeMs: number, sizeBytes: number, contentHash: string | null): boolean {