Ruby query db res and generate csv file

gistfile1.rb

# encoding: utf-8

require 'csv'

desc 'Get all user email'
task :send_coupon do
  date = Time.now.strftime("%Y%m%d%H%M%S")
  path = "tmp/send_coupon_emails_#{date}.csv"
  CSV.open(path, "wb") do |csv|
    header = ["email","created_at","survey_count","passport_id"]
    csv << header
    User.where(:email.ne => nil).each do |u|
      csv << [u.email, u.created_at.strftime("%Y-%m-%d"), u.surveys.count, u.passport_id]
    end
 end
end