aboutsummaryrefslogtreecommitdiffstats
path: root/bin/update-abbr
blob: 33dbda1fe5ddaebc62dc414916613b9f82a8d3a9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
require 'nokogiri'
require 'open-uri'

doc = Nokogiri::HTML(URI.open('https://www.timeanddate.com/time/zones/'))

h = {}

doc.css('#tz-abb tbody tr').each do |tr|
  tds = tr.css('td')
  abbr = tds[0].text.strip.downcase
  offset = tds[3].text.strip.gsub(/UTC\s*/, '')
  next if offset.include?('/') # skip ambiguous timezones
  next if offset.empty?


  hour, min = offset.split(':', 2)
  offset = (Integer(hour) * 60 + (Integer(min || 0)))*60
  if h.has_key?(abbr)
    h[abbr] = false
  else
    h[abbr] = offset
  end
end

h.delete_if{|_,v| !v}

lines = File.readlines('ext/date/zonetab.list')
lines.select{|l| l.include?(',')}.
  map{|l| l.split(',', 2)[0]}.
  each{|a| h.delete(a)}

h.sort.map{|k,v| "#{k},#{v}"}
lines.insert(-2, h.sort.map{|k,v| "#{k},#{v}\n"})
lines.flatten!
File.write('ext/date/zonetab.list', lines.join)