devops/Sync/sync.sh

#!/bin/bash

# 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-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 "Mise à jour de admin ..."
cd /var/opentalent/git/opentalent-admin-2.0/
git pull
nvm exec 4.2.6 npm install
nvm exec 4.2.6 bower install
NODE_ENV=test nvm exec 4.2.6 gulp build

echo "Mise à jour de api ..."
cd /var/www/opentalent-platform
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/
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/
git pull
composer install
bin/console c:c

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

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


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