[Git][qa/jenkins.debian.net][master] 2 commits: reproducible Debian: whitespace reformatting

[Holger Levsen (@holger)]

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


Commits:
514bf8c4 by Holger Levsen at 2024-04-12T23:56:33+02:00
reproducible Debian: whitespace reformatting

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

- - - - -
92078b00 by Holger Levsen at 2024-04-13T00:02:28+02:00
reproducible Debian: exclude currently building packages from breakage detection

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

- - - - -


1 changed file:

- bin/reproducible_html_breakages.py


Changes:

=====================================
bin/reproducible_html_breakages.py
=====================================
@@ -2,7 +2,7 @@
 # -*- coding: utf-8 -*-
 #
 # Copyright © 2015-2023 Mattia Rizzolo <mattia at mapreri.org>
-# Copyright © 2016-2018 Holger Levsen <holger at layer-acht.org>
+# Copyright © 2016-2024 Holger Levsen <holger at layer-acht.org>
 #
 # Licensed under GPL-2
 #
@@ -103,11 +103,15 @@ def not_unrep_with_dbd_file():
 def lack_rbuild():
     log.info('running lack_rbuild check...')
     bad_pkgs = []
+    # the OUTER JOIN and the WHERE NOT EXISTS in the following query is used to exclude the packages currently building
     query = '''SELECT s.name, r.version, s.suite, s.architecture
-               FROM sources AS s JOIN results AS r ON r.package_id=s.id
+               FROM sources AS s
+               JOIN results AS r ON r.package_id=s.id
+               FULL OUTER JOIN schedule AS sch ON sch.package_id=s.id
                WHERE r.status NOT IN ('blacklisted', '')
                AND s.distribution = (SELECT id FROM distributions WHERE name = 'debian')
                AND s.suite NOT IN :as
+               AND NOT EXISTS (SELECT 1 FROM schedule AS sch WHERE sch.date_build_started IS NOT NULL and sch.package_id=s.id)
                ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(text(query), {'as': ARCHIVED_SUITES})
     for pkg, version, suite, arch in results:
@@ -123,12 +127,16 @@ def lack_rbuild():
 def lack_buildinfo():
     log.info('running lack_buildinfo check...')
     bad_pkgs = []
+    # the OUTER JOIN and the WHERE NOT EXISTS in the following query is used to exclude the packages currently building
     query = '''SELECT s.name, r.version, s.suite, s.architecture
-               FROM sources AS s JOIN results AS r ON r.package_id=s.id
+               FROM sources AS s
+               JOIN results AS r ON r.package_id=s.id
+               FULL OUTER JOIN schedule AS sch ON sch.package_id=s.id
                WHERE r.status NOT IN
                 ('blacklisted', 'NFU', 'FTBFS', 'timeout', 'depwait', 'E404')
                AND s.distribution = (SELECT id FROM distributions WHERE name = 'debian')
                AND s.suite NOT IN :as
+               AND NOT EXISTS (SELECT 1 FROM schedule AS sch WHERE sch.date_build_started IS NOT NULL and sch.package_id=s.id)
                ORDER BY s.name ASC, s.suite DESC, s.architecture ASC'''
     results = query_db(text(query), {'as': ARCHIVED_SUITES})
     for pkg, version, suite, arch in results:



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/3b390f7e7a962d5ba5e182630f29c3d52b20c899...92078b00243520aa5017578697f512182facdf5e

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/compare/3b390f7e7a962d5ba5e182630f29c3d52b20c899...92078b00243520aa5017578697f512182facdf5e
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/20240412/72d964ce/attachment-0001.htm>