load_geo_data.rake

namespace :db do
  desc 'Move data from the carmen gem into the database'
  task load_geo_data: :environment do

    puts '-----------About to load geo-data from Carmen gem into the database----------------'
    Carmen::Country.all.each do |country|

      new_country = Country.create(name: country.name)

      country.subregions.each do |subregion|
        new_subregion = Subregion.create(country: new_country, name: subregion.name)

        subregion.subregions.each do |city|
          new_city = City.create(subregion: new_subregion, name: city.name)
        end
      end
    end

    puts '---------About to add extra city data--------------------------------------------'
    city_data = [
      ["China", "Anhui",  "Hefei",     2.5,  125.00],
      ["China", "Fujian", "Fuzhou",    1.5,  65.00],
      ["China", "Fujian", "Xiamen",    3,    85.00],
      ["China", "Fujian", "Zhangzhou", 3,    95.00],
    ]

    city_data.each do |country_name, subregion_name, city_name, estimated_travel_time, estimated_expenses|
      city = City.find_by!(country_name: country_name, subregion_name: subregion_name, name: city_name)
      city.update_attributes(estimated_travel_time: estimated_travel_time, estimated_expenses: estimated_expenses)
    end
  end 
end