[Qa-jenkins-scm] [Git][qa/jenkins.debian.net][master] reproducible Debian: fix another SQL error

[Mattia Rizzolo]

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


Commits:
e380dad1 by Mattia Rizzolo at 2019-12-02T19:09:46Z
reproducible Debian: fix another SQL error

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

- - - - -


1 changed file:

- bin/reproducible_html_dashboard.sh


Changes:

=====================================
bin/reproducible_html_dashboard.sh
=====================================
@@ -391,7 +391,7 @@ write_build_performance_stats() {
 
 	write_page "</tr><tr><td class=\"left\">packages tested on $DATE</td>"
 	for ARCH in ${ARCHS} ; do
-		RESULT=$(query_db "SELECT COUNT(r.build_date) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date LIKE '%$DATE%' AND s.architecture='$ARCH'")
+		RESULT=$(query_db "SELECT COUNT(r.build_date) FROM results AS r JOIN sources AS s ON r.package_id=s.id WHERE r.build_date::date = '$DATE' AND s.architecture='$ARCH'")
 		write_page "<td>$RESULT</td>"
 	done
 	write_page "</tr><tr><td class=\"left\">packages tested in the last 24h</td>"



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

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/commit/e380dad155a2530a8a092f5e6f3bb4a06c3931fc
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/20191202/83bf4500/attachment.html>