| 9 |
RELEASE_RESTRICT = [ |
RELEASE_RESTRICT = [ |
| 10 |
['squeeze', 'squeeze', 'id in (select id from bugs_rt_affects_testing)'], |
['squeeze', 'squeeze', 'id in (select id from bugs_rt_affects_testing)'], |
| 11 |
['sid', 'sid', 'id in (select id from bugs_rt_affects_unstable)'], |
['sid', 'sid', 'id in (select id from bugs_rt_affects_unstable)'], |
| 12 |
['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)'], |
| 13 |
['squeeze_or_sid', 'squeeze or sid', 'id in (select id from bugs_rt_affects_testing union 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)'], |
| 14 |
['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)'], |
['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)'], |
| 15 |
['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)'] |
| 123 |
puts "<input type='radio' name='release' value='#{r[0]}' #{checked}/>#{r[1]} " |
puts "<input type='radio' name='release' value='#{r[0]}' #{checked}/>#{r[1]} " |
| 124 |
end |
end |
| 125 |
puts <<-EOF |
puts <<-EOF |
| 126 |
</p> |
(also uses release tags and xxx-ignore information)</p> |
| 127 |
<table class="invisible"><tr><td> |
<table class="invisible"><tr><td> |
| 128 |
<table class="buglist"> |
<table class="buglist"> |
| 129 |
<tr><th colspan='4'>FILTERS</th></tr> |
<tr><th colspan='4'>FILTERS</th></tr> |
| 199 |
puts "<p><b>#{rows.length} bugs found.</b></p>" |
puts "<p><b>#{rows.length} bugs found.</b></p>" |
| 200 |
puts <<-EOF |
puts <<-EOF |
| 201 |
<table class="buglist"> |
<table class="buglist"> |
| 202 |
<tr><th>bug#</th><th>source pkg</th><th>binary pkg</th><th>title</th><th>last modified</th></tr> |
<tr><th>bug#</th><th>package</th><th>title</th><th>last modified</th></tr> |
| 203 |
EOF |
EOF |
| 204 |
rows.each do |r| |
rows.each do |r| |
| 205 |
puts "<tr><td style='text-align: center;'><a href=\"http://bugs.debian.org/#{r['id']}\">##{r['id']}</a></td>" |
puts "<tr><td style='text-align: center;'><a href=\"http://bugs.debian.org/#{r['id']}\">##{r['id']}</a></td>" |
| 206 |
puts "<td style='text-align: center;'>" |
puts "<td style='text-align: center;'>" |
| 207 |
puts r['source'].split(/,\s*/).map { |pkg| "<a href=\"http://packages.qa.debian.org/#{pkg}\">#{pkg}</a>" }.join(', ') |
srcs = r['source'].split(/,\s*/) |
| 208 |
|
bins = r['package'].split(/,\s*/) |
| 209 |
|
puts (0...bins.length).map { |i| "<a href=\"http://packages.qa.debian.org/#{srcs[i]}\">#{bins[i]}</a>" }.join(', ') |
| 210 |
puts "</td>" |
puts "</td>" |
| 211 |
puts <<-EOF |
puts <<-EOF |
|
<td style='text-align: center;'>#{r['package']}</td> |
|
| 212 |
<td>#{r['title']}</td> |
<td>#{r['title']}</td> |
| 213 |
<td style='text-align: center;'>#{r['last_modified'].to_date}</td> |
<td style='text-align: center;'>#{r['last_modified'].to_date}</td> |
| 214 |
</tr> |
</tr> |