Method migrateContentHash

packages/memos-core/src/storage/sqlite.ts:484–500

()

  }

  private migrateContentHash(): void {
    const cols = this.db.prepare("PRAGMA table_info(chunks)").all() as Array<{ name: string }>;
    if (!cols.some((c) => c.name === "content_hash")) {
      this.db.exec("ALTER TABLE chunks ADD COLUMN content_hash TEXT");
      this.db.exec("CREATE INDEX IF NOT EXISTS idx_chunks_dedup ON chunks(session_key, role, content_hash)");

      // Backfill existing rows
      const rows = this.db.prepare("SELECT id, content FROM chunks WHERE content_hash IS NULL").all() as Array<{ id: string; content: string }>;
      const updateStmt = this.db.prepare("UPDATE chunks SET content_hash = ? WHERE id = ?");
      for (const r of rows) {
        updateStmt.run(contentHash(r.content), r.id);
      }
      if (rows.length > 0) {
        this.log.info(`Migrated: backfilled content_hash for ${rows.length} chunks`);
      }
    }
  }

  private migrateSkillTables(): void {
    this.db.exec(`