require 'csv'
require 'active_record'

data = CSV.read('weather.csv', { col_sep: ':' })
ActiveRecord::Base.establish_connection(   {"adapter"=>"sqlite3", "database"=>"db.sqlite3"})

class Temperature < ActiveRecord::Base
      validates_uniqueness_of :time
end

data.each do |d|
  values = { time: d[0], t: d[11] }
  Temperature.create values
end