Your message dated Sun, 3 Jul 2011 16:31:14 +0200
with message-id <[email protected]>
and subject line Re: Bug#632167: [UDD] ubuntu_upload_history misses some fields
has caused the Debian Bug report #632167,
regarding [UDD] ubuntu_upload_history misses some fields
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
632167: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=632167
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: qa.debian.org
Severity: wishlist
Hi there,
Thanks for adding ubuntu_upload_history. :-)
However, it misses some fields. Ubuntu's changes mails contain a few
pieces of information that Debian's do not.
- Signed-By: same format as Changed-By, but is used to indicate the
signer of the upload when it is different from the changer.
- Launchpad-Bugs-Fixed: Same as Closes, but for Launchpad rather than
the BTS.
- Original-Maintainer: Same format as Maintainer, but records the
Debian maintainer in the case when Ubuntu has pointed Maintainer to
the Ubuntu development team.
Also, some fields do not really make sense in ubuntu_upload_history.
- NMU: There's no concept of NMUing in Ubuntu
- Architecture: All uploads are 'source'.
- key_id/fingerprint: These aren't provided, so the columns should be
dropped.
I'll see if I can find some next week to give you some SQL.
Cheers,
Iain
-- System Information:
Debian Release: squeeze/sid
APT prefers natty-updates
APT policy: (500, 'natty-updates'), (500, 'natty-security'), (500, 'natty'),
(100, 'natty-backports')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.38-8-generic (SMP w/2 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) (ignored: LC_ALL
set to en_GB.UTF-8)
Shell: /bin/sh linked to /bin/dash
--- End Message ---
--- Begin Message ---
On 30/06/11 at 20:22 +0100, Iain Lane wrote:
> tags 632167 + patch
> thanks
>
> Hi again,
>
> On Thu, Jun 30, 2011 at 09:13:07AM +0100, Iain Lane wrote:
> >Package: qa.debian.org
> >Severity: wishlist
> >
> >Hi there,
> >
> >Thanks for adding ubuntu_upload_history. :-)
> >
> >However, it misses some fields. Ubuntu's changes mails contain a few
> >pieces of information that Debian's do not.
> >
> > - Signed-By: same format as Changed-By, but is used to indicate the
> > signer of the upload when it is different from the changer.
> > - Launchpad-Bugs-Fixed: Same as Closes, but for Launchpad rather than
> > the BTS.
> > - Original-Maintainer: Same format as Maintainer, but records the
> > Debian maintainer in the case when Ubuntu has pointed Maintainer to
> > the Ubuntu development team.
> >
> >Also, some fields do not really make sense in ubuntu_upload_history.
> >
> > - NMU: There's no concept of NMUing in Ubuntu
> > - Architecture: All uploads are 'source'.
> > - key_id/fingerprint: These aren't provided, so the columns should be
> > dropped.
>
> Well I got bored just now and implemented this. To keep it all in one
> file there's now quite a few conditional statements in
> upload_history_gatherer.py. I don't think it's too bad.
>
> You'll want to drop the tables and do a full reimport. I just tried
> that and it WFM:
>
> udd=# SELECT u.source, u.version, u.changed_by, count(lp.bug) as
> num_bugs_closed FROM ubuntu_upload_history u,
> ubuntu_upload_history_launchpad_closes lp WHERE u.source = lp.source AND
> u.version = lp.version GROUP BY u.source, u.version, u.changed_by ORDER BY
> num_bugs_closed DESC LIMIT 10;
> source | version |
> changed_by | num_bugs_closed
> ------------+------------------------------------+-----------------------------------------+-----------------
> linux | 2.6.28-9.30 | Tim Gardner
> <[email protected]> | 106
> phatch | 0.2.1-4 | stani
> <[email protected]> | 83
> openjdk-7 | 7~b136-1.14~pre0-1 | Matthias Klose
> <[email protected]> | 76
> pulseaudio | 1:0.9.22~0.9.21+341-g62bf-0ubuntu1 | Daniel T Chen
> <[email protected]> | 76
> xorg | 1:7.5+1ubuntu1 | Timo Aaltonen
> <[email protected]> | 73
> vlc | 1.1.0-1ubuntu1 | Benjamin Drung
> <[email protected]> | 70
> unity | 3.8.4-0ubuntu1 | Didier Roche
> <[email protected]> | 67
> unity | 3.8.2-0ubuntu1 | Didier Roche
> <[email protected]> | 65
> unity-2d | 3.8-0ubuntu1 | Oliver Grawert
> <[email protected]> | 63
> unity | 3.6.6-0ubuntu1 | Didier Roche
> <[email protected]> | 54
> (10 rows)
>
> Patch is attached. Please have a look and commit if you think it's
> alright. :-)
>
> (I didn't test the Debian upload importer, but that should hopefully
> be untouched)
Thanks a lot, applied.
- Lucas
--- End Message ---
