Method Search

internal/metadata/store.go:196–233

Search queries the metadata_items table with LIKE matching. Results are deduplicated by name (case-insensitive): when the same name exists in several repos, only the canonical source is returned (see canonicalOrder). Install status is unaffected because InstalledAppsFor detects installs by on-disk d

(ctx context.Context, q SearchQuery)

// Install status is unaffected because InstalledAppsFor detects installs by
// on-disk directory name, independent of repo.
func (s *Store) Search(ctx context.Context, q SearchQuery) ([]Item, error) {
	if err := s.Init(ctx); err != nil {
		return nil, err
	}
	db, err := s.open()
	if err != nil {
		return nil, err
	}
	defer db.Close()

	limit := q.Limit
	if limit <= 0 {
		limit = 100
	}
	pattern := "%" + q.Query + "%"

	args := []any{pattern, pattern, pattern, pattern, pattern}
	if q.Kind != "" {
		args = append([]any{q.Kind}, args...)
	}
	args = append(args, limit, q.Offset)

	rows, err := db.QueryContext(ctx, `
		WITH ranked AS (
			SELECT `+itemColumns+`,
			       ROW_NUMBER() OVER (PARTITION BY lower(name) ORDER BY `+canonicalOrder+`) AS rn
			FROM metadata_items
			WHERE `+matchPredicate(q.Kind)+`
		)
		SELECT `+itemColumns+` FROM ranked WHERE rn = 1
		ORDER BY name LIMIT ? OFFSET ?`,
		args...)
	if err != nil {
		return nil, fmt.Errorf("metadata: search: %w", err)
	}
	defer rows.Close()
	return scanItems(rows)
}

// Count returns the number of deduplicated names matching the query (ignoring
// limit/offset), so the total matches what Search can display.