[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible arch: fix query for unknown results
Holger Levsen
gitlab at salsa.debian.org
Sun Sep 27 18:35:44 BST 2020
Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net
Commits:
6fcde1d8 by stefan0xC at 2020-09-27T19:33:20+02:00
reproducible arch: fix query for unknown results
Querying for 'UNKNOWN_%' will only return 0 results because LIKE treats
_ as a wildcard for exactly 1 character (while % would be 0, 1 or more)
but the status according to bin/reproducible_common.sh will be UNKNOWN
Signed-off-by: Holger Levsen <holger at layer-acht.org>
- - - - -
1 changed file:
- bin/reproducible_html_archlinux.sh
Changes:
=====================================
bin/reproducible_html_archlinux.sh
=====================================
@@ -62,7 +62,7 @@ repostats(){
NR_DEPWAIT=$(query_db "SELECT count(*) FROM sources AS s JOIN results AS r ON s.id=r.package_id WHERE s.distribution=$DISTROID AND s.architecture='x86_64' AND s.suite='$SUITE' AND r.status LIKE 'DEPWAIT_%';")
NR_404=$(query_db "SELECT count(*) FROM sources AS s JOIN results AS r ON s.id=r.package_id WHERE s.distribution=$DISTROID AND s.architecture='x86_64' AND s.suite='$SUITE' AND r.status LIKE '404_%';")
NR_BLACKLISTED=$(query_db "SELECT count(*) FROM sources AS s JOIN results AS r ON s.id=r.package_id WHERE s.distribution=$DISTROID AND s.architecture='x86_64' AND s.suite='$SUITE' AND r.status='blacklisted';")
- NR_UNKNOWN=$(query_db "SELECT count(*) FROM sources AS s JOIN results AS r ON s.id=r.package_id WHERE s.distribution=$DISTROID AND s.architecture='x86_64' AND s.suite='$SUITE' AND r.status LIKE 'UNKNOWN_%';")
+ NR_UNKNOWN=$(query_db "SELECT count(*) FROM sources AS s JOIN results AS r ON s.id=r.package_id WHERE s.distribution=$DISTROID AND s.architecture='x86_64' AND s.suite='$SUITE' AND r.status LIKE 'UNKNOWN';")
NR_UNTESTED=$(query_db "SELECT count(s.name) FROM sources AS s WHERE s.architecture='x86_64' AND s.distribution=$DISTROID AND s.suite='$SUITE' AND s.id NOT IN (SELECT package_id FROM results)")
if [ $NR_UNTESTED -ne 0 ] ; then
let NR_UNKNOWN=$NR_UNKNOWN+$NR_UNTESTED
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/6fcde1d8be36a8f161174acb86e77d41e75f0f7a
--
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/6fcde1d8be36a8f161174acb86e77d41e75f0f7a
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/20200927/fcb5933d/attachment-0001.html>
More information about the Qa-jenkins-scm
mailing list