Last modified: 2013-04-22 16:17:04 UTC
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
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) > https://gerrit.wikimedia.org/r/52401 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.
(In reply to comment #1) > https://gerrit.wikimedia.org/r/52396 Superseded by https://gerrit.wikimedia.org/r/#/c/52616/
(In reply to comment #1) > https://gerrit.wikimedia.org/r/52401 Superseded by https://gerrit.wikimedia.org/r/#/c/53128
* https://gerrit.wikimedia.org/r/#/c/53128 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).
(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.