Rails - Jul 2009 - create 1000 items in DB

Hi,

I want to create 1000 items at once(vouchers) in my db. My class name is
Voucher. How can ik realize this...?


remco
-- 
Posted via http://www.ruby-forum.com/.

Hey Remco,

What format is your input data in?
Will this happen regularly or is this a one-time insert?

It sounds like you might want to look at ActiveRecord Extensions:
http://github.com/zdennis/ar-extensions/tree/master

Regards,
Gustav Paul


On Sat, Jul 18, 2009 at 10:25 AM, Gustav Paul
<gustav-PUm+PnBUKx7YkQIYctQFYw@public.gmane.org> wrote:
> Hey Remco,
>
> What format is your input data in?
> Will this happen regularly or is this a one-time insert?
>
> It sounds like you might want to look at ActiveRecord Extensions:
> http://github.com/zdennis/ar-extensions/tree/master
>
> Regards,
> Gustav Paul
>
>
> On Sat, Jul 18, 2009 at 10:00 AM, Remco Swoany <
> rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:
>
>>
>> Hi,
>>
>> I want to create 1000 items at once(vouchers) in my db. My class name
is
>> Voucher. How can ik realize this...?
>>
>>
>> remco
>> --
>> Posted via http://www.ruby-forum.com/.
>>
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

and there is always the obvious solution:

1000.times do
  Voucher.create(:attribute1 => ''value1'')
end

MaD wrote:
> and there is always the obvious solution:
> 
> 1000.times do
>   Voucher.create(:attribute1 => ''value1'')
> end
In this case, however, the obvious solution is not the best: each call 
to Voucher.create is a separate DB query.  It''s far better to create
one
query to insert all the objects; unfortunately, Rails makes this 
somewhat difficult.  You can either use a plugin such as ar-extensions 
or build the SQL yourself.

Best,
--
Marnen Laibow-Koser
http://www.marnen.org
marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org
-- 
Posted via http://www.ruby-forum.com/.