Method searchHubSkills

packages/memos-core/src/storage/sqlite.ts:2488–2515

(query: string, options?: { userId?: string; maxResults?: number })

  }

  searchHubSkills(query: string, options?: { userId?: string; maxResults?: number }): Array<{ hit: HubSkillSearchRow; rank: number }> {
    const limit = options?.maxResults ?? 10;
    const userId = options?.userId ?? "";
    const sanitized = sanitizeFtsQuery(query);
    let rows: HubSkillSearchRow[];
    if (sanitized) {
      rows = this.db.prepare(`
        SELECT hs.id, hs.name, hs.description, hs.version, hs.visibility, '' AS group_name, hu.username AS owner_name, hu.status AS owner_status, hs.quality_score,
               bm25(hub_skills_fts) as rank
        FROM hub_skills_fts f
        JOIN hub_skills hs ON hs.rowid = f.rowid
        LEFT JOIN hub_users hu ON hu.id = hs.source_user_id
        WHERE hub_skills_fts MATCH ?
        ORDER BY rank
        LIMIT ?
      `).all(sanitized, limit) as HubSkillSearchRow[];
    } else {
      rows = this.db.prepare(`
        SELECT hs.id, hs.name, hs.description, hs.version, hs.visibility, '' AS group_name, hu.username AS owner_name, hu.status AS owner_status, hs.quality_score,
               0 as rank
        FROM hub_skills hs
        LEFT JOIN hub_users hu ON hu.id = hs.source_user_id
        ORDER BY hs.updated_at DESC
        LIMIT ?
      `).all(limit) as HubSkillSearchRow[];
    }
    return rows.map((row, idx) => ({ hit: row, rank: idx + 1 }));
  }

  deleteHubSkillBySource(sourceUserId: string, sourceSkillId: string): void {
    this.db.prepare('DELETE FROM hub_skills WHERE source_user_id = ? AND source_skill_id = ?').run(sourceUserId, sourceSkillId);