This project consist of two parts. First part includes sqlite database with two tables:
Cities
| id | city | country | latitude | longitude | population | timezone_code |
|---|---|---|---|---|---|---|
| .. | ... | ...... | ........ | ......... | .......... | ............. |
Timezones
| timezone | code |
|---|---|
| ....... | .... |
You can work with this tables throw Sequel ORM.
And second part is web application to work with the database. It receives city name and responce with UTC time for this city. If there more than one city with chosen name it returns a city with biggest population.
$ bundle install cities = CityUTC::City # Sequel::Model
puts cities.count
puts cities.select(:city, :population)
.reverse(:population)
.limit(3)
.to_a $ bundle exec rake launch_web_server!
$ curl 'http://localhost:30042/time?'
$ curl 'http://localhost:30042/time?Moscow,New%20York,vladivostok,berlin,wrong_city,washington,ufa'- Ruby 2.1.0
- gzip
- thin ~> 1.7.0
- sinatra, ~> 1.4.7
- sqlite3, ~> 1.3.13
- sequel, ~> 4.42.1
- timezone ~> 1.0
Released under the MIT License. See the LICENSE file for further details.