Rails populate db rake task OpenURI::HTTPError: 500 Internal

Question

我正在尝试使 rake 任务从 JSON API fixer.io 填充数据库，但是当我输入我的耙子时：
耙子数据库：填充
发生此错误：

OpenURI::HTTPError: 500 Internal Server Error
/home/jakub/Documents/workspace/exch/lib/tasks/populate.rake:16:in `block (5 levels) in <top (required)>'
/home/jakub/Documents/workspace/exch/lib/tasks/populate.rake:13:in `block (4 levels) in <top (required)>'
/home/jakub/Documents/workspace/exch/lib/tasks/populate.rake:12:in `each'
/home/jakub/Documents/workspace/exch/lib/tasks/populate.rake:12:in `block (3 levels) in <top (required)>'
/home/jakub/Documents/workspace/exch/lib/tasks/populate.rake:11:in `each'
/home/jakub/Documents/workspace/exch/lib/tasks/populate.rake:11:in `block (2 levels) in <top (required)>'
Tasks: TOP => db:populate
(See full trace by running task with --trace)

这是我在lib/tasks中的耙子任务（populate.rake）：

require 'open-uri'
namespace :db do
  desc "Erase and fill database"
  task :populate => :environment do
    require 'populator'
    [ConversionRate].each(&:delete_all)
    n = JSON.load(open('http://api.fixer.io/latest'))["rates"].keys.count
    currencies = JSON.load(open('http://api.fixer.io/latest'))["rates"].keys
    currencies.each do |curr1|
      currencies.each do |curr2|
        ConversionRate.populate 1 do |cr|
          cr.currency1 = curr1
          cr.currency2 = curr2
          cr.conversion_rate = JSON.load(open('http://api.fixer.io/latest?base=' + curr1))["rates"][curr2]
      end
    end
  end
  end
end

请帮助我，我不知道是什么导致了这个问题。

Answer 1

主要问题就在这里，你没有拿"rates"的钥匙

currencies = JSON.load(open('http://api.fixer.io/latest')).keys
currencies = JSON.load(open('http://api.fixer.io/latest'))["rates"].keys

---

require 'open-uri'
namespace :db do
  desc "Erase and fill database"
  task :populate => :environment do
    require 'populator'
    [ConversionRate].each(&:delete_all)
    latest_data = JSON.load(open('http://api.fixer.io/latest'))
    currencies = latest_data["rates"].keys
    n = currencies.count
    currencies.each do |curr1|
      currencies.each do |curr2|
        ConversionRate.populate 1 do |cr|
          #take care of any error, as we are going to call third party api here
          begin
            cr.currency1 = curr1
            cr.currency2 = curr2
            cr.conversion_rate = JSON.load(open('http://api.fixer.io/latest?base=' + curr1))["rates"][curr2]
          rescue => e
            puts "error #{e}"
          end
        end
      end
      #give a bit rest
      sleep 2
    end
  end
end