Merge lp:~adeuring/launchpad/bug-283941-show-patch-numbers-on-upstream-report into lp:launchpad/db-devel

[Abel Deuring]

[Abel Deuring (adeuring)]

This branch adds another column "number of bugs in a distribution that have patches attached and which may be intersting for the upstream project" to the "upstream report" page. See also bug 283941.

While Jorge suggested in the report to add the new number in parentheses after the last number in each row, I opted to add another column so that we can display a column header. Having numbers without any explanation does IMHO not make much sense, and the page requires already a wiki page with lots of explanations.

Technical changes:

The last value of the current implementation of the page is the difference of the numbers in the columns "Upstream" and "Watch", giving the number of bugs in Ubuntu where the upstream project does not have a corresponding bug.

These numbers come from an SQL query in Distribution.getPackagesAndPublicUpstreamBugCounts(); the SQL expressions are

             COUNT(DISTINCT CASE WHEN Bugtask.status IN %(unresolved)s THEN
                   RelatedBugTask.bug END) AS bugs_affecting_upstream,

for "Upstream" and

             COUNT(DISTINCT CASE WHEN Bugtask.status in %(unresolved)s AND
                   (RelatedBugTask.bugwatch IS NOT NULL OR
                   RelatedProduct.official_malone IS TRUE) THEN
                   RelatedBugTask.bug END) AS bugs_with_upstream_bugwatch,

for "Watch".

We can get the difference between these numbers by inverting the expression

                  (RelatedBugTask.bugwatch IS NOT NULL OR
                   RelatedProduct.official_malone IS TRUE)

which is

                   RelatedBugTask.bugwatch IS NULL AND
                   RelatedProduct.official_malone IS FALSE

(Note that the value of the column RelatedProduct.official_malone may not be NULL). In plain words: "The number of bugs where we have a bugtask in the Launchpad project and in Ubuntu, but where the upstream project does not use Launchpad". IOW, the number of bugs that have been marked in Launchpad as affecting the upstream project, but where we don't know about a corresponding bug in the real upstream bug tracker.

From these bugs, we only want those that have a patch attached, so we add another term for this condition, giving this COUNT expression for the new column of the upstream report page:

             COUNT(DISTINCT CASE WHEN Bugtask.status in %(unresolved)s AND
                   RelatedBugTask.bugwatch IS NULL AND
                   RelatedProduct.official_malone IS FALSE AND
                   Bug.latest_patch_uploaded IS NOT NULL

The remaining changes are mostly mechanical:

The tuples returned by Distribution.getPackagesAndPublicUpstreamBugCounts() now have another element, so the callsite had to be changed DistributionUpstreamBugReport.initialize() had to be changed too.

The values of each displayed on the +upstreamreport gae are stored in insteances of class BugReportData, so this class is now also aware of the new number.

Finally, the number "bugs with patches interesting for upstream" is displayed as a link to a bug search oage. The link is the same as the one for the next column to the left, but with the additional parameter "show only bugs having patches".

The remaing changes are added and ...

[Brad Crittenden (bac)]

Hi Abel,

Thanks for this branch. It looks good to me except for a couple of
questions. Please do have a UI review too.

--Brad

> === modified file 'lib/lp/bugs/browser/bugtask.py'
--- lib/lp/bugs/browser/bugtask.py 2010-02-03 21:11:53 +0000
> +++ lib/lp/bugs/browser/bugtask.py 2010-02-16 16:16:26 +0000
> @@ -1858,7 +1858,8 @@
>
>
> def get_buglisting_search_filter_url(
> - assignee=None, importance=None, status=None, status_upstream=None):
> + assignee=None, importance=None, status=None, status_upstream=None,
> + has_patches=None):
> """Return the given URL with the search parameters specified."""
> search_params = []
>
> @@ -1870,6 +1871,8 @@
> search_params.append(('field.status', status))
> if status_upstream is not None:
> search_params.append(('field.status_upstream', status_upstream))
> + if has_patches is not None:
> + search_params.append(('field.has_patch', 'on'))
>
> query_string = urllib.urlencode(search_params, doseq=True)
>

