#!/bin/bash
########################################################################################
#	Este programa tem a funcao de auxiliar no backup de arquivos e banco antes do up.
#	Rafael Carreiro
#	rafael.oliveira@arcasolutions.com
#	https://netuno.arcasolutions.com/rafael.oliveira/v11-tools
#	backup_antes_upgrade.sh
########################################################################################
#
# Modo de usar
#
# Com o usuario do cliente, na pasta raiz do projeto, execute a seguinte linha de comando:
# wget https://s3-sa-east-1.amazonaws.com/upgradev11/scripts/backup_antes_upgrade.sh ; chmod +x backup_antes_upgrade.sh ; ./backup_antes_upgrade.sh

main() {
	menu_inicial
}

backup(){
	#Definindo caminhos
	cd $HOME
	mkdir bkp_edir
	EDIR_ROOT=$HOME/public_html
	EDIR_BACKUP=$HOME/bkp_edir

	cd $EDIR_BACKUP
	IP_DB_HOST=`grep -E "define\(\"_DIRECTORYDB_HOST\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
		echo -e "IP_DB_HOST\t\t:$IP_DB_HOST"
	DB_USER=`grep -E "define\(\"_DIRECTORYDB_USER\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
		echo -e "DB_USER\t\t\t:$DB_USER"
	DB_PASS=`grep -E "define\(\"_DIRECTORYDB_PASS\"\," $EDIR_ROOT/conf/config.inc.php  | cut -f4 -d '"'`
		echo -e "DB_PASS\t\t\t:$DB_PASS"
	DB_MAIN_NAME=`grep -E "define\(\"_DIRECTORYDB_NAME\"\," $EDIR_ROOT/conf/config.inc.php | cut -f4 -d '"'`
		echo -e "DB_MAIN_NAME\t\t:$DB_MAIN_NAME"
	PROJDOMAIN1=`grep -E "domainInfo\[" $EDIR_ROOT/custom/domain/domain.inc.php | cut -f2 -d '"'`
		echo -e "PROJDOMAIN1\t\t:$PROJDOMAIN1"
	DB_DOMAIN1=`mysql -u$DB_USER -p$DB_PASS -e "use $DB_MAIN_NAME ; select database_name from Domain;" | grep "domain"`
		echo -e "DB_DOMAIN1\t\t:$DB_DOMAIN1"

	echo -e "\n[+]Exportando bancos main e domain1"
	mysqldump -C -u$DB_USER -p$DB_PASS $DB_MAIN_NAME > bkp_main.sql
    mysqldump -C -u$DB_USER -p$DB_PASS $DB_DOMAIN1 > bkp_domain1.sql

    echo -e "\n[+]Compactando public_html"
    tar zcf bkp_public_html.tar.gz ../public_html

    echo -e "\n[!]Concluido!\nOs arquivos se encontram em $EDIR_BACKUP\n"
    ls -lah $EDIR_BACKUP

}

menu_inicial() {
	clear
	echo -e "\n\tUTILITARIO V11\n"
	echo -e "Exclusivo para servidores de testes"
	echo -e "[1] - Backup"					
	echo -e "[0] - Sair"

	read op_menu_inicial
	if [[ "$op_menu_inicial" == 1 ]]; then
		backup
	fi
}

main