Secure testing commits - Mar 2010 - r14302 - lib/python

Author: gilbert-guest
Date: 2010-03-19 22:46:57 +0000 (Fri, 19 Mar 2010)
New Revision: 14302

Modified:
   lib/python/security_db.py
Log:
insert nvd urgencies into package_notes (this is where debsecan gets its urgency
values)

Modified: lib/python/security_db.py
==================================================================---
lib/python/security_db.py	2010-03-19 22:17:13 UTC (rev 14301)
+++ lib/python/security_db.py	2010-03-19 22:46:57 UTC (rev 14302)
@@ -1163,6 +1163,18 @@
             FROM nvd_data AS n, binary_package_status AS b
             WHERE b.bug_name == n.cve_name
             AND b.urgency == ''not yet
assigned''""")
+        cursor.execute(
+            """REPLACE INTO package_notes
+            SELECT p.id, p.bug_name, p.package, p.fixed_version,
+            p.fixed_version_id, p.release, p.package_kind,      
+            CASE WHEN n.severity == ''Medium'' THEN
''medium''
+            ELSE CASE WHEN n.severity == ''High'' THEN
''high''
+            ELSE CASE WHEN n.severity == ''Low'' THEN
''low''
+            ELSE ''not yet assigned'' END END END,
+            p.bug_origin
+            FROM nvd_data AS n, package_notes AS p
+            WHERE p.bug_name == n.cve_name
+            AND p.urgency == ''not yet
assigned''""")
 
         # Calculate the release-specific bug status.