Module: SqlCsv

Defined in:
lib/sql_csv.rb,
lib/sql_csv/version.rb

Overview

Create a CSV export from an SQL query.

Defined Under Namespace

Classes: Error

Constant Summary collapse

VERSION = 
'0.2.4'

Class Method Summary collapse

Class Method Details

.export(query) ⇒ Object 



14
15
16
17
18
19
20
21
22
23
 
# File 'lib/sql_csv.rb', line 14

def self.export(query)
  ActiveRecord::Base.establish_connection
  rows = ActiveRecord::Base.connection.execute(query)
  csv = CSV.new($stdout)
  csv << rows.fields
  rows.map { |row| row.is_a?(Hash) ? row.values : row }.each do |row|
    csv << row.map { |item| item.is_a?(String) ? item : item.to_s }
  end
  csv.close
end