summaryrefslogtreecommitdiff
path: root/app/models/trending_project.rb
blob: 810dee672b21d93c1ff98e5b92362a9ffed6f87c (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
31
32
33
34
35
36
37
# frozen_string_literal: true

class TrendingProject < ApplicationRecord
  belongs_to :project

  # The number of months to include in the trending calculation.
  MONTHS_TO_INCLUDE = 1

  # The maximum number of projects to include in the trending set.
  PROJECTS_LIMIT = 100

  # Populates the trending projects table with the current list of trending
  # projects.
  def self.refresh!
    # The calculation **must** run in a transaction. If the removal of data and
    # insertion of new data were to run separately a user might end up with an
    # empty list of trending projects for a short period of time.
    transaction do
      delete_all

      timestamp = connection.quote(MONTHS_TO_INCLUDE.months.ago)

      connection.execute <<-EOF.strip_heredoc
        INSERT INTO #{table_name} (project_id)
        SELECT project_id
        FROM notes
        INNER JOIN projects ON projects.id = notes.project_id
        WHERE notes.created_at >= #{timestamp}
        AND notes.system IS FALSE
        AND projects.visibility_level = #{Gitlab::VisibilityLevel::PUBLIC}
        GROUP BY project_id
        ORDER BY count(*) DESC
        LIMIT #{PROJECTS_LIMIT};
      EOF
    end
  end
end