> === modified file 'lib/lp/bugs/browser/distribution_upstream_bug_report.py'
> --- lib/lp/bugs/browser/distribution_upstream_bug_report.py 2009-06-25 00:40:31 +0000
> +++ lib/lp/bugs/browser/distribution_upstream_bug_report.py 2010-02-16 16:16:26 +0000
> @@ -60,11 +60,12 @@
> BAD_THRESHOLD = 20
>
> def __init__(self, open_bugs=0, triaged_bugs=0, upstream_bugs=0,
> - watched_bugs=0):
> + watched_bugs=0, bugs_with_upstream_patches=0):
> self.open_bugs = open_bugs
> self.triaged_bugs = triaged_bugs
> self.upstream_bugs = upstream_bugs
> self.watched_bugs = watched_bugs
> + self.bugs_with_upstream_patches = bugs_with_upstream_patches
>
> @property
> def triaged_bugs_percentage(self):
> @@ -148,9 +149,9 @@
> - *_url: convenience URLs
> """
> def __init__(self, dsp, dssp, product, open_bugs, triaged_bugs,
> - upstream_bugs, watched_bugs):
> + upstream_bugs, watched_bugs, bugs_with_upstream_patches):
> BugReportData.__init__(self, open_bugs, triaged_bugs, upstream_bugs,
> - watched_bugs)
> + watched_bugs, bugs_with_upstream_patches)
> self.dsp = dsp
> self.dssp = dssp
> self.product = product
> @@ -235,6 +236,14 @@
> self.watched_bugs_delta_url = urlappend(
> dsp_bugs_url, unwatched_bugs_search_filter_url)
>
> + # The bugs with upstream patches URL links to all open upstream
> + # bugs that don't have a bugwatch but have patches attached.
> + bugs_with_upstream_patches_filter_url = (
> + get_buglisting_search_filter_url(
> + status_upstream='pending_bugwatch', has_patches=True))
> + self.bugs_with_upstream_patches_url = urlappend(
> + dsp_bugs_url, bugs_with_upstream_patches_filter_url)
> +
>
> class DistributionUpstreamBugReport(LaunchpadView):
> """Implements the actual upstream bug report.
> @@ -248,6 +257,7 @@
> valid_sort_keys = [
> 'bugtracker_name',
> 'bug_superviso...

review: Approve (code)

[Abel Deuring (adeuring)]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Brad,

thanks for your review!

On 16.02.2010 17:34, Brad Crittenden wrote:
> Review: Approve code
> Hi Abel,
>
> Thanks for this branch. It looks good to me except for a couple of
> questions. Please do have a UI review too.

Sure, I wont forget the UI review ;)

>
> --Brad
>
>

[...]
>> === modified file 'lib/lp/bugs/doc/distribution-upstream-bug-report.txt'
>> --- lib/lp/bugs/doc/distribution-upstream-bug-report.txt 2009-10-16 20:33:56 +0000
>> +++ lib/lp/bugs/doc/distribution-upstream-bug-report.txt 2010-02-16 16:16:26 +0000
>> @@ -131,20 +131,56 @@
>> >>> task = getUtility(IBugTaskSet).createTask(bug, name12, product=pmount)
>> >>> Store.of(task).flush()
>> >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
>> - pmount pmount 2 2 1 0
>> - linux-source-2.6.15 None 1 0 0 0
>> - mozilla-firefox firefox 1 1 1 1
>> -
>> -Linking that task to a bugwatch makes the watch counts update:
>> + pmount pmount 2 2 1 0 0
>> + linux-source-2.6.15 None 1 0 0 0 0
>> + mozilla-firefox firefox 1 1 1 1 0
>> +
>> +The last column counts those bugs with upstream tasks that have patches
>> +attached but which don't have an upstream bugwatch. If we add a ordinary
>> +attachment to our pmount bug, the value of the last column does not
>> +change...
>> +
>> + >>> attachment = factory.makeBugAttachment(bug)
>> + >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
>> + pmount pmount 2 2 1 0 0
>> + linux-source-2.6.15 None 1 0 0 0 0
>> + mozilla-firefox firefox 1 1 1 1 0
>> +
>> +...but when we make this attachment a patch, the value of the column
>> +increases.
>> +
>> + >>> from lp.bugs.interfaces.bugattachment import BugAttachmentType
>> + >>> attachment.type = BugAttachmentType.PATCH
>> + >>> Store.of(attachment).flush()
>> + >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
>> + pmount pmount 2 2 1 0 1
>> + linux-source-2.6.15 None 1 0 0 0 0
>> + mozilla-firefox firefox 1 1 1 1 0
>> +
>> +Note that we count only bugs with patches for products that do not
>> +use Malone officially.
>> +
>> + >>> pmount.official_malone = True
>> + >>> Store.of(pmount).flush()
>> + >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
>> + pmount pmount 2 2 1 1 0
>> + linux-source-2.6.15 None 1 0 0 0 0
>> + mozilla-firefox firefox 1 1 1 1 0
>
> I find having a '0' to be misleading. Would not using a '-' or some
> other indicator to show the data are not relevant be more appropriate?

