blob: 615c5b58e06bba985d272ddbd483008bc46b2645 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
#!/bin/sh
pool="/srv/apt/pub/repos/apt/pool/"
stats="/srv/apt/stats.sql"
date=$(date +%F)
debs=$(find $pool -name \*.deb | wc -l)
distinctdebnames=$(find $pool -name \*.deb | sed -e 's!.*/!!' -e 's/_.*//' | sort -u | wc -l)
dscs=$(find $pool -name \*.dsc | wc -l)
distinctsourceversions=$(find $pool -name '*.dsc' | sed -e 's!.*/!!' -e 's/.pgdg.*//' -e 's/.bpo.*//' -e 's/.pgapt.*//' -e 's/\.dsc$//' | sort -u | wc -l)
distinctsourcenames=$(find $pool -name '*.dsc' | sed -e 's!.*/!!' -e 's/_.*//' | sort -u | wc -l)
poolsizekb=$(du -s $pool | awk '{ print $1 }')
poolsize=$((poolsizekb*1024))
echo "INSERT INTO stats (date, debs, distinctdebnames, dscs, distinctsourceversions, distinctsourcenames, poolsize)" \
"VALUES ('$date', $debs, $distinctdebnames, $dscs, $distinctsourceversions, $distinctsourcenames, $poolsize);" >> $stats
|
