X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/ed68d524de0703685ff15f1ab574c61ec67e2c22..109dcfff196708f94179ed4c621a2e6d405b7118:/db/migrate/031_create_countries.rb diff --git a/db/migrate/031_create_countries.rb b/db/migrate/031_create_countries.rb index e4106f486..923d943f7 100644 --- a/db/migrate/031_create_countries.rb +++ b/db/migrate/031_create_countries.rb @@ -1,4 +1,5 @@ -require 'lib/migrate' +require 'migrate' +require 'rexml/document' class CreateCountries < ActiveRecord::Migration def self.up @@ -12,22 +13,6 @@ class CreateCountries < ActiveRecord::Migration end add_index :countries, [:code], :name => "countries_code_idx", :unique => true - - Net::HTTP.start('ws.geonames.org') do |http| - xml = REXML::Document.new(http.get("/countryInfo").body) - - xml.elements.each("geonames/country") do |ele| - code = ele.get_text("countryCode").to_s - minlon = ele.get_text("bBoxWest").to_s - minlat = ele.get_text("bBoxSouth").to_s - maxlon = ele.get_text("bBoxEast").to_s - maxlat = ele.get_text("bBoxNorth").to_s - - Country.create(:code => code, - :min_lat => minlat.to_f, :max_lat => maxlat.to_f, - :min_lon => minlon.to_f, :max_lon => maxlon.to_f) - end - end end def self.down