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