Thanks, this is a nice idea -- but I prefer to implement this special
case in the template. Firstly, this keeps the code of the method
getPackagesAndPublicUpstreamBugCounts() (or the SQL query) a bit
simpler, and secondly, we calculate and display the sum over all rows
for all columns in the browser class. Having something other than a
number would make that code also more convoluted.

>> === modified file 'lib/lp/bugs/templates/distribution-upstream-bug-report.pt'
>> --- lib/l...

[Abel Deuring (adeuring)]

screenshot: http://people.canonical.com/~adeuring/upstreamreport.png
The right-most column ("Patches for upstream") is new

[Curtis Hovey (sinzui)]

This looks good to land.

review: Approve (ui)

=== modified file 'lib/lp/bugs/browser/bugtask.py'
--- lib/lp/bugs/browser/bugtask.py	2010-02-03 21:11:53 +0000
+++ lib/lp/bugs/browser/bugtask.py	2010-02-18 09:23:13 +0000
@@ -1858,7 +1858,8 @@
 
 
 def get_buglisting_search_filter_url(
-        assignee=None, importance=None, status=None, status_upstream=None):
+        assignee=None, importance=None, status=None, status_upstream=None,
+        has_patches=None):
     """Return the given URL with the search parameters specified."""
     search_params = []
 
@@ -1870,6 +1871,8 @@
         search_params.append(('field.status', status))
     if status_upstream is not None:
         search_params.append(('field.status_upstream', status_upstream))
+    if has_patches is not None:
+        search_params.append(('field.has_patch', 'on'))
 
     query_string = urllib.urlencode(search_params, doseq=True)
 
 
=== modified file 'lib/lp/bugs/browser/distribution_upstream_bug_report.py'
--- lib/lp/bugs/browser/distribution_upstream_bug_report.py	2009-06-25 00:40:31 +0000
+++ lib/lp/bugs/browser/distribution_upstream_bug_report.py	2010-02-18 09:23:13 +0000
@@ -60,11 +60,12 @@
     BAD_THRESHOLD = 20
 
     def __init__(self, open_bugs=0, triaged_bugs=0, upstream_bugs=0,
-                 watched_bugs=0):
+                 watched_bugs=0, bugs_with_upstream_patches=0):
         self.open_bugs = open_bugs
         self.triaged_bugs = triaged_bugs
         self.upstream_bugs = upstream_bugs
         self.watched_bugs = watched_bugs
+        self.bugs_with_upstream_patches = bugs_with_upstream_patches
 
     @property
     def triaged_bugs_percentage(self):
@@ -148,9 +149,9 @@
         - *_url: convenience URLs
     """
     def __init__(self, dsp, dssp, product, open_bugs, triaged_bugs,
-                 upstream_bugs, watched_bugs):
+                 upstream_bugs, watched_bugs, bugs_with_upstream_patches):
         BugReportData.__init__(self, open_bugs, triaged_bugs, upstream_bugs,
-                               watched_bugs)
+                               watched_bugs, bugs_with_upstream_patches)
         self.dsp = dsp
         self.dssp = dssp
         self.product = product
@@ -235,6 +236,14 @@
         self.watched_bugs_delta_url = urlappend(
             dsp_bugs_url, unwatched_bugs_search_filter_url)
 
+        # The bugs with upstream patches URL links to all open upstream
+        # bugs that don't have a bugwatch but have patches attached.
+        bugs_with_upstream_patches_filter_url = (
+            get_buglisting_search_filter_url(
+                status_upstream='pending_bugwatch', has_patches=True))
+        self.bugs_with_upstream_patches_url = urlappend(
+            dsp_bugs_url, bugs_with_upstream_patches_filter_url)
+
 
 class DistributionUpstreamBugReport(LaunchpadView):
     """Implements the actual upstream bug report.
@@ -248,6 +257,7 @@
     valid_sort_keys = [
         'bugtracker_name',
         'bug_supervisor_name',
+        'bugs_with_upstream_patches',
         'dsp',
         'open_bugs',
         'product',
@@ -344,7 +354,8 @@
         packages_to_exclude = self.context.upstream_report_excluded_packages
         counts = self.context.getPackagesAndPublicUpstreamBugCounts(
             limit=self.LIMIT, exclude_packages=packages_to_exclude)
-        for (dsp, product, open, triaged, upstream, watched) in counts:
+        for (dsp, product, open, triaged, upstream, watched,
+             bugs_with_upstream_patches) in counts:
             # The +edit-packaging page is only available for
             # IDistributionSeriesSourcepackages, so deduce one here. If
             # the distribution doesn't have series we can't offer a link
@@ -360,6 +371,7 @@
             self.total.watched_bugs += watched
 
             item = PackageBugReportData(
-                dsp, dssp, product, open, triaged, upstream, watched)
+                dsp, dssp, product, open, triaged, upstream, watched,
+                bugs_with_upstream_patches)
             self._data.append(item)
 
 
=== modified file 'lib/lp/bugs/doc/distribution-upstream-bug-report.txt'
--- lib/lp/bugs/doc/distribution-upstream-bug-report.txt	2009-10-16 20:33:56 +0000
+++ lib/lp/bugs/doc/distribution-upstream-bug-report.txt	2010-02-18 09:23:13 +0000
@@ -34,20 +34,20 @@
 them.
 
     >>> def print_report(data):
-    ...     for dsp, product, open, triaged, upstream, watch in data:
+    ...     for dsp, product, open, triaged, upstream, watch, patch in data:
     ...         print dsp.name, product and product.name or None
-    ...         print open, triaged, upstream, watch
+    ...         print open, triaged, upstream, watch, patch
 
 A first set of reports, entirely based on sampledata. There are no
 triaged bugs, but there are some upstream ones with watches:
 
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts())
-    linux-source-2.6.15 None    1 0 0 0
-    mozilla-firefox     firefox 1 0 1 1
-    thunderbird         None    1 0 1 1
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 0 1 1 0
+    thunderbird         None    1 0 1 1 0
 
     >>> print_report(debian.getPackagesAndPublicUpstreamBugCounts())
-    mozilla-firefox     None    3 0 2 1
+    mozilla-firefox     None    3 0 2 1 0
 
     >>> print_report(kubuntu.getPackagesAndPublicUpstreamBugCounts())
 
@@ -58,8 +58,8 @@
 
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(
     ...     exclude_packages=['linux-source-2.6.15']))
-    mozilla-firefox     firefox 1 0 1 1
-    thunderbird         None    1 0 1 1
+    mozilla-firefox     firefox 1 0 1 1 0
+    thunderbird         None    1 0 1 1 0
 
 To get the list of excluded packages for a distribution we can look at
 its `upstream_report_excluded_packages` property. For Kubuntu and
@@ -88,9 +88,9 @@
     >>> mf_bug.transitionToStatus(BugTaskStatus.TRIAGED, mark)
     >>> sync(mf_bug)
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts())
-    linux-source-2.6.15 None    1 0 0 0
-    mozilla-firefox     firefox 1 1 1 1
-    thunderbird         None    1 1 1 1
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
+    thunderbird         None    1 1 1 1 0
 
 We add two new bugs to pmount in Ubuntu. From now on we'll limit the
 results to 3 packages (as a demonstration of the API) so thunderbird
@@ -106,9 +106,9 @@
     ...     status=BugTaskStatus.TRIAGED)
     >>> ubuntu_pmount_task = bug.bugtasks[0]
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
-    pmount              None    2 2 0 0
-    linux-source-2.6.15 None    1 0 0 0
-    mozilla-firefox     firefox 1 1 1 1
+    pmount              None    2 2 0 0 0
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
 
 As you can see, there is no packaging data for pmount in Ubuntu, so no
 upstream is reported for it. Let's fix that:
@@ -121,9 +121,9 @@
     ...     pmount.getSeries('trunk'), pmount_spn,
     ...     ubuntu.currentseries, PackagingType.PRIME, name12)
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
-    pmount              pmount  2 2 0 0
-    linux-source-2.6.15 None    1 0 0 0
-    mozilla-firefox     firefox 1 1 1 1
+    pmount              pmount  2 2 0 0 0
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
 
 We then add an upstream task to the second pmount bug:
 
@@ -131,20 +131,56 @@
     >>> task = getUtility(IBugTaskSet).createTask(bug, name12, product=pmount)
     >>> Store.of(task).flush()
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
-    pmount              pmount  2 2 1 0
-    linux-source-2.6.15 None    1 0 0 0
-    mozilla-firefox     firefox 1 1 1 1
-
-Linking that task to a bugwatch makes the watch counts update:
+    pmount              pmount  2 2 1 0 0
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
+
+The last column counts those bugs with upstream tasks that have patches
+attached but which don't have an upstream bugwatch. If we add a ordinary
+attachment to our pmount bug, the value of the last column does not
+change...
+
+    >>> attachment = factory.makeBugAttachment(bug)
+    >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
+    pmount              pmount  2 2 1 0 0
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
+
+...but when we make this attachment a patch, the value of the column
+increases.
+
+    >>> from lp.bugs.interfaces.bugattachment import BugAttachmentType
+    >>> attachment.type = BugAttachmentType.PATCH
+    >>> Store.of(attachment).flush()
+    >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
+    pmount              pmount  2 2 1 0 1
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
+
+Note that we count only bugs with patches for products that do not
+use Malone officially.
+
+    >>> pmount.official_malone = True
+    >>> Store.of(pmount).flush()
+    >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
+    pmount              pmount  2 2 1 1 0
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
+
+    >>> pmount.official_malone = False
+    >>> Store.of(pmount).flush()
+
+Linking that task to a bugwatch increases the watch counts and decreases
+the count of bugs having patches but no bug watch.
 
     >>> url = "http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=666"
     >>> [watch] = getUtility(IBugWatchSet).fromText(url, bug, name12)
     >>> task.bugwatch = watch
     >>> sync(task)
     >>> print_report(ubuntu.getPackagesAndPublicUpstreamBugCounts(limit=3))
-    pmount              pmount  2 2 1 1
-    linux-source-2.6.15 None    1 0 0 0
-    mozilla-firefox     firefox 1 1 1 1
+    pmount              pmount  2 2 1 1 0
+    linux-source-2.6.15 None    1 0 0 0 0
+    mozilla-firefox     firefox 1 1 1 1 0
 
 
 Properties of BugReportData
@@ -488,6 +524,7 @@
 
     >>> print_sort_order_links(view)
     bug_supervisor_name http://...?sort_by=bug_supervisor_name
+    bugs_with_upstream_patches http:...?sort_by=bugs_with_upstream_patches
     bugtracker_name http://...?sort_by=bugtracker_name
     dsp http://...?sort_by=dsp
     open_bugs http://...?sort_by=open_bugs
@@ -517,6 +554,7 @@
 
     >>> print_sort_order_links(view)
     bug_supervisor_name http://...?sort_by=-bug_supervisor_name
+    bugs_with_upstream_patches http:...?sort_by=bugs_with_upstream_patches
     bugtracker_name http://...?sort_by=bugtracker_name...
 
 Each sort_order_links dict has an 'arrow' key. This is the URL of the
