quick csv data dump from rails console

csv_data_dump.rb

require 'csv'

file = "#{Rails.root}/public/users.csv"

userrefs = UserReference.where(:tenant_id => 7)

CSV.open( file, 'w' ) do |writer|
  userrefs.each do |ur|
    next unless ur.user.present?
    writer << [ur.user.username, ur.user.email]
  end
end

irb(main):057:0> file = "#{Rails.root}/public/stickers_dump2.csv"
=> "/var/www/platform/releases/20140306193809/public/stickers_dump2.csv"
irb(main):058:0> CSV.open( file, 'w' ) do |writer|
irb(main):059:1* writer << ["Sticker", "Name", "Email", "Address"]irb(main):060:1> requests.each do |request|
irb(main):061:2* writer << [request.stickers.map(&:name).join(', '), request.platform_user.name, request.platform_user.email, request.platform_user.address.try(:line_1).to_s + ', ' + request.platform_user.address.try(:line_2).to_s + ', ' + request.platform_user.address.try(:city).to_s + ', ' + request.platform_user.address.try(:state).to_s + ' ' + request.platform_user.address.try(:zipcode).to_s + ' ' + request.platform_user.address.try(:country).to_s]
irb(main):062:2> end
irb(main):063:1> end