--- udd/web/cgi-bin/bugs.cgi 2010/09/13 16:16:13 1788 +++ udd/web/cgi-bin/bugs.cgi 2010/09/14 20:26:47 1789 @@ -12,7 +12,8 @@ ['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 = [ @@ -23,6 +24,8 @@ ['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)"], ] TYPES = [ @@ -61,17 +64,17 @@ # 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 @@ -96,6 +99,11 @@ -RC Bugs List @ UDD +Debian Bugs Search @ UDD -

Release Critical Bugs List

Bugs Search @ UDD

Bugs affecting: @@ -123,7 +145,7 @@ puts "#{r[1]} " end puts <<-EOF -(also uses release tags and xxx-ignore information)

+
(also uses release tags and xxx-ignore information)

@@ -132,7 +154,7 @@ FILTERS.each do |r| puts <<-EOF - + @@ -142,7 +164,7 @@ # newer than puts <<-EOF - + @@ -166,7 +188,7 @@ puts "#{r[1]} " end puts <<-EOF -

EOF if cgi.params != {} @@ -188,9 +210,13 @@ elsif fnewer == 'ign' q += "and (current_timestamp - interval '#{fnewerval} days' > arrival) \n" end -q += "AND (" -q += TYPES.select { |t| types[t[0]] }.map { |t| t[2] }.join("\n OR ") -q += ")\n " +q2 = TYPES.select { |t| types[t[0]] }.map { |t| t[2] }.join("\n OR ") +if q2 != "" + q += "AND (#{q2})\n" +else + puts "

Must select at least one bug type!

" + q += "AND FALSE\n" +end q += "order by #{sortby} #{sorto}" sth = dbh.prepare(q) sth.execute @@ -209,7 +235,7 @@ puts (0...bins.length).map { |i| "#{bins[i]}" }.join(', ') puts "" puts <<-EOF - + EOF @@ -285,12 +311,15 @@ puts "" sth2 = dbh.prepare("select max(start_time) from timestamps where source = 'bugs' and command = 'run'") sth2.execute ; r2 = sth2.fetch_all -puts "

Generated in #{Time::now - tstart} seconds. Last data update: #{r2[0][0]}

" +puts "

Generated in #{Time::now - tstart} seconds. Last data update: #{r2[0][0]}" +puts " (%.1f hours ago)

" % ((Time::now - r2[0][0].to_time) / 3600) puts "

#{q}

" end # if cgi.params != {} puts <<-EOF -

-Suggestions / comments / patches to lucas at debian dot org. source code. + + EOF