解析然后将来自 API 的 XML 数据存储在 Ruby on Rails 中 [英] Parse then Store XML Data from API in Ruby on Rails

问题描述

我知道有很多关于这个主题的条目，但我还没有看到如何存储数据的完整图片.我正在尝试制作一个系统，该系统可以读取、解析和存储来自 Yahoo Upcoming API 的事件信息.

I know there have been a ton of entries about this topic but I haven't seen the complete picture yet of how to store the data. I am trying to make a system that reads then parses then stores information about events from the Yahoo Upcoming API.

该 url 返回一个非常简单的 xml，如下所示

The url returns a pretty simple xml that looks like this

<event>
<id>489875230</id>
<description>Open Bar</description>
<status>Live</status>
<latitude>29.74</latitude>
<longitude>-95.37</longitude>
</event>

我一直在阅读 REXML 和其他内容，但如何获取元素的值并将它们存储到我的模型中?目标是将 XML 中所有所需元素的值打印到文本框以允许编辑数据，然后让用户保存在数据库中......我只是很难弄清楚如何做某事解析后的数据.

I've been reading into REXML and others but how do I take the value of the elements and store them into my model? The goal is the print the values from all the desired elements in the XML to textboxes to allow the data to be edited then, then letting the user save in the database...I just am having a hard time figuring out how to do something with the data once its parsed.

任何帮助、链接或建议都会对我有很大帮助.

Any help, link, or suggestions would really help me out alot.

推荐答案

建立一个具有相同属性的模型，将xml解析为hash，然后用hash创建模型?

set up a model with the same attributes, parse the xml to a hash, then create the model with the hash?

class CreateEvent < ActiveRecord::Migration
  def self.up
    create_table :events do |t|
    t.id :id
    t.string :decription
    t.string :status
    t.decimal :latitude
    t.decimal :longitude      #( you'll want to set the precision and scale properly here)
  end
end


data = Hash.from_xml <<EOX
<event>
<id>489875230</id>
<description>Open Bar</description>
<status>Live</status>
<latitude>29.74</latitude>
<longitude>-95.37</longitude>
</event>
EOX

Event.create!(hash[:event])

这篇关于解析然后将来自 API 的 XML 数据存储在 Ruby on Rails 中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！