Demon has uploaded a new change for review.

  https://gerrit.wikimedia.org/r/76945


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(-)


  git pull ssh://gerrit.wikimedia.org:29418/operations/puppet 
refs/changes/45/76945/1

diff --git a/manifests/gerrit.pp b/manifests/gerrit.pp
index 76868f9..b3edb96 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 => "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: newchange
Gerrit-Change-Id: I3015f1fb443ce17369903275080bd9eebb3dbb7c
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Demon <ch...@wikimedia.org>

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

Reply via email to