summaryrefslogtreecommitdiff
path: root/app/finders/user_groups_counter.rb
blob: e8e552510cd0800e58e4aab971c952646596bb3d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
# frozen_string_literal: true

class UserGroupsCounter
  def initialize(user_ids)
    @user_ids = user_ids
  end

  def execute
    Namespace.unscoped do
      Namespace.from_union([
                             groups,
                             project_groups
                           ]).group(:user_id).count # rubocop: disable CodeReuse/ActiveRecord
    end
  end

  private

  attr_reader :user_ids

  def groups
    Group.for_authorized_group_members(user_ids)
      .select('namespaces.*, members.user_id as user_id')
  end

  def project_groups
    Group.for_authorized_project_members(user_ids)
      .select('namespaces.*, project_authorizations.user_id as user_id')
  end
end