Method CountActiveInstances

backend/store/stats.go:12–25

CountActiveInstances counts the number of instances.

(ctx context.Context, workspaceID string)

// CountActiveInstances counts the number of instances.
func (s *Store) CountActiveInstances(ctx context.Context, workspaceID string) (int, error) {
	q := qb.Q().Space("SELECT count(1) FROM instance WHERE instance.workspace = ?", workspaceID).And("instance.deleted = ?", false)

	query, args, err := q.ToSQL()
	if err != nil {
		return 0, errors.Wrapf(err, "failed to build sql")
	}

	var count int
	if err := s.GetDB().QueryRowContext(ctx, query, args...).Scan(&count); err != nil {
		return 0, err
	}
	return count, nil
}

// CountActivePrincipals counts non-deleted principals cross-workspace. Used for display purposes
// (e.g. actuator info) — not for seat limit enforcement.