arrays to database

rubyonrails-talk
1

Hello I'm a RoR newbe facing a problem.

I would like to upload two arrays to a database called 'wrtlist' i used this migration file to create the database

class AddWrtsList < ActiveRecord::Migration   def self.up       create_table :wrtlist do |t|       t.string :title       t.string :link       t.string :publisher

      t.timestamps     end   end

  def self.down   drop_table :wrtlist   end end

The first array contains the titles and the second contains the links, the first title correspondents to the first title and the second to the second....: @titles, @links

I also want to add the static content "publisher_name" to publisher.

What should be the best way to create a loop to upload the content to the database?

Thank you for your help!

2

Got this from the ruby forum. Make a hash out of the two.

key = ["1","2","3"] value = ["a","b","c"] Hash[*key.zip(value).flatten] => {"1"=>"a", "2"=>"b", "3"=>nil}

then you can do:

Hash.each do |key,val|   Wrtlist.create(:title => key, :link => val) end

3

Of course, you don't actually *need* the Hash

titles = ["1","2","3"] links = ["a","b","c"] titles.zip(links).each do |title, link|    Wrtlist.create(:title => title, :link => link,                   :publisher => 'publisher_name') end

-Rob

4

Ya but hashes are cool, man.