#!/bin/bash
# 2026-01-12 -- Adrien

echo -e "\n************************************  `date`  ************************************\n"

echo "==BEGIN " `date`
echo

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

cd /var/www/pix/current

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

## MYSQLDUMPS
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_api_production " `date`
mysqldump -peisha5eo pix_api_production > $pixMysqlDumpPath/$pixDateDay.pix_api_production.sql
echo "--FIN mysqldump database pix_api_production " `date`
echo
echo "--DEBUT mysqldump database pix_production " `date`
mysqldump -peisha5eo pix_production > $pixMysqlDumpPath/$pixDateDay.pix_production.sql
echo "--FIN mysqldump database pix_production " `date`
echo

## Change order REINDEX and DELETE


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`
;;

#1
statistic_core )

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`
;;

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

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
echo

## Change order REINDEX and DELETE

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

## FIN change order

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

echo "--DEBUT SearchStat.purge_adm " `date`
script/rails runner -e production 'SearchStat.purge_adm'
echo "--FIN SearchStat.purge_adm " `date`
echo

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

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

## COMPRESSION
#echo "--DEBUT gzip dump database " `date`
#2024-12-20 -- Adrien
##gzip -v --force $pixMysqlDumpPath/$pixDateDay.*.sql
#echo "--FIN gzip dump database " `date`
echo

## EXTERNAL BACKUP
#echo "--DEBUT rsync to pwstor01 " `date`
#rsync -avh $pixMysqlDumpPath/$pixDateDay.* pixtrakk@pwstor01:/var/local/pixadmin1/mysqldump/
#rsync -avh --delete /home/pix/capistrano/ pixtrakk@pwstor01:/var/local/pixadmin1/capistrano/
#echo "--FIN rsync to pwstor01 " `date`
#echo

##2024-12-20 -- Adrien
echo "--DEBUT scp-rsync to pwstor02 " `date`
echo "--DEBUT scp to pwstor02 " `date`
scp -p $pixMysqlDumpPath/$pixDateDay.* support@pwstor02:/var/local/pixadmin1/mysqldump/
echo "--FIN scp to pwstor02 " `date`
echo "--DEBUT rsync to pwstor02 " `date`
rsync -avh --delete /home/pix/capistrano/ support@pwstor02:/var/local/pixadmin1/capistrano/
echo "--FIN rsync to pwstor02 " `date`
echo "--FIN scp-rsync to pwstor02 " `date`
echo

#echo "--DEBUT rsync to ns3132694 " `date`
## SSH key problem, to check
#rsync -avh --delete /home/pix/capistrano/ pix@ns3132694.ip-51-75-131.eu:/var/local/pixadmin/capistrano/
#scp -p $pixMysqlDumpPath/$pixDateDay.* pix@ns3132694.ip-51-75-131.eu:/var/local/pixadmin/mysqldump/
#echo "--FIN rsync to ns3132694 " `date`
#echo

echo "---BONUS " `date`
echo
echo "--DEBUT BONUS 1 Provider.delete_old_images IconSport" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("IS")'
echo "--FIN Provider.delete_old_images " `date`
echo "--DEBUT BONUS 2 Provider.delete_old_images IconSport" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("IS")'
echo "--FIN Provider.delete_old_images " `date`
echo "--DEBUT BONUS 3 Provider.delete_old_images IconSport" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("IS")'
echo "--FIN Provider.delete_old_images " `date`
echo "--DEBUT BONUS 4 Provider.delete_old_images IconSport" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("IS")'
echo "--FIN Provider.delete_old_images " `date`
echo "--DEBUT BONUS 5 Provider.delete_old_images IconSport" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("IS")'
echo "--FIN Provider.delete_old_images " `date`
echo


echo "--DEBUT BONUS 1 Provider.delete_old_images Sipa" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("SIPA")'
echo "--FIN Provider.delete_old_images Sipa" `date`
echo "--DEBUT BONUS 2 Provider.delete_old_images Sipa" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("SIPA")'
echo "--FIN Provider.delete_old_images Sipa" `date`
echo "--DEBUT BONUS 3 Provider.delete_old_images Sipa" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("SIPA")'
echo "--FIN Provider.delete_old_images Sipa" `date`
echo "--DEBUT BONUS 4 Provider.delete_old_images Sipa" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("SIPA")'
echo "--FIN Provider.delete_old_images Sipa" `date`
echo "--DEBUT BONUS 5 Provider.delete_old_images Sipa" `date`
cd /var/www/pix/current
script/rails runner -e production 'Provider.delete_old_images("SIPA")'
echo "--FIN Provider.delete_old_images Sipa" `date`
echo


##2024-12-20 -- Adrien
#echo "--DEBUT rsync to san12 " `date`
#rsync -avh --delete /home/pix/capistrano/ adrien@94.23.128.12:/tank/pixadmin/capistrano/
#scp -p $pixMysqlDumpPath/$pixDateDay.* adrien@94.23.128.12:/tank/pixadmin/mysqldump/
#echo "--FIN rsync to san12 " `date`
echo

echo "==DONE " `date`