[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Python code to retrieve all open wnpp bugs



On 22/03/09 at 19:07 +0100, Sandro Tosi wrote:
> On Sun, Mar 22, 2009 at 17:37, Sandro Tosi <morph@debian.org> wrote:
> > Hello,
> > I'm looking for a way from python code to obtain all the open wnpp bugs.
> >
> > I try to use btsutils (query('pkg:wnpp')), but it returns all the bugs
> > ever reported (~2900) that's too much for the ~400 we should have in
> > open state.
> 
> as kmap pointed out on irc, those numbers are a little "strange", now
> I clarify: I need the wnpp bugs for O/ITA/RFA not ITP/RFP; that's teh
> reduction in counting.
> 
> I was my mind focused on the problem, and forgot about the whole story :)

There's an "orphaned_packages" table in UDD with the following
fields:
- source package name
- type (O/ITA/RFA)
- bug number
- description of the package (from the WNPP bug)
- orphaned_time (determined by "parsing" the bug log)
-- 
| Lucas Nussbaum
| lucas@lucas-nussbaum.net   http://www.lucas-nussbaum.net/ |
| jabber: lucas@nussbaum.fr             GPG: 1024D/023B3F4F |


Reply to: