/[collab-qa]/udd/web/bugs.cgi

Diff of /udd/web/bugs.cgi

Parent Directory | Revision Log | View Patch Patch

-udd/web/cgi-bin/bugs.cgi
revision 1787 by lucas,
Mon Sep 13 13:32:51 2010 UTC
+udd/web/bugs.cgi
revision 1799 by lucas,
Sat Sep 18 11:05:59 2010 UTC
 Line 9 
 puts "Content-type: text/html\n\n"
  RELEASE_RESTRICT = [
    ['squeeze', 'squeeze', 'id in (select id from bugs_rt_affects_testing)'],
    ['sid', 'sid', 'id in (select id from bugs_rt_affects_unstable)'],
-   ['squeeze_and_sid', 'squeeze and sid', 'id in (select id from bugs_rt_affects_testing_and_unstable)'],
+   ['squeeze_and_sid', 'squeeze and sid', 'id in (select id from bugs_rt_affects_testing) and id in (select id from bugs_rt_affects_unstable)'],
    ['squeeze_or_sid', 'squeeze or sid', 'id in (select id from bugs_rt_affects_testing union select id from bugs_rt_affects_unstable)'],
    ['squeeze_not_sid', 'squeeze, not sid', 'id in (select id from bugs_rt_affects_testing) and id not in (select id from bugs_rt_affects_unstable)'],
-   ['sid_not_squeeze', 'sid, not squeeze', 'id in (select id from bugs_rt_affects_unstable) and id not in (select id from bugs_rt_affects_testing)']
+   ['sid_not_squeeze', 'sid, not squeeze', 'id in (select id from bugs_rt_affects_unstable) and id not in (select id from bugs_rt_affects_testing)'],
+   ['lenny', 'lenny', 'id in (select id from bugs_rt_affects_stable)'],
  ]
  FILTERS = [
-Line 23 
 FILTERS = [
+Line 24 
 FILTERS = [
   ['notsqueeze', 'packages not in squeeze', 'id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and release=\'squeeze\')'],
   ['merged', 'merged bugs', 'id in (select id from bugs_merged_with where id > merged_with)'],
   ['done', 'marked as done', 'status = \'done\''],
+  ['outdatedsqueeze', 'outdated binaries in squeeze', "source in (select distinct p1.source from packages_summary p1, packages_summary p2 where p1.source = p2.source and p1.release='squeeze' and p2.release='squeeze' and p1.source_version != p2.source_version)"],
+  ['outdatedsid', 'outdated binaries in sid', "source in (select distinct p1.source from packages_summary p1, packages_summary p2 where p1.source = p2.source and p1.release='sid' and p2.release='sid' and p1.source_version != p2.source_version)"],
+  ['needmig', 'different versions in squeeze and sid', "source in (select s1.source from sources s1, sources s2 where s1.source = s2.source and s1.release = 'squeeze' and s2.release='sid' and s1.version != s2.version)"],
+  ['newerubuntu', 'newer in Ubuntu than in sid', "source in (select s1.source from sources_uniq s1, ubuntu_sources s2 where s1.source = s2.source and s1.release = 'sid' and s2.release='maverick' and s1.version < s2.version)"],
  ]
  TYPES = [
-Line 37 
 SORTS = [
+Line 42 
 SORTS = [
    ['id', 'bug#'],
    ['source', 'source package'],
    ['package', 'binary package'],
-   ['last_modified', 'last modified']
+   ['last_modified', 'last modified'],
+   ['popcon', 'popularity contest'],
  ]
  cgi = CGI::new
-Line 61 
 end
+Line 67 
 end
  # filters
  filters = {}
  FILTERS.map { |r| r[0] }.each do |e|
-   if ['notconsidered', 'only', 'ign'].include?(cgi.params[e][0])
+   if ['', 'only', 'ign'].include?(cgi.params[e][0])
      filters[e] = cgi.params[e][0]
    else
-     filters[e] = (e == 'merged' ? 'ign' : 'notconsidered')
+     filters[e] = (e == 'merged' ? 'ign' : '')
    end
  end
  # filter: newer than X days
- if ['notconsidered', 'only', 'ign'].include?(cgi.params['fnewer'][0])
+ if ['', 'only', 'ign'].include?(cgi.params['fnewer'][0])
    fnewer = cgi.params['fnewer'][0]
  else
-   fnewer = 'notconsidered'
+   fnewer = ''
  end
  if cgi.params['fnewerval'][0] =~ /^[0-9]+$/
    fnewerval = cgi.params['fnewerval'][0].to_i
-Line 96 
 puts <<-EOF
+Line 102 
 puts <<-EOF
  <html>
  <head>
  <style type="text/css">
+   body {
+     font-family : "DejaVu Sans", "Bitstream Vera Sans", sans-serif;"
+   }
    table.buglist td, table.buglist th {
      border: 1px solid gray;
      padding-left: 3px;
-Line 108 
 puts <<-EOF
+Line 119 
 puts <<-EOF
      border-collapse: collapse;
    }
+ div#body {
+   border-top: 2px solid #d70751;
+ }
+ div.footer {
+     padding: 0.3em 0;
+     background-color: #fff;
+     text-align: center;
+     border-top: 2px solid #d70751;
+     margin: 0 0 0 0;
+     border-bottom: 0;
+     font-size: 85%;
+ }
  </style>
- <title>RC Bugs List @ UDD</title>
+ <title>Debian Bugs Search @ UDD</title>
  </head>
  <body>
- <h1>Release Critical Bugs List</h1>
+ <h1 style="margin-bottom : 5px"><img src="http://qa.debian.org/debian.png" alt="Debian logo" width="188" height="52" style="vertical-align : -13px; ">Bugs Search <span style="color :#c70036">@</span> UDD</h1>
+ <div id="body">
  <form action="bugs.cgi" method="get">
  <p><b>Bugs affecting:</b>
-Line 123 
 RELEASE_RESTRICT.each do |r|
+Line 148 
 RELEASE_RESTRICT.each do |r|
    puts "<input type='radio' name='release' value='#{r[0]}' #{checked}/>#{r[1]}&nbsp;&nbsp;"
  end
  puts <<-EOF
- </p>
+ <br/>(also uses release tags and xxx-ignore information)</p>
  <table class="invisible"><tr><td>
  <table class="buglist">
  <tr><th colspan='4'>FILTERS</th></tr>
-Line 132 
 EOF
+Line 157 
 EOF
  FILTERS.each do |r|
    puts <<-EOF
    <tr>
-   <td style='text-align: center;'><input type='radio' name='#{r[0]}' value='' #{filters[r[0]]=='notconsidered'?'CHECKED=\'1\'':''}/></td>
+   <td style='text-align: center;'><input type='radio' name='#{r[0]}' value='' #{filters[r[0]]==''?'CHECKED=\'1\'':''}/></td>
    <td style='text-align: center;'><input type='radio' name='#{r[0]}' value='only' #{filters[r[0]]=='only'?'CHECKED=\'1\'':''}/></td>
    <td style='text-align: center;'><input type='radio' name='#{r[0]}' value='ign' #{filters[r[0]]=='ign'?'CHECKED=\'1\'':''}'/></td>
    <td>#{r[1]}</td>
-Line 142 
 end
+Line 167 
 end
  # newer than
  puts <<-EOF
    <tr>
-   <td style='text-align: center;'><input type='radio' name='fnewer' value='' #{fnewer=='notconsidered'?'CHECKED=\'1\'':''}/></td>
+   <td style='text-align: center;'><input type='radio' name='fnewer' value='' #{fnewer==''?'CHECKED=\'1\'':''}/></td>
    <td style='text-align: center;'><input type='radio' name='fnewer' value='only' #{fnewer=='only'?'CHECKED=\'1\'':''}/></td>
    <td style='text-align: center;'><input type='radio' name='fnewer' value='ign' #{fnewer=='ign'?'CHECKED=\'1\'':''}'/></td>
    <td>newer than <input type='text' size='3' name='fnewerval' value='#{fnewerval}'/> days</td>
-Line 166 
 puts "<b> -- </b>"
+Line 191 
 puts "<b> -- </b>"
    puts "<input type='radio' name='sorto' value='#{r[0]}' #{checked}/>#{r[1]}&nbsp;&nbsp;"
  end
  puts <<-EOF
- </p><input type='submit' value='Update'/>
+ </p><input type='submit' value='Search'/>
  </form>
  EOF
  if cgi.params != {}
-Line 174 
 if cgi.params != {}
+Line 199 
 if cgi.params != {}
  # Generate and execute query
  tstart = Time::now
  dbh = DBI::connect('DBI:Pg:dbname=udd;port=5441;host=localhost', 'guest')
- q = "select id, bugs.package, bugs.source, title, last_modified from bugs \n"
+ if sortby != 'popcon'
+   q = "select id, bugs.package, bugs.source, title, last_modified from bugs \n"
+ else
+   q = "select id, bugs.package, bugs.source, title, last_modified, coalesce(popcon_src.insts, 0) as popcon\nfrom bugs left join popcon_src on (bugs.source = popcon_src.source) \n"
+ end
  q += "where #{RELEASE_RESTRICT.select { |r| r[0] == release }[0][2]} \n"
  FILTERS.each do |f|
    if filters[f[0]] == 'only'
-Line 188 
 if fnewer == 'only'
+Line 217 
 if fnewer == 'only'
  elsif fnewer == 'ign'
    q += "and (current_timestamp - interval '#{fnewerval} days' > arrival) \n"
  end
- q += "AND ("
+ q2 = TYPES.select { |t| types[t[0]] }.map { |t| t[2] }.join("\n OR ")
- q += TYPES.select { |t| types[t[0]] }.map { |t| t[2] }.join("\n OR ")
+ if q2 != ""
- q += ")\n "
+   q += "AND (#{q2})\n"
+ else
+   puts "<p><b>Must select at least one bug type!</b></p>"
+   q += "AND FALSE\n"
+ end
  q += "order by #{sortby} #{sorto}"
  sth = dbh.prepare(q)
  sth.execute
  rows = sth.fetch_all
  puts "<p><b>#{rows.length} bugs found.</b></p>"
- puts <<-EOF
+ puts '<table class="buglist">'
- <table class="buglist">
+ if sortby != 'popcon'
- <tr><th>bug#</th><th>source pkg</th><th>binary pkg</th><th>title</th><th>last&nbsp;modified</th></tr>
+   puts '<tr><th>bug#</th><th>package</th><th>title</th><th>last&nbsp;modified</th></tr>'
- EOF
+ else
+   puts '<tr><th>bug#</th><th>package</th><th>title</th><th>popcon</th><th>last&nbsp;modified</th></tr>'
+ end
  rows.each do |r|
    puts "<tr><td style='text-align: center;'><a href=\"http://bugs.debian.org/#{r['id']}\">##{r['id']}</a></td>"
    puts "<td style='text-align: center;'>"
-   puts r['source'].split(/,\s*/).map { |pkg| "<a href=\"http://packages.qa.debian.org/#{pkg}\">#{pkg}</a>" }.join(', ')
+   srcs = r['source'].split(/,\s*/)
+   bins = r['package'].split(/,\s*/)
+   puts (0...bins.length).map { |i| "<a href=\"http://packages.qa.debian.org/#{srcs[i]}\">#{bins[i]}</a>" }.join(', ')
    puts "</td>"
-   puts <<-EOF
+   puts "<td>#{CGI::escapeHTML(r['title'])}</td>"
-   <td style='text-align: center;'>#{r['package']}</td>
+   if sortby == 'popcon'
-   <td>#{r['title']}</td>
+     puts "<td>#{r['popcon']}</td>"
-   <td style='text-align: center;'>#{r['last_modified'].to_date}</td>
+   end
-   </tr>
+   puts "<td style='text-align: center;'>#{r['last_modified'].to_date}</td></tr>"
-   EOF
  end
  =begin
  release goals:
-Line 284 
 sth.finish
+Line 321 
 sth.finish
  puts "</table>"
  sth2 = dbh.prepare("select max(start_time) from timestamps where source = 'bugs' and command = 'run'")
  sth2.execute ; r2 = sth2.fetch_all
- puts "<p><b>Generated in #{Time::now - tstart} seconds. Last data update: #{r2[0][0]}</b></p>"
+ puts "<p><b>Generated in #{Time::now - tstart} seconds. Last data update: #{r2[0][0]}"
+ puts " (%.1f hours ago)</b></p>" % ((Time::now - r2[0][0].to_time) / 3600)
  puts "<pre>#{q}</pre>"
  end # if cgi.params != {}
  puts <<-EOF
- <hr/>
+ </div>
- <small>Suggestions / comments / patches to lucas at debian dot org. <a href="http://svn.debian.org/wsvn/collab-qa/udd/web/cgi-bin/bugs.cgi">source code</a>.</small>
+ <div class="footer">
+ <small>Suggestions / comments / patches to lucas@debian.org. <a href="http://svn.debian.org/wsvn/collab-qa/udd/web/cgi-bin/bugs.cgi">source code</a>.</small>
+ </div>
  </body>
  </html>
  EOF

 Legend:



Removed from v.1787
 


changed lines


 
Added in v.1799
 Legend:



Removed from v.1787
 


changed lines


 
Added in v.1799
-Removed from v.1787
+Added in v.1799

	ViewVC Help
Powered by ViewVC 1.1.5