Aklapper has uploaded a new change for review.
https://gerrit.wikimedia.org/r/69457
Change subject: Add product name to component output in Weekly Bugzilla Report
mail
......................................................................
Add product name to component output in Weekly Bugzilla Report mail
bug: 49758
Change-Id: Ifa25b82af54a5772d815b4fde64c6aa089745976
---
M templates/misc/bugzilla_report.php
1 file changed, 7 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/57/69457/1
diff --git a/templates/misc/bugzilla_report.php
b/templates/misc/bugzilla_report.php
index 25f643f..bc025dd 100755
--- a/templates/misc/bugzilla_report.php
+++ b/templates/misc/bugzilla_report.php
@@ -28,13 +28,17 @@
print "Created reports per component\n\n";
return <<<END
SELECT
- name, count(*) as total
+ products.name, components.name, count(*) as total
FROM
bugs
JOIN
components
on
- component_id = components.id
+ bugs.component_id = components.id
+JOIN
+ products
+ on
+ bugs.product_id = products.id
WHERE
creation_ts
BETWEEN
@@ -245,7 +249,7 @@
if (is_array($row)) {
foreach ($row as $row_i) {
$row_i = str_replace ( '@', ' [AT] ', $row_i);
//strip out any easy scrapes
- print pack('A36',($row_i));
+ print pack('A30',($row_i));
}
}
else {
--
To view, visit https://gerrit.wikimedia.org/r/69457
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ifa25b82af54a5772d815b4fde64c6aa089745976
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
