Class: Packages::DependencyLink

Inherits:
ApplicationRecord show all
Includes:
EachBatch
Defined in:
app/models/packages/dependency_link.rb

Constant Summary

Constants inherited from ApplicationRecord

ApplicationRecord::MAX_PLUCK

Constants included from ResetOnUnionError

ResetOnUnionError::MAX_RESET_PERIOD

Class Method Summary collapse

Methods inherited from ApplicationRecord

cached_column_list, #create_or_load_association, declarative_enum, default_select_columns, id_in, id_not_in, iid_in, pluck_primary_key, primary_key_in, #readable_by?, safe_ensure_unique, safe_find_or_create_by, safe_find_or_create_by!, #to_ability_name, underscore, where_exists, where_not_exists, with_fast_read_statement_timeout, without_order

Methods included from SensitiveSerializableHash

#serializable_hash

Class Method Details

.dependency_ids_grouped_by_type(packages) ⇒ Object 



24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'app/models/packages/dependency_link.rb', line 24

def self.dependency_ids_grouped_by_type(packages)
  inner_query = where(package_id: packages)
                  .select('
                    package_id,
                    dependency_type,
                    ARRAY_AGG(dependency_id) as dependency_ids
                  ')
                  .group(:package_id, :dependency_type)

  cte = Gitlab::SQL::CTE.new(:dependency_links_cte, inner_query)
  cte_alias = cte.table.alias(table_name)

  with(cte.to_arel)
    .select('
      package_id,
      JSON_OBJECT_AGG(
        dependency_type,
        dependency_ids
    ) AS dependency_ids_by_type
    ')
    .from(cte_alias)
    .group(:package_id)
end