Skip to content

Instantly share code, notes, and snippets.

@mgiacomini

mgiacomini/rails_fast_csv_importer.rb

Created September 10, 2017 01:15
Show Gist options
  • Save mgiacomini/a81a5f86b6c072dde848ca67c9a8f798 to your computer and use it in GitHub Desktop.
Save mgiacomini/a81a5f86b6c072dde848ca67c9a8f798 to your computer and use it in GitHub Desktop.
Download ZIP
use copy command to fast imports
Raw
rails_fast_csv_importer.rb
db_conn = ActiveRecord::Base.connection.raw_connection
copy_statement = 'COPY forecasts FROM STDIN'
file_path = '/tmp/forecast.csv'
db_conn.copy_data(copy_statement) do
CSV.foreach(file_path, headers: true) do |row|
db_conn.put_copy_data(row.fields + [Time.zone.now])
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment