Re: Adding fixed_date to bugs and bugs_archived in UDD

[Ryan Kavanagh]

Hi,

On Tue, May 31, 2011 at 10:26:21AM +0200, Lucas Nussbaum wrote:
> Applied, the data will be re-imported during the next 24h hours.

Thanks!

I've also patched bugs.cgi to accept sorting by done_date, you can apply
if interested.

Kind regards,
Ryan

From cf84bfa3545811e9baf64fb32f425aea934c79a6 Mon Sep 17 00:00:00 2001
From: Ryan Kavanagh <ryana...@kubuntu.org>
Date: Wed, 1 Jun 2011 07:32:06 -0400
Subject: [PATCH] Updated bugs.cgi to include done_date as a sorting option

---
 web/bugs.cgi |    9 +++++++--
 1 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/web/bugs.cgi b/web/bugs.cgi
index 28f3ee4..9f9856e 100755
--- a/web/bugs.cgi
+++ b/web/bugs.cgi
@@ -63,6 +63,7 @@ SORTS = [
   ['source', 'source package'],
   ['package', 'binary package'],
   ['last_modified', 'last modified'],
+  ['done_date', 'done date'],
   ['severity', 'severity'],
   ['popcon', 'popularity contest'],
 ]
@@ -279,9 +280,9 @@ tstart = Time::now
 dbh = DBI::connect('DBI:Pg:dbname=udd;port=5441;host=localhost', 'guest')
 dbh.execute("SET statement_timeout TO 90000")
 if cols['cpopcon']
-  q = "select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental, coalesce(popcon_src.insts, 0) as popcon\nfrom bugs left join popcon_src on (bugs.source = popcon_src.source) \n"
+  q = "select id, bugs.package, bugs.source, severity, title, last_modified, done_date, affects_stable, affects_testing, affects_unstable, affects_experimental, coalesce(popcon_src.insts, 0) as popcon\nfrom bugs left join popcon_src on (bugs.source = popcon_src.source) \n"
 else
-  q = "select id, bugs.package, bugs.source, severity, title, last_modified, affects_stable, affects_testing, affects_unstable, affects_experimental from bugs \n"
+  q = "select id, bugs.package, bugs.source, severity, title, last_modified, done_date, affects_stable, affects_testing, affects_unstable, affects_experimental from bugs \n"
 end
 q += "where #{RELEASE_RESTRICT.select { |r| r[0] == release }[0][2]} \n"
 FILTERS.each do |f|
@@ -392,6 +393,7 @@ puts '<th>claimed by</th>' if cols['cclaimed']
 puts '<th>deferred</th>' if cols['cdeferred']
 puts '<th>RT tag</th>' if cols['crttags']
 puts '<th>last&nbsp;modified</th></tr>'
+puts '<th>done&nbsp;date</th></tr>'
 
 def genhints(source, hints)
   return '' if hints.nil?
@@ -478,6 +480,9 @@ rows.each do |r|
   d = r['last_modified']
   d = Date::new(d.year, d.month, d.day)
   puts "<td style='text-align: center;'>#{d}</td></tr>"
+  dd = r['done_date']
+  dd = Date::new(dd.year, dd.month, dd.day)
+  puts "<td style='text-align: center;'>#{dd}</td></td>
 end
 
 puts "</table>"
-- 
1.7.5.3

signature.asc
Description: Digital signature