stats.sh

#!/bin/busybox ash
#
# Script to show some stats

test -z "$BACKUP_BIN" && BACKUP_BIN="${0%/*}"
. "$BACKUP_BIN/common.sh"

cd "$BACKUP_ROOT"

banner() {
	echo  ===== ===== "$@" ===== =====
}

if [ "$STATS_HEADERS" = 1 ]; then
	echo "To: alexey+crontab@shpakovsky.ru"
	echo "Subject: `hostname` backup-stats"
	echo
fi

banner uptime
uptime

echo
# banner sensors
# sensors

banner disk usage
sh -c "$STATS_DF"

echo
banner backup stats

test "$STATS_BROWSERS" = 1 && echo " SELECT
		dirname AS 'Last backup of browser tabs',
		filename,
		max(created) AS 'created',
		round(julianday('now', 'localtime') - julianday(created), 2) AS 'days ago'
	FROM history
	WHERE freq = 0
	  AND dirname LIKE './browsers/%/Sessions/'
	GROUP BY dirname;" | $SQLITE -header -column

echo

echo 'Last backup per'
ls "$BACKUP_CURRENT" | while read -r line; do
echo " SELECT
		'$line' as 'directory      ',
		'created' AS 'direction',
		max(created) AS 'Last backup',
		round(julianday('now', 'localtime') - julianday(max(created)), 2) AS 'days ago'
	FROM history
	WHERE freq = 0
	  AND dirname LIKE './$line/%'
UNION ALL
	SELECT
		'$line',
		'deleted' AS 'direction',
		max(deleted) AS 'Last backup',
		round(julianday('now', 'localtime') - julianday(max(deleted)), 2) AS 'days ago'
	FROM history
	WHERE freq != 0
	  AND dirname LIKE './$line/%'
UNION ALL"
done | sed '$d' | $SQLITE -header -column

echo
echo " SELECT
		freq,
		min(deleted) AS 'oldest file',
		round((strftime('%s','now','localtime')-strftime('%s',min(deleted)))*freq/2592000,2) as 'age'
        FROM history
        WHERE freq != 0
	  AND freq <= 8640
        GROUP BY freq;" | $SQLITE -header -column

if [ "$(echo 'SELECT count(*) FROM bad_new_files' | $SQLITE)" != 0 ]; then
	banner bad new files
	echo 'SELECT * FROM bad_new_files' | $SQLITE -header -column
fi

echo "DROP INDEX IF EXISTS api" | $SQLITE -header -column

test "$STATS_DU" = 1 || exit 0

echo
echo "Disk usage of each dir"
echo "---- ----- -- ---- ---"

(
	echo 'name current data'
	(
		echo .
		ls data
	) | xargs -I% echo 'echo "% $(test -e current/% && du -h -d0 current/% | cut -f1) $(du -h -d0 data/% | cut -f1)"' | sh
) | column -t

# echo
# echo "Par2 stats"
# echo "---- -----"

# ~/git/backup3/par2stats.sh -q