partners.rake

namespace:partnersdo

task:load=>:environmentdo
require'csv'
require'open-uri'
open("")do |file|
CSV.parse(file,:headers=>true)do |row|
username=row[0]
user=User.find_by_username(username)
user.partner_asm_username=row[1]
user.partner_slack_username=row[2]
user.partner_email=row[3]
user.partner_last_contribution_at=Date.strptime(row[4],"%m/%d/%Y")
user.partner_coins=row[5]
user.save!
end
end
end

task:update=>:environmentdo
flatten_to_latest(Github.user_pr_log).eachdo |username,contribution_date|
ifuser=User.where(github: username).first
user.partner_last_contribution_at=contribution_date
user.save!
end
end
end

defflatten_to_latest(results)
results.inject({})do |users,row|
user_id=row[:username]
ifusers[user_id].blank? || users[user_id] < row[:created_at]
users[user_id]=row[:created_at]
end
users
end
end

task:email=>:environmentdo
User.where("partner_coins IS NOT NULL AND partner_last_contribution_at < ?",1.year.ago).all.eachdo |user|
UserMailer.partnership_expired(user).deliver_now
end
end
end