Arrays to database

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



def self.down
drop_table :wrtlist

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!

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

key = [“1”,“2”,“3”]
value = [“a”,“b”,“c”]
=> {“1”=>“a”, “2”=>“b”, “3”=>nil}

then you can do:

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

Of course, you don’t actually need the Hash

titles = [“1”,“2”,“3”]
links = [“a”,“b”,“c”] do |title, link|
Wrtlist.create(:title => title, :link => link,
:publisher => ‘publisher_name’)


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

Rob B.
[email protected]

Ya but hashes are cool, man.

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