Contents

require 'carmen'

connection      = ActiveRecord::Base.connection
country_inserts = []

country_values = -> do
  Carmen::Country.all.each do |country|
    name            = connection.quote country.name
    iso3            = connection.quote country.alpha_3_code
    iso             = connection.quote country.alpha_2_code
    iso_name        = connection.quote country.name.upcase
    numcode         = connection.quote country.numeric_code
    states_required = connection.quote country.subregions?

    country_inserts << [name, iso3, iso, iso_name, numcode, states_required].join(", ")
  end

  country_inserts.join("), (")
end

columns = ["name", "iso3", "iso", "iso_name", "numcode", "states_required"]
columns = connection.adapter_name =~ /MySQL/i ? columns.join(", ") : "\"#{columns.join('", "')}\""

connection.execute <<-SQL
  INSERT INTO spree_countries (#{columns})
  VALUES (#{country_values.call});
SQL

Spree::Config[:default_country_id] = Spree::Country.find_by(iso: "US").id

Version data entries

31 entries across 31 versions & 2 rubygems

Version	Path
goca-spree-core-3.1.14.rails.5.0	db/default/spree/countries.rb
goca-spree-core-3.1.15.rails.5.0	db/default/spree/countries.rb
goca-spree-core-3.1.15.pre.rails.pre.5.0	db/default/spree/countries.rb
spree_core-3.1.14	db/default/spree/countries.rb
spree_core-3.1.13	db/default/spree/countries.rb
spree_core-3.1.12	db/default/spree/countries.rb
spree_core-3.1.11	db/default/spree/countries.rb
spree_core-3.1.10	db/default/spree/countries.rb
spree_core-3.1.9	db/default/spree/countries.rb
spree_core-3.1.8	db/default/spree/countries.rb
spree_core-3.1.7	db/default/spree/countries.rb
spree_core-3.1.6	db/default/spree/countries.rb
spree_core-3.1.5	db/default/spree/countries.rb
spree_core-3.1.4	db/default/spree/countries.rb
spree_core-3.1.3	db/default/spree/countries.rb
spree_core-3.1.2	db/default/spree/countries.rb
spree_core-3.0.10	db/default/spree/countries.rb
spree_core-3.1.1	db/default/spree/countries.rb
spree_core-3.1.0	db/default/spree/countries.rb
spree_core-3.1.0.rc4	db/default/spree/countries.rb