class CityUTC::City

Schema for `cities` table

CREATE TABLE `cities` (
  `id`              INTEGER PRIMARY KEY AUTOINCREMENT,
  `city`          TEXT,
  `country`             TEXT,
  `latitude`          REAL,
  `longitude`         REAL,
  `population`      INTEGER,
  `timezone_code` INTEGER
);

Public Class Methods

timezone_for_biggest(city_name) click to toggle source

Returns timezone for city.

When more than one city was found it returns timezone for city with biggest population.

@param [String] city_name

@return [String]

Returns +"NilZone"+ when nothing was found.
# File sources/city_utc/models/city.rb, line 28
def self.timezone_for_biggest(city_name)
  tz = City.select(:timezone)
           .where(city: city_name.downcase)
           .reverse(:population)
           .limit(1)
           .join(:timezones, code: :timezone_code)
           .first

  tz ? tz[:timezone] : "NilZone"
end