#!/bin/bash
# 2017-10-13 -- Adrien

myDay=`date +%A`
myDate=$(date +%Y-%m-%d)
mySMTP="smtp.gmail.com:587"
mySMTPuser="ptref02.pixtrakk"
mySMTPpass="wxcvbn?."
#myLog="/home/pix/scripts/backup.log"
myDNS="pixtrakk.com"
myTo="monitoring@pixtrakk.com"

echo "==BEGIN " `date` #> $myLog

pixMysqlDumpPath="/home/pix/dumpmysql"
pixDateDay=`date +%A`
pixBackupPath="/mnt/pwstor02/dumpmysql"

cd /var/www/pix/current

#tools/file_processor/bin/file_processor stop
#tools/media_processor/bin/media_processor stop

echo "--DEBUT mysqldump comptes utilisateurs " `date`
mysqldump -peisha5eo pix_production authorizations search_provider_group_names search_provider_groups settings title_provider_group_names title_provider_groups titles users > $pixMysqlDumpPath/$pixDateDay.backup_users.sql
echo "--FIN mysqldump comptes utilisateurs " `date`
echo
echo "--DEBUT mysqldump database pix_production " `date` #>> $myLog
mysqldump -peisha5eo pix_production > $pixMysqlDumpPath/$pixDateDay.pix_production.sql
echo "--FIN mysqldump database pix_production " `date` #>> $myLog
echo

echo "--DEBUT Image.final_delete_image" `date`
script/rails runner -e production 'Image.final_delete_image' >> log/final_delete_image.log 2>&1
echo "--FIN Image.final_delete_image" `date`
echo
echo "--DEBUT Provider.final_delete_provider" `date`
script/rails runner -e production 'Provider.final_delete_provider' >> log/Provider.final_delete_provider.log 2>&1
echo "--FIN Provider.final_delete_provider" `date`
echo
echo "--DEBUT delete_lb_images.rb" `date`
tools/delete_lb_images.rb >> /var/log/pixways/delete_lb_images.log 2>&1
echo "--FIN delete_lb_images.rb" `date`
echo
echo "--DEBUT delete_provider.rb" `date`
tools/delete_provider.rb >> /var/log/pixways/delete_provider.log 2>&1
echo "--FIN delete_provider.rb" `date`
echo


echo "--DEBUT Provider.delete_old_images " `date`
script/rails runner -e production 'Provider.delete_old_images'
echo "--FIN Provider.delete_old_images " `date`
echo

echo "--DEBUT Provider.delete_toomany_images " `date`
script/rails runner -e production 'Provider.delete_toomany_images'
echo "--FIN Provider.delete_toomany_images " `date`
echo


case $1 in
#1
image_core )

echo "--DEBUT index image_core " `date`
/usr/bin/indexer --config /var/www/pix/current/config/production.sphinx.conf --rotate image_core
echo "--FIN index image_core " `date`
;;

##2
all_core )

echo "--DEBUT index image_core " `date`
/usr/bin/indexer --config /var/www/pix/current/config/production.sphinx.conf --rotate image_core
echo "--FIN index image_core " `date`

echo "--DEBUT index statistic_core " `date`
/usr/bin/indexer --config /var/www/pix/current/config/production.sphinx.conf --rotate statistic_core
echo "--FIN index statistic_core " `date`
;;

###*
*)    echo Option incorrecte
esac

## only on one ptref, default ptref01, deactivated on ptref02
#echo "--DEBUT choix-images-pkk-photographes " `date`
#ruby /var/www/pix/shared/tools/choix-images-pkk-photographes2.rb >> /var/log/pixways/choix-images-pkk-photographes.log
#echo "--FIN choix-images-pkk-photographes " `date`
#echo

#echo "--DEBUT creat_pk_images_collectifs " `date`
#script/rails runner -e production 'SearchImageField.envoi_field_searches'
#/var/www/pix/shared/tools/creat_pk_images_collectifs2.sh >> /var/log/pixways/creat_pk_images_collectifs.log
#echo "--FIN creat_pk_images_collectifs " `date`
#echo

#echo "--DEBUT choix-images-pkk-agences " `date`
#script/rails runner -e production 'ProviderForSearchStat.envoi_user_searches'
#ruby /var/www/pix/shared/tools/choix-images-pkk-agences2.rb >> /var/log/pixways/choix-images-pkk-agences.log
#echo "--FIN choix-images-pkk-agences " `date`
#echo
##

echo "--DEBUT Sessions table purge " `date`
mysql -e 'delete from sessions where updated_at < DATE_SUB(NOW(), INTERVAL 1 WEEK);'
echo "--DEBUT Sessions table purge " `date`

#echo "--DEBUT ..." `date`

#echo "--FIN ..." `date`
#echo

#tools/media_processor/bin/media_processor start
#tools/file_processor/bin/file_processor start


date
gzip -v --force $pixMysqlDumpPath/$pixDateDay.pix_production.sql
date

rsync -avh --delete /home/pix/dumpmysql/ $pixBackupPath #>> $myLog
echo

echo "==DONE " `date`