Blue Dwarf

Since I was watching Don Armstrong’s talk about Debbugs’ SOAP interface I wanted to use devscripts' bts to get a list of boinc‘s top five bug reporter. Finally, this is possible with devscripts (>= 2.10.36):

bts status file:- `bts select source:boinc archive:both` \
  | egrep "^originator" | cut -f2- | sort | uniq -ci | sort -n \
  | tail -n5

 2 Riccardo Stagni <unriccio@email.it>
 3 Martin Michlmayr <tbm@cyrius.com>
 6 Robert Millan <rmh@aybabtu.com>
 6 Thibaut VARENE <varenet@debian.org>
10 Sandro Tosi <matrixhasu@gmail.com>

Sweet – Thanks Debbugs and Devscripts maintainers!
And congratulations Sandro (or thank you – whatever you find appropriate)!

Update:
Lucas Nussbaum recently demonstrated how the Ultimate Debian Database (UDD) can be used to assemble cool stats about Debian bugs. This brought me to translate the above shell code into an SQL query for UDD. To retrieve boinc‘s top five bug reporter from UDD, one would use a query like this:

udd=> select submitter, count(*) from (select * from bugs
  where source = 'boinc' union select * from archived_bugs
  where source = 'boinc') as all_boinc_bugs group by submitter
  order by count desc limit 5;
              submitter               | count
--------------------------------------+-------
 Sandro Tosi <matrixhasu@gmail.com>   |     8
 Thibaut VARENE <varenet@debian.org>  |     6
 Robert Millan <rmh@aybabtu.com>      |     6
 Martin Michlmayr <tbm@cyrius.com>    |     3
 Michael Ablassmeier <abi@grinser.de> |     2
(5 rows)

The small difference between the two lists is because UDD does not handle bugs that are assigned to multiple packages correctly yet.

Tags: BOINC, Debbugs, Devscripts

This entry was posted on Sunday, September 21st, 2008 at 23:35 and is filed under Debian (en). You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.