Read a CSV and match details from DB and save new columns back to new CSV

csv.rake

namespace :csv do
  desc "TODO"

  # to run: rake csv:match

  task match: :environment do
    puts "Starting..."

    csv_text = File.read('./tmp/exported-report.csv')
    csv = CSV.parse(csv_text, :headers => true, :return_headers => true)

    save_file = "./tmp/sorted-data.csv"

    CSV.open( save_file, 'w' ) do |writer|
      csv.each do |row|
        user = User.find_by_email(row['Please confirm your email address'].downcase)
        if user
          row['user_name'] = user.full_name
          row['user_id'] = user.id
          puts "Updated #{user.full_name}'s record."
        end
        writer << row
      end
    end

    puts "... Finished!"

  end

end