On 20/10/09 at 22:15 +0200, George Danchev wrote: > > On 18/10/09 at 22:57 +0200, George Danchev wrote: > > > Package: qa.debian.org > > > > > > Hi, > > > > > > It would be nice to get impression of the current (topmost) bug numbers, > > > for instance: > > > > > > packages with more than 1 open RC-bug > > > packages with more than 10/100 open bugs (any kind of) > > > > > > and eventually reports about packages with bugs tagged as 'request for > > > help', 'more info' and 'wontfix'. > > > > I agree. Maybe you could work on writing the SQL queries for those > > lists, and such lists could be provided as a CGI on > > http://udd.debian.org/? > > Yeah, providing thes next to existing scripts is what I meant, and I'm > willing > to invest some time after it. Should I download udd.sql.gz, install plperl > (createlang, etc... which might take some time) at my site or I can login to > samosa and use local database there to try some queries? > > I also noticed that there are some nice VIEWs at [1], which could be used. > > Extracting interesting bug-profiles might need further and broader > discussion, > but on my second thoughts I believe that these concerning testing are the > hottest ones, so we are best to start with them first. My revised lists are: > > packages in testing with more than 0/5 open RC-bug > packages in testing with more than 10/100 open bugs (any kind of) > > packages in testing with bugs tagged as 'request for help', 'more info' and > 'wontfix'.
The best would be to have some use cases for this data in mind: it's easy to generate data, harder to generate useful data :-) See http://wiki.debian.org/UltimateDebianDatabase for information about how to connect to UDD. -- | Lucas Nussbaum | lu...@lucas-nussbaum.net http://www.lucas-nussbaum.net/ | | jabber: lu...@nussbaum.fr GPG: 1024D/023B3F4F | -- To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org