QChris has uploaded a new change for review.
https://gerrit.wikimedia.org/r/84743
Change subject: Switch to single Json object for gerrit's reviewer count query
......................................................................
Switch to single Json object for gerrit's reviewer count query
Bug: 52329
Change-Id: Ifbb8176fc6212d93a7e11398a0b9118a5c8ba0a4
---
M manifests/gerrit.pp
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/43/84743/1
diff --git a/manifests/gerrit.pp b/manifests/gerrit.pp
index d0ca22b..bd92a65 100644
--- a/manifests/gerrit.pp
+++ b/manifests/gerrit.pp
@@ -293,7 +293,7 @@
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 changes.change_id AS change_id, COUNT(DISTINCT
patch_set_approvals.account_id) AS reviewer_count FROM changes LEFT JOIN
patch_set_approvals ON (changes.change_id = patch_set_approvals.change_id)
GROUP BY changes.change_id'\" > /var/www/reviewer-counts.json",
+ command => "ssh -p 29418 localhost gerrit gsql --format
JSON_SINGLE -c \"'SELECT changes.change_id AS change_id, COUNT(DISTINCT
patch_set_approvals.account_id) AS reviewer_count FROM changes LEFT JOIN
patch_set_approvals ON (changes.change_id = patch_set_approvals.change_id)
GROUP BY changes.change_id'\" > /var/www/reviewer-counts.json",
user => gerrit2,
hour => 1
}
--
To view, visit https://gerrit.wikimedia.org/r/84743
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifbb8176fc6212d93a7e11398a0b9118a5c8ba0a4
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: QChris <christ...@quelltextlich.at>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
