Let's total up the reviews_with_owner for participants for each code review and store it in the code review table. Do this in rake:analysis (can't be done in the parser).
Let's also compute the owner_familiarity_gap: which I'm going to declare is the Max(reviews_with_owner) - Min(reviews_with_owner) for a given code review.
Need:
New columns in db schema should be called total_reviews_with_owner and owner_familiarity_gap
Verify on the dev data
For example:
If Moe had a code review with Larry, Curly, and Ringo. He had 10 prior reviews with Larry, 9 prior reviews with Curly, and 1 prior review with Ringo. The owner_familiarity would be 20 and the familiarity_gap would be 9.
Let's total up the
reviews_with_owner
for participants for each code review and store it in the code review table. Do this inrake:analysis
(can't be done in the parser).Let's also compute the owner_familiarity_gap: which I'm going to declare is the Max(reviews_with_owner) - Min(reviews_with_owner) for a given code review.
Need:
total_reviews_with_owner
andowner_familiarity_gap
For example: If Moe had a code review with Larry, Curly, and Ringo. He had 10 prior reviews with Larry, 9 prior reviews with Curly, and 1 prior review with Ringo. The
owner_familiarity
would be 20 and thefamiliarity_gap
would be 9.