Every Monday a script sends some Bugzilla stats to wikitech-l.
The script is at best confusing and misleading, see
http://lists.wikimedia.org/pipermail/wikitech-l/2013-January/065496.html and
http://lists.wikimedia.org/pipermail/wikitech-l/2013-January/065499.html
Version: wmf-deployment
Severity: normal
To get started:
https://gerrit.wikimedia.org/r/52390
https://gerrit.wikimedia.org/r/52392
https://gerrit.wikimedia.org/r/52393
https://gerrit.wikimedia.org/r/52394
https://gerrit.wikimedia.org/r/52395
https://gerrit.wikimedia.org/r/52396
https://gerrit.wikimedia.org/r/52397
https://gerrit.wikimedia.org/r/52399
https://gerrit.wikimedia.org/r/52400
https://gerrit.wikimedia.org/r/52401
Still TODO:
Trigger getHighestPrioTickets() function and include it in results, as I'm too stupid (no PHP skills) to give it a proper formatting.
(In reply to comment #1)
This seems the biggest piece of meat. :) It would be nice if we managed to get a list of bugs requiring attention; I don't know if Highest/Immediate is the best choice possible but I guess it should work.
Still TODO:
Trigger getHighestPrioTickets() function and include it in results, as I'm
too
stupid (no PHP skills) to give it a proper formatting.
I hope someone can help.
Superseded by https://gerrit.wikimedia.org/r/#/c/53387/ and the only one item left to merge before closing this report as FIXED.
Re https://gerrit.wikimedia.org/r/#/c/53387/ before I forget:
Exclude bug reports in group 15 (security group) from the query:
SELECT products.name AS product, components.name AS component, bugs.bug_id AS bugID, bugs.priority, bugs.delta_ts, profiles.login_name AS assignee, bugs.short_desc as bugsummary FROM bugs JOIN profiles ON assigned_to = profiles.userid JOIN products ON bugs.product_id = products.id JOIN components ON bugs.component_id = components.id LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id WHERE ( security_map.group_id != 15 OR security_map.group_id IS NULL ) AND ( resolution = "" OR resolution = "FIXED" ) AND ( priority = "Highest" OR priority = "Immediate" ) ORDER BY product, component, delta_ts LIMIT 200;
Updated patch, hopefully correct (at least works fine here), in https://gerrit.wikimedia.org/r/#/c/53387/
Latest version at https://gerrit.wikimedia.org/r/56348 , now hopefully not listing already closed tickets anymore in the list of urgent issues (a quick test by Daniel looked positive; I still cannot reproduce the problem locally).
Valerie.m.juarez wrote:
(In reply to comment #7)
Updated patch, hopefully correct (at least works fine here)...
How do you test your changes? I've been looking into bug 29355, and I have an idea of what changes need to be made, but I can't test them.
(In reply to comment #9)
(In reply to comment #7)
Updated patch, hopefully correct (at least works fine here)...
How do you test your changes? I've been looking into bug 29355
Lacking some good test setup, I installed Bugzilla locally (originally for testing migration to 4.2). I guess in this specific case (accessing MySQL database via script), http://kubo.wmflabs.org//bugzilla/ won't help either, but I'm happy to help and test your patch.
I've split off the "list of urgent issues" into bug 47176 as I continue to fail due to my miserable SQL skills (or so).
Hence considering this ticket FIXED.