Class: Analytics::CycleAnalytics::StageEventHash

Inherits:
ApplicationRecord
  • Object
show all
Defined in:
app/models/analytics/cycle_analytics/stage_event_hash.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

.cleanup_if_unused(id) ⇒ Object 



29
30
31
32
33
 
# File 'app/models/analytics/cycle_analytics/stage_event_hash.rb', line 29

def self.cleanup_if_unused(id)
  unused_hashes_for(id)
    .where(id: id)
    .delete_all
end

.record_id_by_hash_sha256(hash) ⇒ Object

Creates or queries the id of the corresponding stage event hash code



11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'app/models/analytics/cycle_analytics/stage_event_hash.rb', line 11

def self.record_id_by_hash_sha256(hash)
  casted_hash_code = Arel::Nodes.build_quoted(hash, Analytics::CycleAnalytics::StageEventHash.arel_table[:hash_sha256]).to_sql

  # Atomic, safe insert without retrying
  query = <<~SQL
  WITH insert_cte AS MATERIALIZED (
    INSERT INTO #{quoted_table_name} (hash_sha256) VALUES (#{casted_hash_code}) ON CONFLICT DO NOTHING RETURNING ID
  )
  SELECT ids.id FROM (
    (SELECT id FROM #{quoted_table_name} WHERE hash_sha256=#{casted_hash_code} LIMIT 1)
      UNION ALL
    (SELECT id FROM insert_cte LIMIT 1)
  ) AS ids LIMIT 1
  SQL

  connection.execute(query).first['id']
end

.unused_hashes_for(id) ⇒ Object 



35
36
37
38
39
 
# File 'app/models/analytics/cycle_analytics/stage_event_hash.rb', line 35

def self.unused_hashes_for(id)
  stage_exists_query = ::Analytics::CycleAnalytics::Stage.where(stage_event_hash_id: id).select('1').limit(1)

  where.not('EXISTS (?)', stage_exists_query)
end