SUSE/hackweek

class Keyword < ApplicationRecord
  validates :name, presence: true
  validates :name, uniqueness: true
  validates :description, length: { maximum: 255 }

  scope :find_keyword, lambda { |str|
    where('lower(name) like ?', str.downcase) unless str.blank?
  }

  has_and_belongs_to_many :projects
  has_and_belongs_to_many :users

  has_one_attached :avatar

  scope :by_episode, lambda { |episode|
    joins(:keywords_projects).where(keywords_projects: { project: episode.projects.pluck(:id) }) if episode && episode.is_a?(Episode)
  }

  paginates_per 5

  def self.popular(episode, count)
    Keyword.by_episode(episode)
           .group(:name).count
           .sort_by { |_name, occurance| occurance }.reverse
           .first(count).map { |keyword| Keyword.find_by(name: keyword[0]) }
  end
end