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

Diff of /udd/web/bugs.cgi

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1835 by lucas, Mon Nov 1 10:18:34 2010 UTC revision 1836 by lucas, Mon Nov 1 10:21:22 2010 UTC
# Line 22  FILTERS = [ Line 22  FILTERS = [
22   ['pending', 'tagged pending', 'id in (select id from bugs_tags where tag=\'pending\')'],   ['pending', 'tagged pending', 'id in (select id from bugs_tags where tag=\'pending\')'],
23   ['security', 'tagged security', 'id in (select id from bugs_tags where tag=\'security\')'],   ['security', 'tagged security', 'id in (select id from bugs_tags where tag=\'security\')'],
24   ['claimed', 'claimed bugs', "id in (select id from bugs_usertags where email='bugsquash@qa.debian.org')"],   ['claimed', 'claimed bugs', "id in (select id from bugs_usertags where email='bugsquash@qa.debian.org')"],
25   ['deferred', 'fixed in deferred/delayed', "id in (select bug from deferred_closes)"],   ['deferred', 'fixed in deferred/delayed', "id in (select id from deferred_closes)"],
26   ['notmain', 'packages not in main', 'id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and component=\'main\')'],   ['notmain', 'packages not in main', 'id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and component=\'main\')'],
27   ['notsqueeze', 'packages not in squeeze', 'id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and release=\'squeeze\')'],   ['notsqueeze', 'packages not in squeeze', 'id not in (select id from bugs_packages, sources where bugs_packages.source = sources.source and release=\'squeeze\')'],
28   ['base', 'packages in base system', 'bugs.source in (select source from sources where priority=\'required\' or priority=\'important\')'],   ['base', 'packages in base system', 'bugs.source in (select source from sources where priority=\'required\' or priority=\'important\')'],
# Line 308  end Line 308  end
308    
309  if cols['cdeferred']  if cols['cdeferred']
310    ids = rows.map { |r| r['id'] }.join(',')    ids = rows.map { |r| r['id'] }.join(',')
311    sthd = dbh.prepare("select bug, deferred.source, deferred.version, extract (day from delayed_until) as du from deferred, deferred_closes where deferred.source = deferred_closes.source and deferred.version = deferred_closes.version and deferred_closes.bug in (#{ids})")    sthd = dbh.prepare("select bug, deferred.source, deferred.version, extract (day from delayed_until) as du from deferred, deferred_closes where deferred.source = deferred_closes.source and deferred.version = deferred_closes.version and deferred_closes.id in (#{ids})")
312    sthd.execute    sthd.execute
313    rowsd = sthd.fetch_all    rowsd = sthd.fetch_all
314    deferredbugs = {}    deferredbugs = {}
Legend:
Removed from v.1835  
changed lines
  Added in v.1836
  ViewVC Help
Powered by ViewVC 1.1.5