mirror of
https://github.com/Freika/dawarich.git
synced 2026-01-10 01:01:39 -05:00
19 lines
494 B
Ruby
19 lines
494 B
Ruby
# frozen_string_literal: true
|
|
|
|
class Country < ApplicationRecord
|
|
has_many :points, dependent: :nullify
|
|
|
|
validates :name, :iso_a2, :iso_a3, :geom, presence: true
|
|
|
|
def self.containing_point(lon, lat)
|
|
where("ST_Contains(geom, ST_SetSRID(ST_MakePoint(?, ?), 4326))", lon, lat)
|
|
.select(:id, :name, :iso_a2, :iso_a3)
|
|
.first
|
|
end
|
|
|
|
def self.names_to_iso_a2
|
|
Rails.cache.fetch('countries_names_to_iso_a2', expires_in: 1.day) do
|
|
pluck(:name, :iso_a2).to_h
|
|
end
|
|
end
|
|
end
|