@@ -524,6 +562,7 @@
 
     >>> print_sort_order_links(view, 'arrow')
     bug_supervisor_name /@@/arrowUp
+    bugs_with_upstream_patches /@@/arrowBlank
     bugtracker_name /@@/arrowBlank
     dsp /@@/arrowBlank
     open_bugs /@@/arrowBlank
@@ -552,6 +591,7 @@
 
     >>> print_sort_order_links(view, 'arrow')
     bug_supervisor_name /@@/arrowDown
+    bugs_with_upstream_patches /@@/arrowBlank
     bugtracker_name /@@/arrowBlank...
 
     >>> form = {'sort_by': '-bugtracker_name'}
@@ -562,6 +602,7 @@
 
     >>> print_sort_order_links(view, 'arrow')
     bug_supervisor_name /@@/arrowBlank
+    bugs_with_upstream_patches /@@/arrowBlank
     bugtracker_name /@@/arrowDown...
 
 PS: This page is actually browser-tested in pagetests.distribution-
 
=== modified file 'lib/lp/bugs/stories/distribution/xx-distribution-upstream-bug-report.txt'
--- lib/lp/bugs/stories/distribution/xx-distribution-upstream-bug-report.txt	2010-01-23 14:17:49 +0000
+++ lib/lp/bugs/stories/distribution/xx-distribution-upstream-bug-report.txt	2010-02-18 09:23:13 +0000
@@ -43,11 +43,11 @@
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-content')
     >>> print extract_text(table, True)
     linux-source-2.6.15  Missing corresponding project.  (find) (link)
-        2    2   100.00  0  2    100.00    0    1   50.00  1
+        2    2   100.00  0  2    100.00    0    1   50.00  1  -
     mozilla-firefox     Mozilla Firefox        Launchpad    Unspecified
         1    1   100.00  0  1    100.00    0
     thunderbird          Missing corresponding project.  (find) (link)
-        1    1   100.00  0  1    100.00    0    1  100.00  0
+        1    1   100.00  0  1    100.00    0    1  100.00  0  -
 
 XXX kiko 2008-02-01 bug=188020: One thing to note from the counts above
 is that while the linux-source/tomcat task is counted as pending a
@@ -58,7 +58,7 @@
 
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-totals')
     >>> print extract_text(table)
-        Totals:  4  4  100.00   0  4  100.00   0  3  75.00  1
+        Totals:  4  4  100.00   0  4  100.00   0  3  75.00  1  0
 
 This 3 in the watched column is caused by a problem similar to the
 above; if you do a count of the values in the cells it would be 2, of
@@ -254,11 +254,27 @@
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-content')
     >>> print extract_text(table, True)
     linux-source-2.6.15  Missing corresponding project.  (find) (link)
-        2    2   100.00  0  2    100.00    0    0    0.00  2
-    mozilla-firefox  Mozilla Firefox  The Mozilla.org Bug Tracker  Unspecified
-        1    1   100.00  0  1    100.00    0    0    0.00  1
-    thunderbird          Missing corresponding project.  (find) (link)
-        1    1   100.00  0  1    100.00    0    1  100.00  0
+        2    2   100.00  0  2    100.00    0    0    0.00  2  -
+    mozilla-firefox  Mozilla Firefox  The Mozilla.org Bug Tracker  Unspecified
+        1    1   100.00  0  1    100.00    0    0    0.00  1  -
+    thunderbird          Missing corresponding project.  (find) (link)
+        1    1   100.00  0  1    100.00    0    1  100.00  0  -
+
+If we now add an attachment to the bug we created earlier, the number
+of bugs with patches for upstream increases for linux-source-2.6.15.
+
+    >>> login('[e-mail]')
+    >>> attachment = factory.makeBugAttachment(bug, is_patch=True)
+    >>> logout()
+    >>> browser.open("http://bugs.launchpad.dev/ubuntu/+upstreamreport")
+    >>> table = find_tag_by_id(browser.contents, 'upstream-report-content')
+    >>> print extract_text(table, True)
+    linux-source-2.6.15  Missing corresponding project.  (find) (link)
+        2    2   100.00  0  2    100.00    0    0    0.00  2  1
+    mozilla-firefox  Mozilla Firefox  The Mozilla.org Bug Tracker  Unspecified
+        1    1   100.00  0  1    100.00    0    0    0.00  1  -
+    thunderbird          Missing corresponding project.  (find) (link)
+        1    1   100.00  0  1    100.00    0    1  100.00  0  -
 
 
 The table of packages can be sorted by any of the columns. The column
