[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible Debian: seed bookworm with data from bullseye

[Holger Levsen (@holger)]

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


Commits:
7cdc13c8 by Holger Levsen at 2021-08-17T11:54:55+02:00
reproducible Debian: seed bookworm with data from bullseye

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-2020 Holger Levsen <holger at layer-acht.org>
+# Copyright © 2015-2021 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
 #
@@ -775,6 +775,26 @@ schema_updates = {
         '''ALTER TABLE stats_bugs ADD COLUMN open_hashordering INTEGER DEFAULT 0''',
         '''ALTER TABLE stats_bugs ADD COLUMN done_hashordering INTEGER DEFAULT 0''',
     ],
+    55: [  # copy bullseye packages (including results) in bookworm
+        """INSERT INTO sources (name, version, suite, architecture, notify_maintainer, distribution)
+            SELECT name, version, 'bookworm', architecture, notify_maintainer, distribution
+            FROM sources
+            WHERE suite = 'bullseye'""",
+        """WITH bookworm AS (
+                SELECT id, name, suite, architecture, version
+                FROM sources WHERE suite = 'bookworm'),
+            sr AS (
+                SELECT s.name, s.architecture, r.version, r.status,
+                    r.build_date, r.build_duration, r.node1, r.node2, r.job
+                FROM sources AS s JOIN results AS r ON s.id=r.package_id
+                WHERE s.suite = 'bullseye')
+            INSERT INTO results (package_id, version, status, build_date,
+                    build_duration, node1, node2, job)
+                SELECT b.id, sr.version, sr.status, sr.build_date,
+                    sr.build_duration, sr.node1, sr.node2, sr.job
+                FROM bookworm AS b JOIN sr ON b.name=sr.name
+                    AND b.architecture=sr.architecture""",
+    ],
 }
 
 



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/7cdc13c80691ce912b1f3816b580bfb9f5a79a6c

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/7cdc13c80691ce912b1f3816b580bfb9f5a79a6c
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/20210817/ac2c2bae/attachment-0001.htm>