Method skillFtsSearch

packages/memos-core/src/storage/sqlite.ts:1850–1886

(query: string, limit: number, scope: "self" | "public" | "mix", currentOwner: string)

  }

  skillFtsSearch(query: string, limit: number, scope: "self" | "public" | "mix", currentOwner: string): Array<{ skillId: string; score: number }> {
    const sanitized = sanitizeFtsQuery(query);
    if (!sanitized) return [];

    try {
      let sql = `
        SELECT s.id as skill_id, rank
        FROM skills_fts f
        JOIN skills s ON s.rowid = f.rowid
        WHERE skills_fts MATCH ? AND s.status = 'active'`;
      const params: any[] = [sanitized];

      if (scope === "self") {
        sql += ` AND s.owner = ?`;
        params.push(currentOwner);
      } else if (scope === "public") {
        sql += ` AND s.visibility = 'public'`;
      } else {
        sql += ` AND (s.owner = ? OR s.visibility = 'public')`;
        params.push(currentOwner);
      }

      sql += ` ORDER BY rank LIMIT ?`;
      params.push(limit);

      const rows = this.db.prepare(sql).all(...params) as Array<{ skill_id: string; rank: number }>;
      if (rows.length === 0) return [];
      const maxAbsRank = Math.max(...rows.map((r) => Math.abs(r.rank)));
      return rows.map((r) => ({
        skillId: r.skill_id,
        score: maxAbsRank > 0 ? Math.abs(r.rank) / maxAbsRank : 0,
      }));
    } catch {
      this.log.warn(`Skill FTS query failed for: "${sanitized}", returning empty`);
      return [];
    }
  }

  // ─── Task Embeddings & Search ───