From 41707352ccc6867180d80ad71801942d7ded423a Mon Sep 17 00:00:00 2001
From: Holger Levsen <holger@layer-acht.org>
Date: Fri, 7 Nov 2014 16:45:00 +0000
Subject: reproducible: new job to generate
 https://jenkins.debian.net/userContent/reproducible.json

---
 bin/reproducible_json.sh | 41 +++++++++++++++++++++++++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100755 bin/reproducible_json.sh

(limited to 'bin')

diff --git a/bin/reproducible_json.sh b/bin/reproducible_json.sh
new file mode 100755
index 00000000..9c38d42d
--- /dev/null
+++ b/bin/reproducible_json.sh
@@ -0,0 +1,41 @@
+#!/bin/bash
+
+# Copyright 2014 Holger Levsen <holger@layer-acht.org>
+# released under the GPLv=2
+
+DEBUG=false
+. /srv/jenkins/bin/common-functions.sh
+common_init "$@"
+
+# common code defining db access
+. /srv/jenkins/bin/reproducible_common.sh
+
+set +x
+
+write_json() {
+	echo "$1" >> $JSON
+}
+
+JSON=$(mktemp)
+RESULT=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT name,version,status FROM source_packages WHERE status != \"\"")
+COUNT_TOTAL=$(sqlite3 -init $INIT $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status != \"\"")
+echo "$(date) - processing $COUNT_TOTAL packages to create .json output... this will take a while."
+
+write_json "["
+for LINE in $RESULT ; do
+	PKG=$(echo $LINE | cut -d "|" -f1)
+	VERSION=$(echo $LINE | cut -d "|" -f2)
+	STATUS=$(echo $LINE | cut -d "|" -f3)
+	write_json "{"
+	write_json "\"package\": \"$PKG\","
+	write_json "\"version\": \"$VERSION\","
+	write_json "\"status\": \"$STATUS\","
+	write_json "\"suite\": \"sid\""
+	write_json "}"
+done
+write_json "]"
+
+echo
+echo "$(date) - $JENKINS_URL/userContent/reproducible.json has been updated."
+mv $JSON /var/lib/jenkins/userContent/reproducible.json
+chmod 755 /var/lib/jenkins/userContent/reproducible.json
-- 
cgit v1.2.3-70-g09d2