add sorted bug time series and makefile rules for them

[debbugs-presentations.git] / debconf14 / data / Makefile

diff --git a/debconf14/data/Makefile b/debconf14/data/Makefile
index ffd10f6baa835b167198818ac10fa3a74fbb062f..8b236156e7624e32fbbb40a7ec97191e2756e541 100644 (file)
--- a/debconf14/data/Makefile
+++ b/debconf14/data/Makefile
@@ -2,7 +2,7 @@
 
 DEBBUGS_MASTER=buxtehude.debian.org
 
-DATA_FILES=sorted_bug_growth_for_r_every_500.txt rc_bugs.txt
+DATA_FILES=sorted_bug_growth_for_r_every_500.txt rc_bugs.txt bug_closed_time_series.txt
 
 all: 
        echo "Not doing anything";
@@ -13,7 +13,10 @@ sorted_bug_growth_for_r_every_500.txt:
                sort -n | perl -n -e 'BEGIN {$$a = 0; } if (! ($$a++ % 500)) {s/.report//; print $$_; }' > $@
 
 rc_bugs.txt: 
-       ssh $(DEBBUGS_MASTER) '(cd /srv/bugs.debian.org/bugscan/counts/; echo -e "date\ttotal\tpending\tpatch\tunknown\tignore\tunknown\taffects.testing\taffects.stable"; for a in count-*; do echo -n $${a##count-}; echo -n " "; cat $$a; done; )' > $@
+       ssh $(DEBBUGS_MASTER) '(cd /srv/bugs.debian.org/bugscan/counts/; echo -e "date\ttotal\tpending\tpatch\tunknown\tignore\tunknown\taffects.testing\taffects.stable"; for a in count-*; do echo -n $${a##count-}; echo -n " "; cat $$a; echo; done; )'|grep -v '^$$' > $@
+
+bug_closed_time_series.txt:
+       ssh $(DEBBUGS_MASTER) "find /srv/bugs.debian.org/spool/archive -name '*.log' -printf '%TY-%TW\n'|sort -n|uniq -c" | perl -pe 's/^\s+//;' > $@
 
 
 .PHONY: $(DATA_FILES)