[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: pre-fill form with latest unreproducible or ftbfs result in unstable which has no note

[Holger Levsen]

This is an automated email from the git hooks/post-receive script.

holger pushed a commit to branch master
in repository jenkins.debian.net.

commit 622c77e88630baa46f1ff9cab243223f22fada1b
Author: Holger Levsen <holger at layer-acht.org>
Date:   Sun Jul 19 09:20:19 2015 +0200

    reproducible: pre-fill form with latest unreproducible or ftbfs result in unstable which has no note
---
 bin/reproducible_common.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/bin/reproducible_common.sh b/bin/reproducible_common.sh
index 4d964a1..5db4a4d 100755
--- a/bin/reproducible_common.sh
+++ b/bin/reproducible_common.sh
@@ -222,7 +222,7 @@ write_page_header() {
 	write_page "<li><a href=\"https://wiki.debian.org/ReproducibleBuilds\" target=\"_blank\">wiki</a></li>"
 	write_page "</ul>"
 	if [ "$1" = "$MAINVIEW" ] ; then
-		LATEST=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id = s.id WHERE r.status = 'unreproducible' order by build_date desc limit 1")
+		LATEST=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id = s.id WHERE r.status IN ('unreproducible', 'FTBFS') AND s.id NOT IN (SELECT package_id FROM notes) ORDER BY build_date DESC LIMIT 1")
 		write_page "<form onsubmit=\"location.href='https://reproducible.debian.net/' + document.getElementById('SrcPkg').value; return false;\">"
 		write_page "https://reproducible.debian.net/<input type=\"text\" id=\"SrcPkg\" value=\"$LATEST\"/>"
 		write_page "<input type=\"submit\" value=\"submit source package name\" />"

-- 
Alioth's /usr/local/bin/git-commit-notice on /srv/git.debian.org/git/qa/jenkins.debian.net.git