Aklapper has uploaded a new change for review. https://gerrit.wikimedia.org/r/291781
Change subject: Weekly Phabricator email: List archived projects with open tasks ...................................................................... Weekly Phabricator email: List archived projects with open tasks Bug: T133649 Change-Id: Ic2b23d843d08c0f2e8329fb36f1ea6a7447e17f5 --- M modules/phabricator/templates/project_changes.sh.erb 1 file changed, 36 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/81/291781/1 diff --git a/modules/phabricator/templates/project_changes.sh.erb b/modules/phabricator/templates/project_changes.sh.erb index a60e402..e08fc1b 100644 --- a/modules/phabricator/templates/project_changes.sh.erb +++ b/modules/phabricator/templates/project_changes.sh.erb @@ -73,6 +73,38 @@ END ) +#echo "result_archived_projects_open_tasks" +# see https://phabricator.wikimedia.org/T133649 +result_archived_projects_open_tasks=$(MYSQL_PWD=${sql_pass} /usr/bin/mysql -h $sql_host -u$sql_user $sql_name << END + +SELECT p.name, count(p.name) AS n + FROM phabricator_maniphest.edge edg + JOIN phabricator_maniphest.maniphest_task t + JOIN phabricator_project.project p + WHERE edg.dst LIKE 'PHID-PROJ-%' + AND edg.src LIKE 'PHID-TASK-%' + AND p.phid = edg.dst + AND p.status = 100 + AND t.phid = edg.src + AND (t.status = "open" OR t.status = "stalled") + AND edg.src NOT IN + (SELECT edg2.src + FROM phabricator_maniphest.edge edg2 + JOIN phabricator_maniphest.maniphest_task t2 + JOIN phabricator_project.project p2 + WHERE edg2.dst LIKE 'PHID-PROJ-%' + AND edg2.src LIKE 'PHID-TASK-%' + AND edg2.dst != "PHID-PROJ-onnxucoedheq3jevknyr" + AND p2.phid = edg2.dst + AND p2.status = 0 + AND t2.phid = edg2.src + AND (t2.status = "open" OR t2.status = "stalled")) + GROUP BY p.name + ORDER BY n DESC; + +END +) + #echo "result_single_workboard_column" # see https://phabricator.wikimedia.org/T105865 result_single_workboard_column=$(MYSQL_PWD=${sql_pass} /usr/bin/mysql -h $sql_host -u$sql_user $sql_name << END @@ -113,6 +145,10 @@ ${result_column_changes} +ARCHIVED PROJECTS WITH OPEN TASKS: +${result_archived_projects_open_tasks} + + PROJECT WORKBOARDS WITH A SINGLE COLUMN ONLY: ${result_single_workboard_column} -- To view, visit https://gerrit.wikimedia.org/r/291781 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ic2b23d843d08c0f2e8329fb36f1ea6a7447e17f5 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Aklapper <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
