Class: HeatSettingsUpdater

Inherits:
Object
  • Object
show all
Defined in:
app/services/heat_settings_updater.rb

Class Method Summary collapse

Class Method Details

.like_ratio_thresholds ⇒ Object 



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
 
# File 'app/services/heat_settings_updater.rb', line 41

def self.like_ratio_thresholds
  results = DB.query(<<~SQL)
    SELECT ranked.bucket * 5 as percentile, MIN(ranked.ratio) as like_ratio
    FROM (
      SELECT NTILE(20) OVER (ORDER BY t.ratio DESC) AS bucket, t.ratio
      FROM (
        SELECT like_count::decimal / posts_count AS ratio
          FROM topics
         WHERE deleted_at IS NULL
           AND archetype <> 'private_message'
           AND visible = TRUE
           AND posts_count >= 10
           AND like_count > 0
      ORDER BY created_at DESC
         LIMIT 1000
      ) t
    ) ranked
    WHERE bucket <= 9
    GROUP BY bucket
  SQL

  results.inject({}) do |h, row|
    h[row.percentile] = row.like_ratio
    h
  end
end

.update ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
 
# File 'app/services/heat_settings_updater.rb', line 4

def self.update
  return unless SiteSetting.automatic_topic_heat_values

  views_by_percentile = views_thresholds
  update_setting(:topic_views_heat_high, views_by_percentile[10])
  update_setting(:topic_views_heat_medium, views_by_percentile[25])
  update_setting(:topic_views_heat_low, views_by_percentile[45])

  like_ratios_by_percentile = like_ratio_thresholds
  update_setting(:topic_post_like_heat_high, like_ratios_by_percentile[10])
  update_setting(:topic_post_like_heat_medium, like_ratios_by_percentile[25])
  update_setting(:topic_post_like_heat_low, like_ratios_by_percentile[45])
end

.update_setting(name, new_value) ⇒ Object 



68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
 
# File 'app/services/heat_settings_updater.rb', line 68

def self.update_setting(name, new_value)
  if new_value.nil? || new_value <= SiteSetting.defaults[name]
    if SiteSetting.get(name) != SiteSetting.defaults[name]
      SiteSetting.set_and_log(name, SiteSetting.defaults[name])
    end
  elsif SiteSetting.get(name) == 0 || (new_value.to_f / SiteSetting.get(name) - 1.0).abs >= 0.05
    rounded_new_value =
      if new_value.is_a?(Integer)
        if new_value > 9
          digits = new_value.digits.reverse
          (digits[0] * 10 + digits[1]) * 10.pow(digits[2..-1].size)
        else
          new_value
        end
      else
        new_value.round(2)
      end

    SiteSetting.set_and_log(name, rounded_new_value) if SiteSetting.get(name) != rounded_new_value
  end
end

.views_thresholds ⇒ Object 



18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
# File 'app/services/heat_settings_updater.rb', line 18

def self.views_thresholds
  results = DB.query(<<~SQL)
    SELECT ranked.bucket * 5 as percentile, MIN(ranked.views) as views
    FROM (
      SELECT NTILE(20) OVER (ORDER BY t.views DESC) AS bucket, t.views
      FROM (
        SELECT views
          FROM topics
         WHERE deleted_at IS NULL
           AND archetype <> 'private_message'
           AND visible = TRUE
      ) t
    ) ranked
    WHERE bucket <= 9
    GROUP BY bucket
  SQL

  results.inject({}) do |h, row|
    h[row.percentile] = row.views
    h
  end
end