Method chunkExistsByContent

packages/memos-core/src/storage/sqlite.ts:1705–1711

* Check if a chunk with the same (session_key, role, content_hash) already exists. * Uses indexed content_hash for O(1) lookup to prevent duplicate ingestion * when agent_end sends the full conversation history every turn.

(sessionKey: string, role: string, content: string)

   * when agent_end sends the full conversation history every turn.
   */
  chunkExistsByContent(sessionKey: string, role: string, content: string): boolean {
    const hash = contentHash(content);
    const row = this.db.prepare(
      "SELECT 1 FROM chunks WHERE session_key = ? AND role = ? AND content_hash = ? LIMIT 1",
    ).get(sessionKey, role, hash);
    return !!row;
  }

  /**
   * Find an active chunk with the same content_hash within the same owner (agent dimension).