#!/bin/bash
export TARGET=/opt/backups
export LADATE=`date +%Y%m%d`
export TODELETE=`date +%Y%m%d -d "3 months ago"`

SCRIPT=`basename $0 .sh`
FLAGFILE=$TARGET/flags/$SCRIPT.$LADATE

if [ -f $FLAGFILE ]
then
  exit 0
fi

if [ ! -f $TARGET/data/liste.txt ]
then
  echo No $TARGET/data/liste.txt found ...
  exit 1 
fi

if [ ! -f $TARGET/data/signatures.sqlite ]
then
  echo No $TARGET/data/signatures.sqlite found ...
  exit 1
fi

HEURE=`date +%H:%M`
echo "--- $HEURE - BEGIN" >> $FLAGFILE

for SOURCE in `grep -v "#" $TARGET/data/liste.txt`
do
  HEURE=`date +%H:%M`
  echo "--- $HEURE - $SOURCE" >> $FLAGFILE
  php $TARGET/scripts/backup.php $SOURCE $TARGET/data
done

HEURE=`date +%H:%M`
echo "--- $HEURE - END" >> $FLAGFILE

sqlite3 $TARGET/data/signatures.sqlite 'VACUUM'
cp $TARGET/data/signatures.sqlite $TARGET/data/$LADATE/signatures.sqlite

sqlite3 $TARGET/data/signatures.sqlite 'select substr(filename,0,9) as date, count(*) as nbre, sum(filesize) as size from signatures group by substr(filename,0,9)' >> $FLAGFILE