[Qa-jenkins-scm] [jenkins.debian.net] 01/01: reproducible: maintenance: pretty print sql query results (instead of simple |-separated values)

[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 c2884cb80b82bc83fd60cdf900cdca17cdd738b9
Author: Mattia Rizzolo <mattia at mapreri.org>
Date:   Tue Apr 21 14:22:35 2015 +0200

    reproducible: maintenance: pretty print sql query results (instead of simple |-separated values)
---
 bin/reproducible_maintenance.sh | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/bin/reproducible_maintenance.sh b/bin/reproducible_maintenance.sh
index 35adf24..f471d13 100755
--- a/bin/reproducible_maintenance.sh
+++ b/bin/reproducible_maintenance.sh
@@ -170,9 +170,7 @@ sqlite3 -init $INIT ${PACKAGES_DB} "$QUERY" > $PACKAGES 2> /dev/null || echo "Wa
 if grep -q '|' $PACKAGES ; then
 	echo
 	echo "Warning: packages found where the build was started more than 36h ago:"
-	echo "pkg_id|name|date_scheduled|date_build_started"
-	echo
-	cat $PACKAGES
+	sqlite3 -init $INIT -header -column ${PACKAGES_DB} "$QUERY" 2> /dev/null || echo "Warning: SQL query '$QUERY' failed."
 	echo
 	for PKG in $(cat $PACKAGES | cut -d "|" -f1) ; do
 		echo "sqlite3 ${PACKAGES_DB}  \"DELETE FROM schedule WHERE package_id = '$PKG';\""

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