Method getTaskEmbeddings

packages/memos-core/src/storage/sqlite.ts:1898–1912

(owner?: string)

  }

  getTaskEmbeddings(owner?: string): Array<{ taskId: string; vector: number[] }> {
    let sql = `SELECT te.task_id, te.vector, te.dimensions
       FROM task_embeddings te
       JOIN tasks t ON t.id = te.task_id`;
    const params: any[] = [];
    if (owner) {
      sql += ` WHERE (t.owner = ? OR t.owner = 'public')`;
      params.push(owner);
    }
    const rows = this.db.prepare(sql).all(...params) as Array<{ task_id: string; vector: Buffer; dimensions: number }>;
    return rows.map((r) => ({
      taskId: r.task_id,
      vector: Array.from(new Float32Array(r.vector.buffer, r.vector.byteOffset, r.dimensions)),
    }));
  }

  taskFtsSearch(query: string, limit: number, owner?: string): Array<{ taskId: string; score: number }> {
    const sanitized = sanitizeFtsQuery(query);