haslo/lists_juggle_browser

View on GitHub
app/models/rankers/ship_combos_ranker.rb

Summary

Maintainability
A
3 hrs
Test Coverage
module Rankers
class ShipCombosRanker
 
attr_reader :ship_combos, :ships, :number_of_tournaments, :number_of_squadrons
 
Method `initialize` has 68 lines of code (exceeds 25 allowed). Consider refactoring.
Method `initialize` has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.
def initialize(ranking_configuration, ship_id: nil, ship_combo_id: nil, pilot_id: nil, upgrade_id: nil, limit: nil)
start_date = ranking_configuration[:ranking_start]
end_date = ranking_configuration[:ranking_end]
tournament_type = ranking_configuration[:tournament_type]
joins = <<-SQL
inner join squadrons
on squadrons.ship_combo_id = ship_combos.id
inner join ship_combos_ships
on ship_combos_ships.ship_combo_id = ship_combos.id
inner join tournaments
on squadrons.tournament_id = tournaments.id
inner join factions
on squadrons.faction_id = factions.id
inner join factions as primary_factions
on factions.primary_faction_id = primary_factions.id
SQL
weight_query_builder = WeightQueryBuilder.new(ranking_configuration)
attributes = {
id: 'ship_combos.id',
archetype_name: 'ship_combos.archetype_name',
weight: weight_query_builder.build_weight_query,
squadrons: 'count(distinct squadrons.id)',
tournaments: 'count(distinct tournaments.id)',
faction: 'primary_factions.name',
average_percentile: weight_query_builder.build_average_query,
average_wlr: weight_query_builder.build_win_loss_query,
}
ship_combos_relation = ShipCombo
.joins(joins)
.group('ship_combos.id, ship_combos.archetype_name, primary_factions.name')
.order('weight desc')
.where('tournaments.date >= ? and tournaments.date <= ?', start_date, end_date)
if ship_id.present?
ship_join = <<-SQL
inner join ship_configurations
on ship_configurations.squadron_id = squadrons.id
inner join pilots
on pilots.id = ship_configurations.pilot_id
SQL
ship_combos_relation = ship_combos_relation.joins(ship_join).where('pilots.ship_id = ?', ship_id)
end
if pilot_id.present?
pilot_join = <<-SQL
inner join ship_configurations
on ship_configurations.squadron_id = squadrons.id
SQL
ship_combos_relation = ship_combos_relation.joins(pilot_join).where('ship_configurations.pilot_id = ?', pilot_id)
end
if limit.present?
ship_combos_relation = ship_combos_relation.limit(limit)
end
if ship_combo_id.present?
ship_combos_relation = ship_combos_relation.where('ship_combos.id = ?', ship_combo_id)
end
if upgrade_id.present?
upgrade_join = <<-SQL
inner join ship_configurations
on ship_configurations.squadron_id = squadrons.id
inner join ship_configurations_upgrades
on ship_configurations_upgrades.ship_configuration_id = ship_configurations.id
SQL
ship_combos_relation = ship_combos_relation.joins(upgrade_join).where('ship_configurations_upgrades.upgrade_id = ?', upgrade_id)
end
if tournament_type.present?
ship_combos_relation = ship_combos_relation.where('tournaments.tournament_type_id = ?', tournament_type)
end
@ship_combos = ShipCombo.fetch_query(ship_combos_relation, attributes)
@ships = Hash[ShipCombo.where(id: @ship_combos.map(&:id)).includes(:ships).map { |c| [c.id, c.ships.map { |s| { id: s.id, name: s.name, font_icon_class: s.font_icon_class } }] }]
 
@number_of_tournaments, @number_of_squadrons = Rankers::GenericRanker.new(start_date, end_date, tournament_type).numbers
end
 
end
end