Method Count

internal/metadata/store.go:237–263

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

(ctx context.Context, q SearchQuery)

// Count returns the number of deduplicated names matching the query (ignoring
// limit/offset), so the total matches what Search can display.
func (s *Store) Count(ctx context.Context, q SearchQuery) (int, error) {
	if err := s.Init(ctx); err != nil {
		return 0, err
	}
	db, err := s.open()
	if err != nil {
		return 0, err
	}
	defer db.Close()

	pattern := "%" + q.Query + "%"
	args := []any{pattern, pattern, pattern, pattern, pattern}
	if q.Kind != "" {
		args = append([]any{q.Kind}, args...)
	}

	var count int
	err = db.QueryRowContext(ctx, `
		SELECT COUNT(*) FROM (
			SELECT DISTINCT lower(name) FROM metadata_items WHERE `+matchPredicate(q.Kind)+`
		)`,
		args...).Scan(&count)
	if err != nil {
		return 0, fmt.Errorf("metadata: count: %w", err)
	}
	return count, nil
}

// GetItem returns a single item by kind and install_key.
func (s *Store) GetItem(ctx context.Context, kind, installKey string) (Item, error) {