Class: WorldDb::Model::CountryCode

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
lib/worlddb/models/forward.rb,
lib/worlddb/models/country_code.rb

Class Method Summary collapse

Class Method Details

.update!Object



16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
# File 'lib/worlddb/models/country_code.rb', line 16

def self.update!
  ## update (auto-create) country codes from existing countries in db

  ## fix: add/configure logger for ActiveRecord!!!
  logger = LogKernel::Logger.root

  logger.debug( "delete all (old) country codes" )
  CountryCode.delete_all

  Country.order(:id).each do |cty|
    logger.debug( "add country #{cty.key} #{cty.name}" )
    CountryCode.create!( country_id: cty.id, kind: 'NET',  name: cty.net    )  unless cty.net.nil?
    CountryCode.create!( country_id: cty.id, kind: 'NUM',  name: cty.num    )  unless cty.num.nil?
    CountryCode.create!( country_id: cty.id, kind: 'A2',   name: cty.alpha2 )  unless cty.alpha2.nil?
    CountryCode.create!( country_id: cty.id, kind: 'A3',   name: cty.alpha3 )  unless cty.alpha3.nil?
    CountryCode.create!( country_id: cty.id, kind: 'FIFA', name: cty.fifa   )  unless cty.fifa.nil?
    CountryCode.create!( country_id: cty.id, kind: 'IOC',  name: cty.ioc    )  unless cty.ioc.nil?
    CountryCode.create!( country_id: cty.id, kind: 'FIPS', name: cty.fips   )  unless cty.fips.nil?
    CountryCode.create!( country_id: cty.id, kind: 'M',    name: cty.motor  )  unless cty.motor.nil?
  end
end