summaryrefslogtreecommitdiffstats
path: root/bin/reproducible_json.sh
diff options
context:
space:
mode:
Diffstat (limited to 'bin/reproducible_json.sh')
-rwxr-xr-xbin/reproducible_json.sh41
1 files changed, 41 insertions, 0 deletions
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