devops/Sync/sync.sh

#!/bin/bash
# Update a testing env with the production data
echo "Start update : $(date)"

host=$(hostname)
if [[ $host =~ test-v?[0-9]* ]]
then
  echo "Current testing env : $host"
else
  echo "Invalid host : $host ; this script is designed to run on testing env only"
  exit 1
fi

# source .bashrc to LOAD NVM Environment
export NVM_DIR="$HOME/.nvm"
[ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh"  # This loads nvm
[ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion"  # This loads nvm bash_completion

echo "-------------"
echo "Start : $(date)"

echo "Synchro DB..."
ssh exploitation@prod-front mysqldump --single-transaction -u root --password=mysql2iopenservice369566 --add-drop-database --databases openassos | mysql -h localhost -P 3306 -u root --password=mysql2iopenservice369566 -D openassos
ssh exploitation@prod-front mysqldump --single-transaction -u root --password=mysql2iopenservice369566 --add-drop-database --databases typo3 | mysql -h localhost -P 3306 -u root --password=mysql2iopenservice369566 -D typo3
ssh exploitation@prod-back mysqldump --single-transaction -u root --password=mysql2iopenservice369566 --add-drop-database --databases adminassos | mysql -h localhost -P 3306 -u root --password=mysql2iopenservice369566 -D adminassos
ssh exploitation@prod-back mysqldump --single-transaction -u root --password=mysql2iopenservice369566 --add-drop-database --databases crm | mysql -h localhost -P 3306 -u root --password=mysql2iopenservice369566 -D crm
ssh exploitation@prod-back mysqldump --single-transaction -u root --password=mysql2iopenservice369566 --add-drop-database --databases opentalent | mysql -h localhost -P 3306 -u root --password=mysql2iopenservice369566 -D opentalent

mysql -u root -pmysql2iopenservice369566 -D opentalent -e "show tables" -s | egrep "^view_" | xargs -I "@@" mysql -u root -pmysql2iopenservice369566 -D opentalent -e "DROP TABLE @@"

echo "Synchro Elasticsearch..."
sudo /etc/init.d/elasticsearch stop
sudo rsync -a --delete root@prod-back:/var/lib/elasticsearch/elasticsearch/nodes/0/indices/ /var/lib/elasticsearch/elasticsearch/nodes/0/indices/
sudo /etc/init.d/elasticsearch start

echo "Synchro Files..."
sudo rsync -a --delete root@prod-back:/var/www/opentalent/fileadmin/user_upload/ /var/www/opentalent/fileadmin/user_upload/
sudo rsync -a --delete root@prod-back:/var/www/opentalent-platform/web/files/ /var/www/opentalent-platform/web/files/

echo "Synchro Typo3 Files..."
sudo rsync -a --delete root@prod-front:/var/www/typo3/public/fileadmin/user_upload/ /var/www/typo3/public/fileadmin/user_upload/
sudo rsync -a --delete root@prod-front:/var/www/typo3/public/fileadmin/form_definitions/ /var/www/typo3/public/fileadmin/form_definitions/
sudo rsync -a --delete root@prod-front:/var/www/typo3/config/sites /var/www/typo3/config/sites

echo "Mise à jour de admin ..."
cd /var/opentalent/git/opentalent-admin-2.0/ || exit
git pull
nvm exec 4.2.6 npm install
nvm exec 4.2.6 bower install
# shellcheck disable=SC2209
NODE_ENV=test nvm exec 4.2.6 gulp build
cd /var/www/opentalent-admin/test || exit
rm -rf ckeditorConfig
ln -fs /var/opentalent/git/opentalent-admin-2.0/src/ckeditorConfig .

echo "Mise à jour de api ..."
cd /var/www/opentalent-platform || exit
git pull
symfony php app/console d:s:u --force
symfony composer install
symfony php app/console c:c --env test

echo "Mise à jour de app..."
cd /var/opentalent/git/app/ || exit
git pull
nvm exec 14.20.1 yarn install
nvm exec 14.20.1 yarn build

echo "Mise à jour de ap2i..."
cd /var/opentalent/git/ap2i/ || exit
git pull
composer install
bin/console c:c

echo "Mise à jour 5.9 ..."
cd /var/www/opentalent/opentalent || exit
git pull

echo "Mise à jour de Typo3"
cd /var/opentalent/git/ot_typo3/ || exit
git pull
#cd /var/www/typo3 || exit
#php7.4 composer.phar install

echo "Post update ..."
sudo /etc/init.d/php7.0-fpm restart
sudo systemctl start supervisor.service


echo "End : $(date)"
echo "-------------"