Convert Hashes to CSV easily

csv.rb

# Convert Hashes to CSV easily

# source.rb
#
# { valid: "ruby", hash: "" }
# { another: "valid", ruby: "hash" }
# { etc...

# usage:
# 
#     Csv.new.start
#
# 
# then take a look at output.csv

require_relative "env"

class Csv
  SEP = ","
  PATH = File.expand_path "../", __FILE__
  DEFAULT_PATH = "#{PATH}/source.rb"
  CSV_PATH = "#{PATH}/output.csv"
  
  def initialize(file=nil, csv_path=nil)
    @file = file || DEFAULT_PATH
    @csv_path = csv_path || CSV_PATH
  end
  
  def start
    cont = File.read(@file)
    nomins = eval "[#{cont.split("\n").join(",")}]"
    
    File.open(@csv_path, "w"){ |f| f.write "" }
    File.open @csv_path, "a" do |csv|
      csv.puts header(nomins.first)
      nomins.each do |nomin|
        nome = to_csv nomin
        
        csv.puts nome
      end
    end
  end
  
  private
  
  def header(hash)
    hash.keys.join SEP
  end
  
  def to_csv(hash)
    hash.values.map do |value|
      escape value unless value.nil?
    end.join SEP
  end

  def escape(string)
    string.gsub(SEP, "\SEP")
  end
  
end

# Csv.new.start

to do the opposite: "convert CSV to Hashes", check this:

• https://gist.github.com/3101950
• and this Gem: https://github.com/tilo/smarter_csv