Arrays to database

Rails
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

On Jan 25, 2010, at 8:06 PM, Me wrote:

Wrtlist.create(:title => key, :link => val)

def self.up
drop_table :wrtlist

To unsubscribe from this group, send email to [email protected]
.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en
.

Rob B. http://agileconsultingllc.com
[email protected]

4

Ya but hashes are cool, man.

On Jan 25, 7:16 pm, Rob B. [email protected]