[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] 2 commits: reproducible: add link to current db schema

[Holger Levsen]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
29a45858 by Holger Levsen at 2019-07-09T20:10:57Z
reproducible: add link to current db schema

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -
a36a27af by Holger Levsen at 2019-07-09T20:13:24Z
reproducible: fixup 5c62ea9d and 0ab61da0 and make old Arch Linux results use the same stati as Debian

Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/reproducible_db_maintenance.py


Changes:

=====================================
bin/reproducible_db_maintenance.py
=====================================
@@ -2,7 +2,7 @@
 # -*- coding: utf-8 -*-
 #
 # Copyright © 2015-2018 Mattia Rizzolo <mattia at mapreri.org>
-# Copyright © 2015 Holger Levsen <holger at layer-acht.org>
+# Copyright © 2015-2019 Holger Levsen <holger at layer-acht.org>
 # Based on various reproducible_* files © 2014-2015 Holger Levsen <holger at layer-acht.org>
 # Licensed under GPL-2
 #
@@ -23,6 +23,8 @@ from rblib.utils import print_critical_message
 
 now = datetime.now().strftime("%Y-%m-%d-%H-%M-%S")
 
+# the current schema is here:
+#   https://tests.reproducible-builds.org/reproducibledb.html
 
 # the original schema is here
 db_schema = [
@@ -688,7 +690,7 @@ schema_updates = {
         "INSERT INTO distributions (name) VALUES "
         "('openwrt')"
     ],
-    43: [
+    43: [  # Arch Linux should use the same stati as Debian
         "UPDATE results SET status='reproducible' WHERE status='GOOD'",
         "UPDATE results SET status='blacklisted' WHERE status='BLACKLISTED'"
     ],
@@ -712,6 +714,10 @@ schema_updates = {
                 FROM bullseye AS b JOIN sr ON b.name=sr.name
                     AND b.architecture=sr.architecture""",
     ],
+    45: [  # fixup #43
+        "UPDATE stats_build SET status='reproducible' WHERE status='GOOD'",
+        "UPDATE stats_build SET status='blacklisted' WHERE status='BLACKLISTED'"
+    ],
 }
 
 



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/compare/d9196afe529cb9473e3bd127738354d96c4b6cbc...a36a27afb8056556649d65e97ef5d79aa506adb2

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/compare/d9196afe529cb9473e3bd127738354d96c4b6cbc...a36a27afb8056556649d65e97ef5d79aa506adb2
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20190709/ec31d385/attachment-0001.html>