Author: geissert
Date: 2010-06-27 04:03:20 +0000 (Sun, 27 Jun 2010)
New Revision: 14909
Modified:
bin/tracker_service.py
Log:
Don''t count unimportant issues on data fed to the PTS
Modified: bin/tracker_service.py
==================================================================---
bin/tracker_service.py 2010-06-27 02:10:35 UTC (rev 14908)
+++ bin/tracker_service.py 2010-06-27 04:03:20 UTC (rev 14909)
@@ -1114,13 +1114,13 @@
data = []
for pkg, bugs in self.db.cursor().execute(
"""SELECT package, COUNT(DISTINCT bug) FROM
- (SELECT package, bug FROM stable_status
- UNION ALL SELECT package, bug FROM oldstable_status
- UNION ALL SELECT DISTINCT sp.name, st.bug_name
+ (SELECT package, bug, urgency FROM stable_status
+ UNION ALL SELECT package, bug, urgency FROM oldstable_status
+ UNION ALL SELECT DISTINCT sp.name, st.bug_name, st.urgency
FROM source_package_status AS st, source_packages AS sp
WHERE st.vulnerable AND st.urgency <>
''unimportant''
AND sp.rowid = st.package AND sp.release =
''sid''
- AND sp.subrelease = '''') x
+ AND sp.subrelease = '''') x WHERE urgency
<> ''unimportant''
GROUP BY package ORDER BY package"""):
data.append(pkg)
data.append('':'')