@@ -298,11 +314,11 @@
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-content')
     >>> print extract_text(table, True)
     mozilla-firefox  Mozilla Firefox  The Mozilla.org Bug Tracker  Unspecified
-        1    1   100.00  0  1    100.00    0    0    0.00  1
+        1    1   100.00  0  1    100.00    0    0    0.00  1  -
     thunderbird          Missing corresponding project.  (find) (link)
-        1    1   100.00  0  1    100.00    0    1  100.00  0
+        1    1   100.00  0  1    100.00    0    1  100.00  0  -
     linux-source-2.6.15  Missing corresponding project.  (find) (link)
-        2    2   100.00  0  2    100.00    0    0    0.00  2
+        2    2   100.00  0  2    100.00    0    0    0.00  2  1
 
 An arrow next to the current sort header tells the user in which
 direction the table is sorted.
@@ -324,11 +340,11 @@
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-content')
     >>> print extract_text(table, True)
     linux-source-2.6.15  Missing corresponding project.  (find) (link)
-        2    2   100.00  0  2    100.00    0    0    0.00  2
+        2    2   100.00  0  2    100.00    0    0    0.00  2  1
     mozilla-firefox  Mozilla Firefox  The Mozilla.org Bug Tracker  Unspecified
-        1    1   100.00  0  1    100.00    0    0    0.00  1
+        1    1   100.00  0  1    100.00    0    0    0.00  1  -
     thunderbird          Missing corresponding project.  (find) (link)
-        1    1   100.00  0  1    100.00    0    1  100.00  0
+        1    1   100.00  0  1    100.00    0    1  100.00  0  -
 
 Finally, you can associate default branches to products. This is done by
 specifying a branch for the product's main_series:
@@ -360,11 +376,11 @@
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-content')
     >>> print extract_text(table, True)
     mozilla-firefox  Missing corresponding project.  (find)  (link)
-        3    0     0.00  3  2      66.67    1    0    0.00  2
+        3    0     0.00  3  2      66.67    1    0    0.00  2  -
 
     >>> table = find_tag_by_id(browser.contents, 'upstream-report-totals')
     >>> print extract_text(table)
-        Totals: 3    0     0.00  3  2      66.67    1    0    0.00  2
+        Totals: 3    0     0.00  3  2      66.67    1    0    0.00  2  0
 
     >>> browser.open("http://bugs.launchpad.dev/kubuntu/+upstreamreport")
     >>> table = find_tag_by_id(browser.contents, 'upstream-report')
 
=== modified file 'lib/lp/bugs/templates/distribution-upstream-bug-report.pt'
--- lib/lp/bugs/templates/distribution-upstream-bug-report.pt	2009-09-04 16:28:13 +0000
+++ lib/lp/bugs/templates/distribution-upstream-bug-report.pt	2010-02-18 09:23:13 +0000
@@ -131,6 +131,13 @@
               <img id="sortarrow-watched-delta"
                   tal:attributes="src links/watched_bugs_delta/arrow" />
             </th>
+            <th class="amount">
+              <a id="sort-bugs-with-upstream-patches"
+                  tal:attributes="href links/bugs_with_upstream_patches/link"
+              >Patches for upstream</a>
+              <img id="sortarrow-bugs-with-upstream-patches"
+                  tal:attributes="src links/bugs_with_upstream_patches/arrow" />
+            </th>
           </tr>
         </thead>
         <tbody id="upstream-report-content">
@@ -219,7 +226,7 @@
             </td>
             <tal:upstream-in-launchpad
                 condition="item/official_malone">
