From 1eb77335b1b55233388142956a20095596744b74 Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Sat, 4 Apr 2015 23:59:08 +0200 Subject: 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(-) (limited to 'bin') diff --git a/bin/reproducible_build.sh b/bin/reproducible_build.sh index fe94cee6..f41a9614 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 -- cgit v1.2.3-70-g09d2