# encoding: UTF-8
require 'json'
require 'tzinfo'
require 'sinatra'
require 'sequel'
require 'sinatra/reloader'
require 'pry'
require './methods'


Sequel.extension :named_timezones
Sequel.application_timezone = 'America/Los_Angeles'
DB = Sequel.connect('mysql2://localhost/promoter_development?user=root&password=')

get '/hi' do
	coun = []
	dataset = DB.from(:countries).select(:id, :name_uk, :created_at)

	binding.pry
	dataset.to_a.to_json
end


# this return
#=> [{:created_at=>2014-04-24 09:05:07 +0300}, {:created_at=>2014-10-16 14:34:45 +0300}, {:created_at=>2015-06-26 13:30:15 +0300}]