On 11/03/13 at 21:49 +0800, Paul Wise wrote:
> On Mon, Mar 11, 2013 at 9:19 PM, Lucas Nussbaum wrote:
>
> > to make fixing RC bugs more rewarding. For example, in the Debian Project
> > News, we could list the most efficient RC bug squashers.
>
> Just discussed this in #debian-publicity, if you can write a query to
> run against UDD, the publicity team is definitely interested in doing
> that.
What is easy to do, is get the top RC bugs *closers* for the last n
days. But there are more ways to be an efficient RC bug squasher.
Query for the top 10 closers in March:
udd=> select done, count(*) from bugs where severity >= 'serious' and
last_modified >= '2013-03-01' and status='done' group by done
order by count desc limit 10;
done | count
-------------------------------------------+-------
Michael Gilbert <[email protected]> | 8
LaMont Jones <[email protected]> | 6
Julien Cristau <[email protected]> | 4
Ludovico Cavedon <[email protected]> | 4
Raphaël Hertzog <[email protected]> | 4
gregor herrmann <[email protected]> | 3
Sebastian Ramacher <[email protected]> | 3
Abou Al Montacir <[email protected]> | 3
Arno Töll <[email protected]> | 3
Sébastien Villemot <[email protected]> | 3
(10 rows)
If you want to check bugs closed by a specific email:
select id, source, title from bugs where severity >= 'serious'
and last_modified >= '2013-03-01' and status='done' and
done_email='[email protected]';
Note that the queries use "last_modified". There's no "done_date" field in the
BTS.
Lucas
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
Archive: http://lists.debian.org/[email protected]
