Spree 样本数据获取在 bundle exec rake db:seed 上给出错误

Question 1

哦，狂欢。

国家/州种子文件中生成的 SQL 语句有问题。

这是我的替代品，虽然速度慢，但有效

spree_core/db/default/spree/countries.rb

require 'carmen'

Carmen::Country.all.map do |country|
  name = country.name
  iso3 = country.alpha_3_code
  iso = country.alpha_2_code
  iso_name = country.name.upcase
  numcode = country.numeric_code
  states_required = country.subregions?

  # country_inserts << [name, iso3, iso, iso_name, numcode, states_required].join(", ")
  Spree::Country.new(      :name => name,
      :iso3 => iso3,
      :iso => iso,
      :iso_name => iso_name,
      :numcode => numcode,
      :states_required => states_required
  ).save!
end

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

和

spree_core/db/default/spree/states.rb

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

Spree::Country.where(states_required: true).each do |country|
  carmen_country = Carmen::Country.named(country.name)
  carmen_country.subregions.each do |subregion|
    name = connection.quote subregion.name
    abbr = connection.quote subregion.code
    country_id = connection.quote country.id

    state_inserts << [name, abbr, country_id].join(", ")
    Spree::State.new(:name => name, :abbr => abbr, :country_id => country_id).save!
  end
end

Answer

哦，狂欢。

国家/州种子文件中生成的 SQL 语句有问题。

这是我的替代品，虽然速度慢，但有效

spree_core/db/default/spree/countries.rb

require 'carmen'

Carmen::Country.all.map do |country|
  name = country.name
  iso3 = country.alpha_3_code
  iso = country.alpha_2_code
  iso_name = country.name.upcase
  numcode = country.numeric_code
  states_required = country.subregions?

  # country_inserts << [name, iso3, iso, iso_name, numcode, states_required].join(", ")
  Spree::Country.new(      :name => name,
      :iso3 => iso3,
      :iso => iso,
      :iso_name => iso_name,
      :numcode => numcode,
      :states_required => states_required
  ).save!
end

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

和

spree_core/db/default/spree/states.rb

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

Spree::Country.where(states_required: true).each do |country|
  carmen_country = Carmen::Country.named(country.name)
  carmen_country.subregions.each do |subregion|
    name = connection.quote subregion.name
    abbr = connection.quote subregion.code
    country_id = connection.quote country.id

    state_inserts << [name, abbr, country_id].join(", ")
    Spree::State.new(:name => name, :abbr => abbr, :country_id => country_id).save!
  end
end

Question 2

Spree 的规格通常使用最新的 SQLite 版本。我猜这个问题没有被发现，因为我们从未测试过 3.7.11 之前的版本。我想这个问题实际上是 SQLite DB 过时了。我看不出 Spree 想要支持旧版本的 SQLite。

我猜你的数据库是 3.7.11 之前的版本。如果是，你能更新它吗？

Answer

Spree 的规格通常使用最新的 SQLite 版本。我猜这个问题没有被发现，因为我们从未测试过 3.7.11 之前的版本。我想这个问题实际上是 SQLite DB 过时了。我看不出 Spree 想要支持旧版本的 SQLite。

我猜你的数据库是 3.7.11 之前的版本。如果是，你能更新它吗？

Spree 样本数据获取在 bundle exec rake db:seed 上给出错误

答案1

答案2

相关内容