From 310f28365f4dd6a247390e812c689642025aeea6 Mon Sep 17 00:00:00 2001
From: Holger Levsen <holger@layer-acht.org>
Date: Sun, 28 Sep 2014 01:14:19 +0200
Subject: reproducible: new job, displaying statistics

---
 bin/reproducible_stats.sh | 30 ++++++++++++++++++++++++++++++
 job-cfg/reproducible.yaml | 11 ++++++++++-
 2 files changed, 40 insertions(+), 1 deletion(-)
 create mode 100755 bin/reproducible_stats.sh

diff --git a/bin/reproducible_stats.sh b/bin/reproducible_stats.sh
new file mode 100755
index 00000000..51c233be
--- /dev/null
+++ b/bin/reproducible_stats.sh
@@ -0,0 +1,30 @@
+#!/bin/bash
+
+# Copyright 2014 Holger Levsen <holger@layer-acht.org>
+# released under the GPLv=2
+
+set +x
+PACKAGES_DB=/var/lib/jenkins/reproducible.db
+if [ ! -f $PACKAGES_DB ] ; then
+	echo "$PACKAGES_DB doesn't exist, no stats possible."
+	exit 1
+fi 
+
+GOOD=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"reproducible\" ORDER BY name" | xargs echo)
+COUNT_GOOD=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"reproducible\"")
+BAD=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"unreproducible\" ORDER BY name" | xargs echo)
+COUNT_BAD=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"unreproducible\"")
+UGLY=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"FTBFS\" ORDER BY name" | xargs echo)
+COUNT_UGLY=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"FTBFS\"")
+SOURCELESS=$(sqlite3 $PACKAGES_DB "SELECT name FROM source_packages WHERE status = \"404\" ORDER BY name" | xargs echo)
+COUNT_SOURCELESS=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages WHERE status = \"404\"" | xargs echo)
+COUNT_TOTAL=$(sqlite3 $PACKAGES_DB "SELECT COUNT(name) FROM source_packages")
+
+echo
+echo "Simple statistics for reproducible builds as tested on jenkins.debian.net so far"
+echo 
+echo "$COUNT_TOTAL packages attempted to build in total."
+echo "$COUNT_GOOD packages successfully built reproducibly: ${GOOD}"
+echo "$COUNT_BAD packages failed to built reproducibly: ${BAD}"
+echo "$COUNT_UGLY packages failed to build from source: ${UGLY}"
+echo "$COUNT_SOURCELESS packages doesn't exist in sid and need investigation: $SOURCELESS"
diff --git a/job-cfg/reproducible.yaml b/job-cfg/reproducible.yaml
index 8b8cf4e6..b8d83839 100644
--- a/job-cfg/reproducible.yaml
+++ b/job-cfg/reproducible.yaml
@@ -48,6 +48,10 @@
     defaults: reproducible
     name: '{name}_setup'
 
+- job-template:
+    defaults: reproducible
+    name: '{name}_stats'
+
 - job-template:
     defaults: reproducible
     name: '{name}_build_test_reproducibility'
@@ -120,8 +124,13 @@
             my_timed: '42 0 * * *'
             my_shell: '/srv/jenkins/bin/reproducible_setup.sh'
             my_packages: ''
+        - '{name}_stats':
+            my_description: 'Reproducible builds statistics'
+            my_timed: '0 0 * * *'
+            my_shell: '/srv/jenkins/bin/reproducible_stats.sh'
+            my_packages: ''
         - '{name}_build_random_packages':
-            my_description: 'Reproducible build 50 random packages each day.'
+            my_description: 'Reproducible build this many random packages each day:'
             my_timed: '23 3 * * *'
             my_shell: '/srv/jenkins/bin/reproducible_build.sh'
             my_packages: '50'
-- 
cgit v1.2.3-70-g09d2