Notificaiton performance script

notification_performance_script.rb

CSV.open('/tmp/notifications.csv', 'w') do |csv|
  UserNotification.select("distinct type").map(&:type).each do |type|
    total = UserNotification.where(type: type, send_state: 'sent').group(:message).count
    opened = UserNotification.where(type: type, send_state: 'sent').where(open_state: 'open').group(:message).count
    csv << ["Type", "Sent", "Opened", "Message", "First Date Sent"]
    c = h.keys.count
    total.keys.each do |message|
      print "\r#{c-=1}     "
      csv << [type.split('::').last, total[message], opened[message] || 0, message, n.created_at] 
    end
  end
end



==================================================================================================
ssh deployment "scp worker01:/tmp/notifications.csv /tmp/notifications.csv";scp deployment:/tmp/notifications.csv ~/Downloads/