Aklapper has uploaded a new change for review. https://gerrit.wikimedia.org/r/59656
Change subject: Bugzilla Weekly Report email: Add number of enhancement and lowest prio tickets as requested by Željko in http://lists.wikimedia.org/pipermail/wikitech-l/2013-April/068296.html ...................................................................... Bugzilla Weekly Report email: Add number of enhancement and lowest prio tickets as requested by Željko in http://lists.wikimedia.org/pipermail/wikitech-l/2013-April/068296.html Change-Id: Ie8b5c2d1842414bf76babcbcc237586dd12cb5f2 --- M templates/misc/bugzilla_report.php 1 file changed, 86 insertions(+), 3 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/56/59656/1 diff --git a/templates/misc/bugzilla_report.php b/templates/misc/bugzilla_report.php index 49ce0a0..ef1cad0 100755 --- a/templates/misc/bugzilla_report.php +++ b/templates/misc/bugzilla_report.php @@ -119,7 +119,7 @@ END; } -function getTotalOpenBugs() { +function getTotalOpenReports() { return <<<END SELECT count(*) @@ -130,6 +130,56 @@ bug_status = 'ASSIGNED' or bug_status = 'NEW' or bug_status = 'REOPENED'; +END; +} + +function getTotalOpenEnhancements() { + return <<<END +SELECT + count(*) +FROM + bugs +WHERE + (bug_status = 'UNCONFIRMED' or + bug_status = 'ASSIGNED' or + bug_status = 'NEW' or + bug_status = 'REOPENED') +AND + bug_severity = 'enhancement'; +END; +} + +function getTotalOpenBugs() { + return <<<END +SELECT + count(*) +FROM + bugs +WHERE + (bug_status = 'UNCONFIRMED' or + bug_status = 'ASSIGNED' or + bug_status = 'NEW' or + bug_status = 'REOPENED') +AND + bug_severity != 'enhancement'; +END; +} + +function getTotalOpenBugsNonLowestPriority() { + return <<<END +SELECT + count(*) +FROM + bugs +WHERE + (bug_status = 'UNCONFIRMED' or + bug_status = 'ASSIGNED' or + bug_status = 'NEW' or + bug_status = 'REOPENED') +AND + bug_severity != 'enhancement' +AND + priority != 'lowest'; END; } @@ -257,7 +307,13 @@ 'INVALID', 'WORKSFORME', 'WONTFIX',); -$totalStatistics = array ('getTotalOpenBugs',); +$totalStatistics = array ('getTotalOpenReports',); + +$totalStatisticsEnhancements = array ('getTotalOpenEnhancements',); + +$totalStatisticsBugs = array ('getTotalOpenBugs',); + +$totalStatisticsBugsNonLowestPriority = array ('getTotalOpenBugsNonLowestPriority',); $createdStatistics = array('getBugsCreated',); @@ -274,11 +330,38 @@ } foreach ($totalStatistics as $report) { + $sql = getTotalOpenReports(); + $result = mysql_query($sql); + if (!$result) + reportFailure("Query failure"); + print "\nTotal reports still open : "; + formatOutput($result); +} + +foreach ($totalStatisticsBugs as $report) { $sql = getTotalOpenBugs(); $result = mysql_query($sql); if (!$result) reportFailure("Query failure"); - print "\nTotal reports still open: "; + print "Total bugs still open : "; + formatOutput($result); +} + +foreach ($totalStatisticsBugsNonLowestPriority as $report) { + $sql = getTotalOpenBugsNonLowestPriority(); + $result = mysql_query($sql); + if (!$result) + reportFailure("Query failure"); + print "Total non-lowest prio. bugs still open: "; + formatOutput($result); +} + +foreach ($totalStatisticsEnhancements as $report) { + $sql = getTotalOpenEnhancements(); + $result = mysql_query($sql); + if (!$result) + reportFailure("Query failure"); + print "Total enhancements still open : "; formatOutput($result); } -- To view, visit https://gerrit.wikimedia.org/r/59656 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ie8b5c2d1842414bf76babcbcc237586dd12cb5f2 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
