Bulk Insert records into Active Record table

by

Use the activerecord-import gem. Let us say you are reading a CSV file and generating a Product catalogue and you want to insert records in batches of 1000:

batch,batch_size = [], 1_000 
CSV.foreach("/data/new_products.csv", :headers => true) do |row|
  batch << Product.new(row)

  if batch.size >= batch_size
    Product.import batch
    batch = []
  end
end
Product.import batch

More Related Contents:

  1. How to do a LIKE query in Arel and Rails?
  2. ActiveRecord Query Union
  3. How do I replace accented Latin characters in Ruby?
  4. How to chain scope queries with OR instead of AND?
  5. When to use a “has_many :through” relation in Rails?
  6. Alias for column names in Rails
  7. Clean way to find ActiveRecord objects by id in the order specified
  8. Altering the primary key in Rails to be a string
  9. What does inverse_of do? What SQL does it generate?
  10. ActiveRecord Find By Year, Day or Month on a Date field
  11. Rails 3 devise, current_user is not accessible in a Model ?
  12. LEFT OUTER joins in Rails 3
  13. How does Rails ActiveRecord chain “where” clauses without multiple queries?
  14. Overriding id on create in ActiveRecord
  15. How to test for (ActiveRecord) object equality
  16. How do i work with two different databases in rails with active records?
  17. How to execute a raw update sql with dynamic binding in rails
  18. Rails 3 – select with Include?
  19. What’s the difference between belongs_to and has_one?
  20. Regular expressions with validations in RoR 4
  21. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  22. Do rails rake tasks provide access to ActiveRecord models?
  23. how to add records to has_many :through association in rails
  24. How to use long id in Rails applications?
  25. Rails 3.1 limit user created objects
  26. Is there a way to avoid automatically updating Rails timestamp fields?
  27. Non persistent ActiveRecord model attributes
  28. Rails best way to get previous and next active record object
  29. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  30. Rails Object Relationships and JSON Rendering

Leave a Comment