[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible debian: build the html pages only of packages belonging to known suites.

[Mattia Rizzolo]

Mattia Rizzolo pushed to branch master at Debian QA / jenkins.debian.net


Commits:
a4d4dcc9 by Mattia Rizzolo at 2018-09-26T14:26:39Z
reproducible debian: build the html pages only of packages belonging to known suites.

Signed-off-by: Mattia Rizzolo <mattia at debian.org>

- - - - -


1 changed file:

- bin/reproducible_html_packages.py


Changes:

=====================================
bin/reproducible_html_packages.py
=====================================
@@ -15,10 +15,11 @@ import errno
 import urllib
 import pystache
 import apt_pkg
+import sqlalchemy
 apt_pkg.init_system()
 
 from rblib import query_db
-from rblib.confparse import log, args
+from rblib.confparse import log, args, conf_distro
 from rblib.models import Package, Status
 from rblib.utils import strip_epoch, convert_into_hms_string
 from rblib.html import gen_status_link_icon, write_html_page
@@ -434,8 +435,8 @@ def gen_packages_html(packages, no_clean=False):
 
 
 def gen_all_rb_pkg_pages(no_clean=False):
-    query = 'SELECT DISTINCT name FROM sources'
-    rows = query_db(query)
+    query = 'SELECT DISTINCT name FROM sources WHERE suite = ANY(:s)'
+    rows = query_db(sqlalchemy.text(query), s=conf_distro['suites'].split())
     pkgs = [Package(str(i[0]), no_notes=True) for i in rows]
     log.info('Processing all %s package from all suites/architectures',
              len(pkgs))



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/a4d4dcc95a06c7f76096d4b014841d13504e8e42

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/a4d4dcc95a06c7f76096d4b014841d13504e8e42
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/20180926/9b065bd9/attachment-0001.html>