Only enable not-"1.0" formats on t-p-u and unstable and experimental.

[dak.git] / dak / dakdb / update15.py

diff --git a/dak/dakdb/update15.py b/dak/dakdb/update15.py
index 6cf86cc0d34d8783f084e544d7041b1e7543474f..84f1f27b6dddd98195916854902fd88043c90d5b 100644 (file)
--- a/dak/dakdb/update15.py
+++ b/dak/dakdb/update15.py
@@ -58,10 +58,15 @@ def do_update(self):
             )
         """)
 
-        print "Authorize all formats on all suites by default"
-        c.execute("SELECT id FROM suite")
+        print "Authorize format 1.0 on all suites by default"
         suites = c.fetchall()
-        c.execute("SELECT id FROM src_format")
+        for s in suites:
+            c.execute("INSERT INTO suite_src_formats (suite, src_format) VALUES('%s', '%s')" % (s[0], '1.0'))
+
+        print "Authorize all other formats on tpu, unstable & experimental by default"
+        c.execute("SELECT id FROM suite WHERE suite_name IN ('testing-proposed-updates', 'unstable', 'experimental')")
+        suites = c.fetchall()
+        c.execute("SELECT id FROM src_format WHERE format_name != '1.0'")
         formats = c.fetchall()
         for s in suites:
             for f in formats: