insert into database with one instruction

rubyonrails-talk
1

hello, i'd like to insert into a table with a rails function several records and avoid a loop with Object.create. Something corresponding to SQL instruction like it :

INSERT INTO animals(id, value) VALUES(1, 'dog'), (2, 'cat'), (3, 'bird);

is it possible to do it with a create or another function? i'm looking for it but don't find anything about it.

2

You're going to have to do this by hand (ie connection.execute '...').

Fred