John F. Lewis has uploaded a new change for review.
https://gerrit.wikimedia.org/r/235451
Change subject: phabricator: replace Needs Volunteer with Lowest
......................................................................
phabricator: replace Needs Volunteer with Lowest
Change-Id: Ic6777da51b3e04922ac47518d0d4605a78c4479f
---
M modules/phabricator/templates/community_metrics.sh.erb
1 file changed, 6 insertions(+), 6 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/51/235451/1
diff --git a/modules/phabricator/templates/community_metrics.sh.erb
b/modules/phabricator/templates/community_metrics.sh.erb
index 9094538..b184d0e 100644
--- a/modules/phabricator/templates/community_metrics.sh.erb
+++ b/modules/phabricator/templates/community_metrics.sh.erb
@@ -119,8 +119,8 @@
END
)
-#echo "rm_volunteer"
-result_mediantasksopen_needsvolunteer=$(MYSQL_PWD=${sql_pass} /usr/bin/mysql
-h $sql_host -u$sql_user $sql_name << END
+#echo "rm_lowest"
+result_mediantasksopen_lowest=$(MYSQL_PWD=${sql_pass} /usr/bin/mysql -h
$sql_host -u$sql_user $sql_name << END
SELECT avg(t1.dateCreated) as '' FROM (SELECT @rownum:=@rownum+1 as
row_number, d.dateCreated FROM maniphest_task d, (SELECT @rownum:=0) r WHERE
(d.priority = "10" AND d.status = "open") ORDER BY d.dateCreated) as t1,
(SELECT COUNT(*) AS total_rows FROM maniphest_task d WHERE (d.priority = "10"
AND d.status = "open")) as t2 WHERE 1 AND t1.row_number IN (
floor((total_rows+1)/2), floor((total_rows+2)/2));
@@ -170,9 +170,9 @@
diff_low=$((epochnow-mediantasksopen_low_epoch))
mediantasksopen_low=$(echo $((diff_low/86400)))
-mediantasksopen_needsvolunteer_epoch=$(echo
$result_mediantasksopen_needsvolunteer | cut -d " " -f3 | sed 's/.0000//' | sed
's/.5000//')
-diff_needsvolunteer=$((epochnow-mediantasksopen_needsvolunteer_epoch))
-mediantasksopen_needsvolunteer=$(echo $((diff_needsvolunteer/86400)))
+mediantasksopen_lowest_epoch=$(echo $result_mediantasksopen_lowest | cut -d "
" -f3 | sed 's/.0000//' | sed 's/.5000//')
+diff_lowest=$((epochnow-mediantasksopen_lowest_epoch))
+mediantasksopen_lowest=$(echo $((diff_lowest/86400)))
lastmonth=$(date --date="last month" +%Y-%m)
@@ -203,7 +203,7 @@
High: ${mediantasksopen_high}
Normal: ${mediantasksopen_normal}
Low: ${mediantasksopen_low}
-Needs Volunteer: ${mediantasksopen_needsvolunteer}
+Lowest: ${mediantasksopen_lowest}
(How long tasks have been open, not how long they have had that priority)
TODO: Numbers which refer to closed tasks might not be correct, as described
in T1003.
--
To view, visit https://gerrit.wikimedia.org/r/235451
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic6777da51b3e04922ac47518d0d4605a78c4479f
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: John F. Lewis <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
