Method replaceFileSymbols

src/codegraph/schema.ts:111–153

Replace all symbols for a file atomically.

(
    path: string,
    language: string,
    mtimeMs: number,
    sizeBytes: number,
    contentHash: string | null,
    symbols: ExtractedSymbol[],
  )

  /** Replace all symbols for a file atomically. */
  replaceFileSymbols(
    path: string,
    language: string,
    mtimeMs: number,
    sizeBytes: number,
    contentHash: string | null,
    symbols: ExtractedSymbol[],
  ): void {
    const tx = this.db.transaction(() => {
      this.upsertFile.run(path, language, mtimeMs, sizeBytes, contentHash);
      const fileRow = this.findFileByPath.get(path) as FileRow;
      this.deleteSymbolsForFile.run(fileRow.id);
      // Two-pass: first insert all symbols, then resolve parent IDs by name within this file
      const nameToId = new Map<string, number>();
      for (const s of symbols) {
        const result = this.insertSymbol.run(
          fileRow.id,
          s.name,
          s.kind,
          s.startLine,
          s.endLine,
          s.startColumn,
          null, // resolved below
          s.signature ?? null,
        );
        nameToId.set(`${s.kind}:${s.name}`, result.lastInsertRowid as number);
      }
      // Second pass: link parents
      const updateParent = this.db.prepare(`UPDATE symbols SET parent_symbol_id = ? WHERE id = ?`);
      for (const s of symbols) {
        if (!s.parentName) continue;
        const childId = nameToId.get(`${s.kind}:${s.name}`);
        // Match parent by name (any kind) within the same file
        const parentSym = this.db.prepare(
          `SELECT id FROM symbols WHERE file_id = ? AND name = ? LIMIT 1`,
        ).get(fileRow.id, s.parentName) as { id: number } | undefined;
        if (childId !== undefined && parentSym) {
          updateParent.run(parentSym.id, childId);
        }
      }
    });
    tx();
  }

  removeFile(path: string): void {
    this.deleteFileByPath.run(path);