Skip to content

Instantly share code, notes, and snippets.

@cesartalves

cesartalves/whatever.rb

Created July 5, 2021 13:51
Show Gist options
  • Save cesartalves/c9cd01ff64afd95e12b556bf70471e57 to your computer and use it in GitHub Desktop.
Save cesartalves/c9cd01ff64afd95e12b556bf70471e57 to your computer and use it in GitHub Desktop.
Download ZIP
Run SQL query and save to CSV rails
Raw
whatever.rb
results = ActiveRecord::Base.connection.execute(sql)
CSV.open('csv.csv', 'w+') do |f|
f << results[0].keys
results.each do |r|
f << r.values
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment