• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

fortuity on 05/31/07

Tagged

textmate rails countries timezones

Versions (?)

05/31/07 11:54am

Who likes this?

5 people have marked this snippet as a favorite

jarjar2k7
tkmr
jatkins
webstic
schroedinger

 / Published in: Ruby

 

countries = Country.find(:all)
for country in countries  
    begin
      tzc = TZInfo::Country.get(country.code.upcase)
    rescue 
      puts "can't find TZInfo for #{country.code.upcase}"
      next
    end
    puts tzc.name
    for zone in tzc.zone_names
      puts country.code.upcase
      puts zone
      CountryTimeZone.create(:parent_id => country.id, :name => zone)
    end
end

Report this snippet   Tweet

Comments

Subscribe to comments

Posted By: fortuity on May 31, 2007

The class TZInfo::Country requires the tzinfo gem and TZInfo plugin (http://tzinfo.rubyforge.org). Country and CountryTimeZone classes are my own (subclassed from my Geography class). This snippet gets the two-letter country code for each country and uses it to find all the time zones for the country and then creates a new CountryTimeZone instance for each, specifying the country as a parent_id so we can do a tree list of countries and their "children" time zones. This snippet is run from the console and populates a data table.