app/models/concerns/integration.rb


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
31

# frozen_string_literal: true

module Integration
  extend ActiveSupport::Concern

  class_methods do
    def with_custom_integration_for(integration, page = nil, per = nil)
      custom_integration_project_ids = Service
        .select(:project_id)
        .where(type: integration.type)
        .where(inherit_from_id: nil)
        .where.not(project_id: nil)
        .page(page)
        .per(per)

      Project.where(id: custom_integration_project_ids)
    end

    def without_integration(integration)
      services = Service
        .select('1')
        .where('services.project_id = projects.id')
        .where(type: integration.type)

      Project
        .where('NOT EXISTS (?)', services)
        .where(pending_delete: false)
        .where(archived: false)
    end
  end
end