ruby-on-rails - 如何在rails3.0中插入多条记录

Question

在rails3.0中如何在一个表中插入多条记录？请告诉我任何示例应用程序。

Answer 1

您可以使用交易

titles = ["T-Shirt", "Boots", "Cap"]

ActiveRecord::Base.transaction do
  titles.each do |title|
    Thing.create(:title => title)
  end
end

做一个 sql 查询:

query = []
titles.each do |title|
  query << "('#{title}')"
end
sql = "INSERT INTO things ('title') VALUES #{query.join(", ")}"
ActiveRecord::Base.connection.execute(sql)

很有趣的文章

http://www.coffeepowered.net/2009/01/23/mass-inserting-data-in-rails-without-killing-your-performance/