#!/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