cesartalves/whatever.rb

Created July 5, 2021 13:51

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cesartalves/c9cd01ff64afd95e12b556bf70471e57.js"></script>
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