diff options
Diffstat (limited to 'bin/reproducible_json.sh')
| -rwxr-xr-x | bin/reproducible_json.sh | 41 |
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 |