[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Inserting multiple rows from array

David Lelong

11/20/2006 4:12:00 PM

Hi,

I have two sets of values:

job.id = 1 and contact_ids = [4, 8]

I want to be able to iterate over all of values in the contact_id array
and create database records consisting of a job_id and contact_id.

So, in this example, the end result would be two new records that
contain:

--------------------
|job_id |contact_id|
--------------------
| 1 | 4 |
--------------------
| 1 | 8 |
--------------------

Any advice?

Thanks,

David

--
Posted via http://www.ruby-....
4 Answers

Paul Lutus

11/20/2006 5:02:00 PM

0

David Lelong wrote:

> Hi,
>
> I have two sets of values:
>
> job.id = 1 and contact_ids = [4, 8]
>
> I want to be able to iterate over all of values in the contact_id array
> and create database records consisting of a job_id and contact_id.
>
> So, in this example, the end result would be two new records that
> contain:
>
> --------------------
> |job_id |contact_id|
> --------------------
> | 1 | 4 |
> --------------------
> | 1 | 8 |
> --------------------
>
> Any advice?

1. Create an array of records, each a field array containing the job IDs and
the respective contact IDs.

2. Submit the array to the database in a way that the database understands.

Did you want specific Ruby code to accomplish this? If so, just say so.

record_array = []

job_id = 1

contact_id.each |id| do
record_array << [ job_id, id ]
end

In order to take the next step, we'll need more information, like, what
database?

--
Paul Lutus
http://www.ara...

David Lelong

11/20/2006 5:17:00 PM

0

Paul Lutus wrote:
>
> Did you want specific Ruby code to accomplish this? If so, just say so.
>
> record_array = []
>
> job_id = 1
>
> contact_id.each |id| do
> record_array << [ job_id, id ]
> end
>
> In order to take the next step, we'll need more information, like, what
> database?

A little more code would be helpful. The database is MySQL and the
table is Assignedjobs.

--
Posted via http://www.ruby-....

J. B. Rainsberger

11/21/2006 6:08:00 AM

0

David Lelong wrote:
> Hi,
>
> I have two sets of values:
>
> job.id = 1 and contact_ids = [4, 8]
>
> I want to be able to iterate over all of values in the contact_id array
> and create database records consisting of a job_id and contact_id.
>
> So, in this example, the end result would be two new records that
> contain:
>
> --------------------
> |job_id |contact_id|
> --------------------
> | 1 | 4 |
> --------------------
> | 1 | 8 |
> --------------------
>
> Any advice?

contact_ids.map { |each|
AssignedJob.new({:job_id => job.id, :contact_id => each})
}.each { |each|
each.save!
}

This is ActiveRecord code, or pretty close to it. First, turn the data
into row objects, then ask each one to save itself.

I hope that helps.
--
J. B. (Joe) Rainsberger :: http://www....
Your guide to software craftsmanship
JUnit Recipes: Practical Methods for Programmer Testing
2005 Gordon Pask Award for contribution Agile Software Practice

Zach Dennis

11/24/2006 4:06:00 AM

0

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Joey wrote:
> contact_ids.map { |num|
> AssignedJob.create({:job_id => job.id, :contact_id => num})
> }

ActiveRecord::Extensions (for MySQL) handles bulk inserts using
multi-value insert statements. It goes up to 40x faster then current
ActiveRecord behavior.

API looks like:
MyModel.import( columns, array_of_value_sets, options_hash )

Documentation on it can be found here:
http://www.continuousthinking.com/...

Here are some MySQL benchmarks for current ActiveRecord#create vs.
ActiveRecord::Extensions#import comparing MyISAM to InnoDb to Memory tables:
http://www.continuousthinking.com/...-benchmarks-for-mysql

You can download the latest version from:
http://rubyforge.org/proje...

What db adapter do you use? I am currently adding PostgreSQL support
over this holiday weekend.

Zach



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail....

iD8DBQFFZnBtMyx0fW1d8G0RAkmxAJ403MJLT6jPjjuawRNBNDVH+y9JNgCfVb+j
cj0Kxm8B6zkLGZgIOOreMIw=
=kdbQ
-----END PGP SIGNATURE-----