Sha256: 3a5d75365e2267b6922e0c72bbfba95c70992cddbc8a207514c87fb12f5c36c3
Contents?: true
Size: 899 Bytes
Versions: 6
Compression:
Stored size: 899 Bytes
Contents
class EveApp::SolarSystemJump < EveApp::ApplicationRecord
belongs_to :from_region, class_name: 'EveApp::Region', foreign_key: :from_region_id
belongs_to :from_solar_system, class_name: 'EveApp::SolarSystem', foreign_key: :from_solar_system_id
belongs_to :to_region, class_name: 'EveApp::Region', foreign_key: :to_region_id
belongs_to :to_solar_system, class_name: 'EveApp::SolarSystem', foreign_key: :to_solar_system_id
scope :unique, -> {
select('
DISTINCT
(CASE WHEN from_solar_system_id < to_solar_system_id THEN from_solar_system_id ELSE to_solar_system_id END) AS from_solar_system_id,
(CASE WHEN from_solar_system_id > to_solar_system_id THEN from_solar_system_id ELSE to_solar_system_id END) AS to_solar_system_id,
from_region_id, to_region_id, from_constellation_id, to_constellation_id
').order('from_solar_system_id, to_solar_system_id')
}
end
Version data entries
6 entries across 6 versions & 1 rubygems