t11a · January 26, 2013 04:43
diff --git a/bulk_insert_sample.rb b/bulk_insert_sample.rb
 timestamp = ActiveRecord::Base.connection.quote(Time.now.utc)
 inserts = []
 10**4.times do |i|
  inserts << "('title#{i}', #{i}, #{i}, #{timestamp}, #{timestamp})"
 end
 sql = "INSERT INTO books (title, serial, price, created_at, updated_at) VALUES #{ inserts.join(',') }"
 Book.connection.execute(sql)
	timestamp = ActiveRecord::Base.connection.quote(Time.now.utc)
	inserts = []
	10**4.times do \|i\|
	inserts << "('title#{i}', #{i}, #{i}, #{timestamp}, #{timestamp})"
	end
	sql = "INSERT INTO books (title, serial, price, created_at, updated_at) VALUES #{ inserts.join(',') }"
	Book.connection.execute(sql)