City-UTC

Description

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.

Installation

  $ bundle install

Usage

Database usage example

  cities = CityUTC::City # Sequel::Model

  puts cities.count
  puts cities.select(:city, :population)
             .reverse(:population)
             .limit(3)
             .to_a

Web application usage example

  $ 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'

Requirements

Ruby 2.1.0
gzip
thin ~> 1.7.0
sinatra, ~> 1.4.7
sqlite3, ~> 1.3.13
sequel, ~> 4.42.1
timezone ~> 1.0

License

Released under the MIT License. See the LICENSE file for further details.

Medvedu/City-UTC