EOF
if cgi.params != {}
# Generate and execute query
tstart = Time::now
dbh = DBI::connect('DBI:Pg:dbname=udd;port=5441;host=localhost', 'guest')
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'
q += "and #{f[2]} \n"
elsif filters[f[0]] == 'ign'
q += "and not (#{f[2]}) \n"
end
end
if fnewer == 'only'
q += "and (current_timestamp - interval '#{fnewerval} days' <= arrival) \n"
elsif fnewer == 'ign'
q += "and (current_timestamp - interval '#{fnewerval} days' > arrival) \n"
end
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
rows = sth.fetch_all
puts "
#{rows.length} bugs found.
"
puts '
'
if sortby != 'popcon'
puts '| bug# | package | title | last modified |
|---|
'
else
puts '| bug# | package | title | popcon | last modified |
|---|
'
end
rows.each do |r|
puts "| ##{r['id']} | "
puts ""
srcs = r['source'].split(/,\s*/)
bins = r['package'].split(/,\s*/)
puts (0...bins.length).map { |i| "#{bins[i]}" }.join(', ')
puts " | "
puts "#{CGI::escapeHTML(r['title'])} | "
if sortby == 'popcon'
puts "#{r['popcon']} | "
end
puts "#{r['last_modified'].to_date} |
"
end
=begin
release goals:
all
include / only
columns:
id
source
package
title
time
data last refreshed
EOF
=end
=begin
sth = dbh.prepare("select id, bugs.package, bugs.source, insts, title from bugs, popcon_src where bugs.source = popcon_src.source and id in (select id from bugs_rt_affects_testing_and_unstable) and id in (select id from bugs_tags where tag='patch') and id not in (select id from bugs_tags where tag='pending') and severity >= 'serious' order by id")
sth.execute ; rows = sth.fetch_all
puts "RC bugs tagged patch (and not pending)
"
puts ""
puts "| bug | package | source | popcon | title |
|---|
"
rows.each do |r|
puts "| #{r['id']} | "
puts "#{r['package']} | "
puts "#{r['source']} | "
puts "#{r['insts']} | "
puts "#{r['title']} | "
end
puts "
"
sth.finish
puts "RC bugs on packages with a newer version in Ubuntu (possible patches), not tagged patch nor pending
"
puts ""
puts "| bug | package | source | versions (D/U) | popcon | title |
|---|
"
sth = dbh.prepare("WITH ubudeb AS (select distinct on (d.source, u.source) d.source as dsource, u.source as usource, d.version as dversion, u.version as uversion from sources_uniq d, ubuntu_sources u where d.release = 'sid' and d.distribution = 'debian' and u.release = '#{URELEASE}' and u.distribution = 'ubuntu' and u.source = d.source and u.version > d.version order by d.source asc, u.source asc, d.version desc)
select id, bugs.package, bugs.source, title, dversion, uversion, insts from bugs, ubudeb, popcon_src where popcon_src.source = bugs.source and id in (select id from bugs_rt_affects_testing_and_unstable) and id not in (select id from bugs_tags where tag='patch') and id not in (select id from bugs_tags where tag='pending') and severity >= 'serious' and ubudeb.dsource = bugs.source order by id")
sth.execute ; rows = sth.fetch_all
rows.each do |r|
puts "| #{r['id']} | "
puts "#{r['package']} | "
puts "#{r['source']} UbCh | "
puts "#{r['dversion']} / #{r['uversion']} | "
puts "#{r['insts']} | "
puts "#{r['title']} | "
end
puts "
"
sth.finish
sth = dbh.prepare("select id, bugs.package, bugs.source, insts, title from bugs, popcon_src where bugs.source = popcon_src.source and id in (select id from bugs_rt_affects_testing) and id not in (select id from bugs_rt_affects_unstable) and severity >= 'serious' order by package")
sth.execute ; rows = sth.fetch_all
puts "RC bugs affecting only testing (not unstable, and not pending)
"
puts ""
puts "| bug | package | source | popcon | title |
|---|
"
rows.each do |r|
puts "| #{r['id']} | "
puts "#{r['package']} | "
puts "#{r['source']} | "
puts "#{r['insts']} | "
puts "#{r['title']} | "
end
puts "
"
sth.finish
=end
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 " (%.1f hours ago)
" % ((Time::now - r2[0][0].to_time) / 3600)
puts "
#{q}"
end # if cgi.params != {}
puts <<-EOF
EOF
Bugs Search @ UDD