Ryan Lane has submitted this change and it was merged.

Change subject: Provide reviewer counts per patch
......................................................................


Provide reviewer counts per patch

Gerrit's API doesn't provide a nice way to get at this data without
making tons and tons of requests, so provide this in a nice JSON
format for people to make use of.

Bug: 52329
Change-Id: I3015f1fb443ce17369903275080bd9eebb3dbb7c
---
M manifests/gerrit.pp
1 file changed, 8 insertions(+), 0 deletions(-)

Approvals:
  Ryan Lane: Looks good to me, approved
  QChris: Looks good to me, but someone else must approve
  jenkins-bot: Verified



diff --git a/manifests/gerrit.pp b/manifests/gerrit.pp
index 76868f9..cf39d25 100644
--- a/manifests/gerrit.pp
+++ b/manifests/gerrit.pp
@@ -340,6 +340,14 @@
                minute => [0, 15, 30, 45]
        }
 
+       cron { list_reviewer_counts:
+               # This is useful information about the distribution of 
reviewers.
+               # Gerrit's rest api doesn't provide an easy way to get this 
data.
+               command => "ssh -p 29418 localhost gerrit gsql --format JSON -c 
\"'SELECT change_id.s AS change_id, COUNT(DISTINCT 
patch_set_approvals.account_id) AS reviewer_count FROM change_id LEFT JOIN 
patch_set_approvals ON (change_id.s = patch_set_approvals.change_id) GROUP BY 
change_id.s'\" > /var/www/reviewer-counts.json",
+               user => gerrit2,
+               hour => 1
+       }
+
        cron { clear_gerrit_logs:
                # Gerrit rotates their own logs, but doesn't clean them out
                # Delete logs older than a week

-- 
To view, visit https://gerrit.wikimedia.org/r/76945
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings

Gerrit-MessageType: merged
Gerrit-Change-Id: I3015f1fb443ce17369903275080bd9eebb3dbb7c
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Demon <ch...@wikimedia.org>
Gerrit-Reviewer: Demon <ch...@wikimedia.org>
Gerrit-Reviewer: MZMcBride <w...@mzmcbride.com>
Gerrit-Reviewer: QChris <christ...@quelltextlich.at>
Gerrit-Reviewer: Ryan Lane <rl...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot

_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits

Reply via email to