Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/glacials/splits-io. a speedrunning data store and analysis engine splits.io
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990require 'speedrunslive'
class Game < ApplicationRecord include SRLGame
validates :name, presence: true
has_many :categories has_many :runs, through: :categories has_many :aliases, class_name: 'GameAlias'
after_create :create_initial_alias
scope :named, -> { where.not(name: nil) } scope :shortnamed, -> { where.not(shortname: nil) }
def self.search(term) term = term.strip return nil if term.blank? ids = where('LOWER(shortname) = LOWER(?)', term).or(where('name ILIKE ?', "%#{term}%")).pluck(:id) ids = ids | GameAlias.where('name ILIKE ?', "%#{term}%").pluck(:game_id) Game.where(id: ids) end
def self.from_name(name) name = name.strip return nil if name.blank? joins(:aliases).where(game_aliases: {name: name}).first end
def self.from_name!(name) name = name.strip return nil if name.blank? joins(:aliases).where(game_aliases: {name: name}).first_or_create(name: name) end
def to_param shortname || id.to_s || name.downcase.gsub('/', '') end
def sync_with_srl return if shortname.present? game = ::SpeedRunsLive.game(name) return if game.nil?
update(shortname: game['abbrev']) end
def to_s name end
def popular_categories categories.joins(:runs).group('categories.id').having('count(runs.id) >= ' + (Run.where(category: categories).count * 0.05).to_s).order('count(runs.id) desc') end
def unpopular_categories categories.joins(:runs).group('categories.id').having('count(runs.id) < ' + (Run.where(category: categories).count * 0.05).to_s).order('count(runs.id) desc') end
# merge_into! changes ownership of all of this game's categories and aliases to the given game, then destroys this # game. def merge_into!(game) ApplicationRecord.transaction do if shortname.present? && game.shortname.nil? game.update(shortname: shortname) end
aliases.update_all(game_id: game.id)
categories.each do |category| equivalent_category = game.categories.find_by(name: category.name)
if equivalent_category.present? category.merge_into!(equivalent_category) else category.update(game: game) end end destroy end end
private
def create_initial_alias aliases.create(name: name) endend