RoR - import csv to MySQL DB with smarterCSV gem

Question

I'm trying to upload a csv file with a lot of posible clients (15000) on a MySQL table. I want to keep on a table for later retrieve info, complete forms and make users.

Now i'm on the beginning, trying to import the csv to the MySQL.

I read some solutions that takes smarterCSV gem, so i must do a migration with the db structure and then execute the rake task or not needed to execute the migration for this?

The kind of code i want to use for import the csv is something like i read on before posts like Ruby on Rails - Import Data from a CSV file

require 'smarter_csv'
  options = {}
  SmarterCSV.process('input_file.csv', options) do |chunk|
    chunk.each do |data_hash|
      Moulding.create!( data_hash )
    end
  end

JFYI, if you're concerned about speed, mysql can import csv natively. It'll be super-duper fast. Obviously, db structure must exist prior to import. — Sergio Tulentsev, Feb 17 '17 at 14:48
but if you need to repeat it on a deploy? when you are updating the code? — Marcos R. Guevara, Feb 17 '17 at 14:53
i'm making this on development, but when we have all done, we must need to upload the code to github repository and run the deploy with capistrano. I want to do this on an authomatic/good way. — Marcos R. Guevara, Feb 17 '17 at 15:02
yes, i need to reseed the database when we update production, create the table and info inside when update the code on production. — Marcos R. Guevara, Feb 17 '17 at 15:17

score 1 · Answer 1 · answered Mar 16 '17 at 09:12

1

You may use my importer gem. It also uses SmarterCSV.

https://github.com/michaelnera/active_record_importer

answered Mar 16 '17 at 09:12

Michael Nera

11
1

RoR - import csv to MySQL DB with smarterCSV gem

1 Answers1