# File engines/oauth/app/controllers/concerns/connected_sites.rb, line 8
def existing_site_connections
  set_sites
    .joins(:authorization_grants)
    .where(authorization_grants: {
      client_id: params[:client_id],
      member: current_member
    })
    .distinct
    .load
end

# File engines/oauth/app/controllers/concerns/connected_sites.rb, line 19
def set_sites
  @sites ||= if current_site_owner
    current_site_owner.owned_or_administered_sites.not_archived
  else
    DB::Site.none
  end
end