-                <td colspan="3" class="good">&nbsp;</td>
+                <td colspan="4" class="good">&nbsp;</td>
             </tal:upstream-in-launchpad>
             <tal:upstream-not-in-launchpad
                 condition="not: item/official_malone">
@@ -231,6 +238,17 @@
                 <a tal:attributes="href item/watched_bugs_delta_url"
                    tal:content="item/watched_bugs_delta"></a>
               </td>
+              <td tal:attributes="class string:amount ${item/watched_bugs_class}">
+                <tal:has-bugs-with-upstream-patches
+                    condition="item/bugs_with_upstream_patches">
+                  <a tal:attributes="href item/bugs_with_upstream_patches_url"
+                      tal:content="item/bugs_with_upstream_patches"></a>
+                </tal:has-bugs-with-upstream-patches>
+                <tal:has-no-bugs-with-upstream-patches
+                    condition="not: item/bugs_with_upstream_patches">
+                   -
+                </tal:has-no-bugs-with-upstream-patches>
+              </td>
             </tal:upstream-not-in-launchpad>
           </tr>
         </tbody>
@@ -257,6 +275,8 @@
                 tal:content="view/total/watched_bugs_percentage/fmt:float/.2" />
             <td class="amount"
                 tal:content="view/total/watched_bugs_delta" />
+            <td class="amount"
+                tal:content="view/total/bugs_with_upstream_patches" />
           </tr>
         </tfoot>
       </table>
 
=== modified file 'lib/lp/registry/model/distribution.py'
--- lib/lp/registry/model/distribution.py	2010-02-11 19:17:52 +0000
+++ lib/lp/registry/model/distribution.py	2010-02-18 09:23:13 +0000
@@ -34,6 +34,7 @@
 from lp.soyuz.model.binarypackagename import BinaryPackageName
 from lp.soyuz.model.binarypackagerelease import (
     BinaryPackageRelease)
+from lp.bugs.interfaces.bugattachment import BugAttachmentType
 from lp.bugs.model.bug import (
     BugSet, get_bug_tags, get_bug_tags_open_count)
 from lp.bugs.model.bugtarget import (
@@ -1375,7 +1376,14 @@
             COUNT(DISTINCT CASE WHEN Bugtask.status in %(unresolved)s AND
                   (RelatedBugTask.bugwatch IS NOT NULL OR
                   RelatedProduct.official_malone IS TRUE) THEN
-                  RelatedBugTask.bug END) AS bugs_with_upstream_bugwatch
+                  RelatedBugTask.bug END) AS bugs_with_upstream_bugwatch,
+            COUNT(DISTINCT CASE WHEN Bugtask.status in %(unresolved)s AND
+                  RelatedBugTask.bugwatch IS NULL AND
+                  RelatedProduct.official_malone IS FALSE AND
+                  Bug.latest_patch_uploaded IS NOT NULL
+                  THEN
+                  RelatedBugTask.bug END)
+                  AS bugs_with_upstream_patches
             FROM
                 SourcePackageName AS SPN
                 JOIN Bugtask ON SPN.id = Bugtask.sourcepackagename
@@ -1453,7 +1461,8 @@
         # in a reasonable data structure.
         results = []
         for (spn_id, spn_name, open_bugs, bugs_triaged,
-             bugs_affecting_upstream, bugs_with_upstream_bugwatch) in counts:
+             bugs_affecting_upstream, bugs_with_upstream_bugwatch,
+             bugs_with_upstream_patches) in counts:
             sourcepackagename = SourcePackageName.get(spn_id)
             dsp = self.getSourcePackage(sourcepackagename)
             if spn_id in sources_to_products:
@@ -1463,7 +1472,8 @@
                 product = None
             results.append(
                 (dsp, product, open_bugs, bugs_triaged,
-                 bugs_affecting_upstream, bugs_with_upstream_bugwatch))
+                 bugs_affecting_upstream, bugs_with_upstream_bugwatch,
+                 bugs_with_upstream_patches))
         return results
 
     def setBugSupervisor(self, bug_supervisor, user):