exports the time tracker data from https://github.com/whoward/time-tracker into ical format

export2ical.rb

#!/usr/bin/env ruby

require 'bundler/inline'

gemfile "https://rubygems.org" do
   gem 'icalendar', '2.4.1'
   gem 'sqlite3', '1.3.13'
end

db = SQLite3::Database.new File.join(ENV['HOME'], ".time-tracker.db")

cal = Icalendar::Calendar.new

db.execute("select reason, start, finish from entries").each do |reason, start, finish|
  cal.event do |e|
    e.summary = reason
    e.dtstart = Time.parse(start)
    e.dtend   = Time.parse(finish)
  end
end


File.write(ARGV.first || 'export.ics', cal.to_ical)