Dump data as .yaml via /tracker/data/yaml (Closes: #761859)

git-svn-id: svn+ssh://svn.debian.org/svn/secure-testing@32509 e39458fd-73e7-0310-bf30-c45bca0a0e42

1 files changed, 8 insertions, 0 deletions

diff --git a/lib/python/security_db.py b/lib/python/security_db.py
index c2de1137d3..51262e495c 100644
--- a/lib/python/security_db.py
+++ b/lib/python/security_db.py
@@ -392,6 +392,14 @@ class DB:
                 ORDER BY sp.name, urgency_to_number(urgency), st.bug_name"""
                 % (name, nickname, nickname, nickname))
 
+        cursor.execute(
+            """CREATE TEMPORARY VIEW debian_cve AS
+            SELECT DISTINCT debian_bugs.bug, st.bug_name
+            FROM package_notes, debian_bugs, source_package_status AS st
+            WHERE package_notes.bug_name = st.bug_name
+            AND debian_bugs.note = package_notes.id
+            ORDER BY debian_bugs.bug""")
+
     def _initFunctions(self):
         """Registers user-defined SQLite functions."""