Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Lucas Nussbaum
On 05/05/07 at 23:34 +0200, Stefano Zacchiroli wrote: > On Sat, May 05, 2007 at 12:39:56PM +0200, Holger Levsen wrote: > > Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages > > are > > bug-free (if you counted source packages). Of course, we still can & should > > do bet

Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Stefano Zacchiroli
On Sat, May 05, 2007 at 12:39:56PM +0200, Holger Levsen wrote: > Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages > are > bug-free (if you counted source packages). Of course, we still can & should > do better :-) On Sat, May 05, 2007 at 08:27:16PM +0200, Lucas Nussbau

Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Lucas Nussbaum
On 05/05/07 at 12:39 +0200, Holger Levsen wrote: > Hi, > > On Friday 04 May 2007 22:36, Lucas Nussbaum wrote: > > Some quick results: > > n | packages with more than n bugs open in unstable > > 10 | 1043 > > 0 | 6783 > > Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages

Re: Fun with the BTS and an SQL DB

2007-05-05 Thread Holger Levsen
Hi, On Friday 04 May 2007 22:36, Lucas Nussbaum wrote: > Some quick results: > n | packages with more than n bugs open in unstable > 10 | 1043 > 0 | 6783 Wow. Only 1000 packages have more than 10 bugs and more than 3000 packages are bug-free (if you counted source packages). Of course, we stil

Re: Fun with the BTS and an SQL DB

2007-05-04 Thread Lucas Nussbaum
On 04/05/07 at 18:24 +0200, Filippo Giunchedi wrote: > just out of curiosity: have you already thought how to size the > threshold n ? Not yet. The algorithm will probably be something like that: - get a list of interesting packages and maintainers - add the missing ones to the "permanent" list t

Re: Fun with the BTS and an SQL DB

2007-05-04 Thread Filippo Giunchedi
On Fri, May 04, 2007 at 04:59:27PM +0200, Lucas Nussbaum wrote: > Hi, > > (for details, the DB schema is readable on > http://qa.debian.org/~lucas/pg-schema.sql ) just a few more comments on bugs_bugs: can it be useful to store usertags? what about added tags? I guess this would need to change

Re: Fun with the BTS and an SQL DB

2007-05-04 Thread Filippo Giunchedi
On Fri, May 04, 2007 at 04:59:27PM +0200, Lucas Nussbaum wrote: > Hi, [...] > What I'm planning to do is to store on a daily basis: > for all packages in Debian, > for all packages maintained by the same person (restricting this to > persons with at least 'n' bugs), > for all packages maintained

Fun with the BTS and an SQL DB

2007-05-04 Thread Lucas Nussbaum
Hi, I have worked on importing the output of bugscan in a postgresql DB (on merkel.d.o). I am now able to run queries such as: * 10 maintainers with the highest number of bugs tagged patch (including * or excluding co-maintained packages) * bugs filed against packages no longer in Debian * total