[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: build: no real need to look up for a particular suite while SQL quering for a package to build

[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 1eb77335b1b55233388142956a20095596744b74
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Sat Apr 4 23:59:08 2015 +0200

    reproducible: build: no real need to look up for a particular suite while SQL quering for a package to build
---
 bin/reproducible_build.sh | 12 +-----------
 1 file changed, 1 insertion(+), 11 deletions(-)

diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh
index fe94cee..f41a961 100755
--- a/bin/reproducible_build.sh
+++ b/bin/reproducible_build.sh
@@ -165,17 +165,7 @@ TMPCFG=$(mktemp -t pbuilderrc_XXXX)
 trap cleanup_all INT TERM EXIT
 cd $TMPDIR
 
-SQL_SUITES=""
-for i in $SUITES ; do
-	if [ -n "$SQL_SUITES" ] ; then
-		SQL_SUITES="$SQL_SUITES, '$i'"
-	else
-		SQL_SUITES="('$i'"
-	fi
-done
-SQL_SUITES="$SQL_SUITES)"
-
-RESULT=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.suite, s.id, s.name, sch.date_scheduled, sch.save_artifacts FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id WHERE sch.date_build_started = '' AND s.suite IN $SQL_SUITES ORDER BY date_scheduled LIMIT 1")
+RESULT=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.suite, s.id, s.name, sch.date_scheduled, sch.save_artifacts FROM schedule AS sch JOIN sources AS s ON sch.package_id=s.id WHERE sch.date_build_started = '' ORDER BY date_scheduled LIMIT 1")
 if [ -z "$RESULT" ] ; then
 	echo "No packages scheduled, sleeping 30m."
 	sleep 30m

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