Allows you to convert data from SQL into CSV format

sql_to_csv.rb

# First connect to DB with needed sql data
class T < ActiveRecord::Base
  establish_connection({adapter:'mysql2', database:'db_for_test', encoding:'utf8',user:'', password: ''})
  set_table_name  'utility_company'
end


CSV.open("data.csv", "wb") do |csv|
  csv << T.first.attribute_names # adds the attributes name on the first line
  T.all.each do |hash|
    csv << hash.attributes.values
  end
end