[sf-lug] sf-lug list stats

[Michael Paoli]

And, now that it's also quite regularly and automagically backed up (at
least for the most part), it's also pretty easy to pull some stats off
of it:

The roster (list of subscribers), number of subscribers, by date:
$ sf-lug_roster_stats
YYYY-MM-DD
2015-04-21 314
2015-04-12 315
2015-04-07 314
2015-04-06 313
2015-04-05 314
2015-03-18 315
2015-03-15 316
2015-03-06 318
2015-02-06 319
2015-02-04 318
2015-02-02 319
2015-01-22 328
$

The mbox files, lines, by date:
$ sf-lug_mbox_stats
YYYY-MM-DD
2015-04-30 1299831
2015-04-27 1299728
2015-04-25 1299634
2015-04-22 1299457
2015-04-21 1299232
2015-04-18 1298690
2015-04-15 1298454
2015-04-15 1298217
2015-04-13 1298076
2015-04-10 1297982
2015-04-10 1297822
2015-04-09 1297468
2015-04-06 1296922
2015-04-06 1296670
2015-04-05 1296444
2015-03-30 1295298
2015-03-25 1294926
2015-03-18 1293977
2015-03-17 1293874
2015-03-17 1292922
2015-03-15 1292640
2015-03-11 1292303
2015-03-11 1292180
2015-03-10 1291364
2015-03-08 1291153
2015-03-04 1291055
2015-03-02 1290956
2015-02-27 1251096
2015-02-26 1250935
2015-02-25 1249646
2015-02-23 1248598
2015-02-22 1248485
2015-02-21 1248330
2015-02-20 1248247
2015-02-19 1247886
2015-02-18 1247379
2015-02-16 1247198
2015-02-16 1247050
2015-02-14 1246801
2015-02-13 1246732
2015-02-12 1246387
2015-02-11 1245844
2015-02-10 1245588
2015-02-08 1244431
2015-02-07 1244364
2015-02-02 1242206
2015-02-01 1240232
2015-01-22 1231523
$

$ expand -t 4 < ~/bin/sf-lug_roster_stats
#!/bin/sh
cd /home/sflug/sf-lug_roster &&
rlog sf-lug_roster |
sed -ne '
     /^revision ./{
         s/^revision //
         h
     }
     /^date: [0-9][0-9][0-9][0-9]\/[0-9][0-9]\/[0-9][0-9]  
[0-9][0-9]:[0-9][0-9]:[0-9][0-9];/{
         s/^date:  
\([0-9][0-9][0-9][0-9]\)\/\([0-9][0-9]\)\/\([0-9][0-9]\)  
[0-9][0-9]:[0-9][0-9]:[0-9][0-9];.*$/\1-\2-\3/
         H
         s/.*//
         x
         s/\n/ /
         /^[^    ][^     ]* [0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$/p
         d
     }
' |
{
     echo 'YYYY-MM-DD'
     while read r yyyymmdd
     do
         echo "$yyyymmdd" \
         $(2>>/dev/null co -p"$r" sf-lug_roster | wc -l)
     done
}
$ diff ~/bin/sf-lug_roster_stats ~/bin/sf-lug_mbox_stats
2,3c2,3
< cd /home/sflug/sf-lug_roster &&
< rlog sf-lug_roster |
---
> cd /var/www/sf-lug &&
> rlog sf-lug.mbox |
24c24
<               $(2>>/dev/null co -p"$r" sf-lug_roster | wc -l)
---
>               $(2>>/dev/null co -p"$r" sf-lug.mbox | wc -l)
$

references:
http://linuxmafia.com/pipermail/sf-lug/2015q1/011139.html