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

Bug#632167: marked as done ([UDD] ubuntu_upload_history misses some fields)

Your message dated Sun, 3 Jul 2011 16:31:14 +0200
with message-id <20110703143114.GA493@xanadu.blop.info>
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 owner@bugs.debian.org
immediately.)


-- 
632167: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=632167
Debian Bug Tracking System
Contact owner@bugs.debian.org 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 <tim.gardner@canonical.com> |             106
>  phatch     | 0.2.1-4                            | stani <spe.stani.be@gmail.com>          |              83
>  openjdk-7  | 7~b136-1.14~pre0-1                 | Matthias Klose <doko@ubuntu.com>        |              76
>  pulseaudio | 1:0.9.22~0.9.21+341-g62bf-0ubuntu1 | Daniel T Chen <crimsun@ubuntu.com>      |              76
>  xorg       | 1:7.5+1ubuntu1                     | Timo Aaltonen <tjaalton@ubuntu.com>     |              73
>  vlc        | 1.1.0-1ubuntu1                     | Benjamin Drung <bdrung@ubuntu.com>      |              70
>  unity      | 3.8.4-0ubuntu1                     | Didier Roche <didrocks@ubuntu.com>      |              67
>  unity      | 3.8.2-0ubuntu1                     | Didier Roche <didrocks@ubuntu.com>      |              65
>  unity-2d   | 3.8-0ubuntu1                       | Oliver Grawert <ogra@ubuntu.com>        |              63
>  unity      | 3.6.6-0ubuntu1                     | Didier Roche <didrocks@ubuntu.com>      |              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 ---
Reply to: