Trying to insert a ruby hash into a Postgres Database

Question

I have created this hash from scraped xml data I have retrieved from the web. My next task is to insert this data into a postgresql database where each key is a different column, and I have drawn a blank. Any help is appreciated. Thanks in advance.

temp = @ttc.css('vehicle').map do |vehicle|

{
    id: vehicle.attributes["id"].value,
    routeTag: vehicle.attributes["routeTag"].value,
    lat: vehicle.attributes["lat"].value,
    lon: vehicle.attributes["lon"].value
}

end

if I understand correctly @ttc.css('vehicle') is an array of objects? — mr. Holiday
– mr. Holiday, Commented Jul 23, 2015 at 13:57

Ruby Racer · Accepted Answer · 2015-07-23 13:37:41Z

1

Provided your model name is Vehicle and your vehicles table has columns named id, routeTag, lat, lon, your solution would be as simple as this:

@new_vehicle = Vehicle.create(temp)

answered Jul 23, 2015 at 13:37

Ruby Racer

5,7701 gold badge29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to insert a ruby hash into a Postgres Database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related