ruby-on-rails - 将 JSON 导入 Heroku Rails 应用程序然后存储在数据库中

Question

我有一个托管在 Heroku 上的 Rails 3.2 应用程序。我想尝试避免为每个人手动输入所有数据新纪录。他们是让我的 Rails 应用程序查看像这样的 JSON 文件(除了大得多)并将该信息解析为数据库？

[   {
    "name": "Sierra Mist – Small Cup",
    "wwpplus": "5",
    "ssize": "451g",
    "calories": "190",
    "tfat": "0",
    "protein": "0",
    "fiber": "0",
    "carbs": "50",
    "restaurant_id": "12"
},
{
    "name": "Vanilla Shake regular",
    "wwpplus": "13",
    "ssize": "425g",
    "calories": "480",
    "tfat": "15",
    "protein": "14",
    "fiber": "0",
    "carbs": "74",
    "restaurant_id": "12"
},
{
    "name": "Vanilla Shake small",
    "wwpplus": "11",
    "ssize": "340g",
    "calories": "380",
    "tfat": "12",
    "protein": "11",
    "fiber": "0",
    "carbs": "60",
    "restaurant_id": "12"
}]

Answer 1

你可以在你的 db/seeds.rb 文件中解析它:

records = JSON.parse(File.read('path/to/file.json'))
records.each do |record|
  ModelName.create!(record)
end

然后 heroku run rake db:seed