topic.rb 995 Bytes
Newer Older
1 2
# frozen_string_literal: true

3 4
require 'carrierwave/orm/activerecord'

5 6
module Projects
  class Topic < ApplicationRecord
7
    include Avatarable
8
    include Gitlab::SQL::Pattern
9

10
    validates :name, presence: true, uniqueness: true, length: { maximum: 255 }
11
    validates :description, length: { maximum: 1024 }
12 13 14

    has_many :project_topics, class_name: 'Projects::ProjectTopic'
    has_many :projects, through: :project_topics
15 16 17 18 19 20 21 22 23 24 25 26 27 28

    scope :order_by_total_projects_count, -> { order(total_projects_count: :desc).order(id: :asc) }
    scope :reorder_by_similarity, -> (search) do
      order_expression = Gitlab::Database::SimilarityScore.build_expression(search: search, rules: [
        { column: arel_table['name'] }
      ])
      reorder(order_expression.desc, arel_table['total_projects_count'].desc, arel_table['id'])
    end

    class << self
      def search(query)
        fuzzy_search(query, [:name])
      end
    end
29 30
  end
end
31 32

::Projects::Topic.prepend_mod_with('Projects::Topic')