[Qa-jenkins-scm] [jenkins.debian.net] 01/03: reproducible: build: wrap the long choose_package() query in multiple lines

[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 fac086f4263eb29eed4b425bc98a35b693c79958
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Mon Jul 13 17:24:52 2015 +0000

    reproducible: build: wrap the long choose_package() query in multiple lines
---
 bin/reproducible_build.sh | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh
index 7ee7282..39c9a8a 100755
--- a/bin/reproducible_build.sh
+++ b/bin/reproducible_build.sh
@@ -325,7 +325,10 @@ call_debbindiff_on_changes_files() {
 }
 
 choose_package () {
-	local RESULT=$(sqlite3 -init $INIT ${PACKAGES_DB} "SELECT s.suite, s.id, s.name, sch.date_scheduled, sch.save_artifacts, sch.notify, s.notify_maintainer, sch.builder 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")
+	local RESULT=$(sqlite3 -init $INIT ${PACKAGES_DB} "
+		SELECT s.suite, s.id, s.name, sch.date_scheduled, sch.save_artifacts, sch.notify, s.notify_maintainer, sch.builder
+		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")
 	SUITE=$(echo $RESULT|cut -d "|" -f1)
 	SRCPKGID=$(echo $RESULT|cut -d "|" -f2)
 	SRCPACKAGE=$(echo $RESULT|cut -d "|" -f3)

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