#!/bin/sh
#
clear
TARFILE=sources.tar.gz
DUMP=corpusdelaparole.sql     
APUSER=apache                                                                                                                             
APGROUP=apache                                                                                                                             
# Variables de configuration à modifier selon vos besoins
#########################################################                                                                                                                  
ROOT=/var/www/corpusdelaparole/drupal
DBNAME=corpusdelaparole
DBUSER=corpus
DBPASS=aeTh3ohC
DBSERV=127.0.0.1
PHP=/opt/remi/php56/root/usr/bin/php
#########################################################
splashTitle() {
cat <<"EOT"
                __ _   _____                         _    _____      _                                       
               / _(_) |  __ \                       | |  / ____|    | |                                      
          __ _| |_ _  | |  | |_ __ _   _ _ __   __ _| | | (___   ___| |_ _   _ _ __                          
         / _` |  _| | | |  | | '__| | | | '_ \ / _` | |  \___ \ / _ \ __| | | | '_ \                         
        | (_| | | | | | |__| | |  | |_| | |_) | (_| | |  ____) |  __/ |_| |_| | |_) |                        
         \__, |_| |_| |_____/|_|   \__,_| .__/ \__,_|_| |_____/ \___|\__|\__,_| .__/                         
          __/ |                         | |                                   | |                            
         |___/                          |_|                                   |_|                            
                                                                                                             
EOT
}

splashTitle
echo "--------------------------- PARAMETRES D'INSTALLATION -------------------------------------------------------"
echo "-------------------------------------------------------------------------------------------------------------"
echo "Dossier d'installation    = $ROOT"
echo "chemin php                = $PHP"
echo "Nom de la base de données = $DBNAME"
echo "User Mysql                = $DBUSER"
echo "Mot de passe Mysql        = $DBPASS"
echo "Serveur Mysql             = $DBSERV"
echo "-------------------------------------------------------------------------------------------------------------"
echo "-------------------------------------------------------------------------------------------------------------"
read -r -p "Etes-vous sur(e) de vouloir installer avec les paramètres ci dessus ? [Oui/n]" response
 response=${response,,} # tolower
 if [[ $response =~ ^(oui|o| ) ]]; then 	
	#
	echo ""
	echo ""
	echo "-------------------- Installation du site corpus de la parole -----------------------------------------------"
	echo "-------------------------------------------------------------------------------------------------------------"
	#                                                                                                                                                     
	# Errors are fatal
	#                                                                                                                                                     
	set -e

	echo ""
	echo "Copie des sources et du dump SQL dans $ROOT"
	echo "-------------------------------------------"
	echo "cp $TARFILE $ROOT/$TARFILE"
	cp $TARFILE $ROOT/$TARFILE
	echo "cp $DUMP $ROOT/$TARFILE"
	cp $DUMP $ROOT/$DUMP
	echo ">> Copie effectuée avec succès"
	echo ""

	cd $ROOT
	echo "Extraction des sources dans $ROOT" 
	echo "---------------------------------"
	echo "tar -xf $TARFILE"
	tar -xf $TARFILE
	echo ">> Extraction effectuée avec succès"
	echo ""

	echo "Restauration du dump de bdd dans la base $DBNAME"
	echo "------------------------------------------------"
	echo "mysql -u $DBUSER -p$DBPASS $DBNAME < $DUMP"
	mysql -h $DBSERV -u $DBUSER -p$DBPASS $DBNAME < $DUMP
	echo ""
	echo "Vidage des tables accesslog,search_dataset,search_index,search_total,sessions,watchdog"
	echo "--------------------------------------------------------------------------------------"
	mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE accesslog"
	mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE search_dataset"
	mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE search_index"
	mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE search_total"
	mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE sessions"
	mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE watchdog"
	echo ">> Restauration effectuée avec succès"
	echo ""
	echo "Suppression de l'archive tar et du dump"
	echo "-----------------------------------------------------"
	rm $TARFILE
	rm $DUMP
	echo ">> Suppression effectuée avec succès"
	echo ""
	echo "Attribution des droits apache (httpd) sur les sources"
	echo "-----------------------------------------------------"
	echo "chown –R $APUSER:$APGROUP $ROOT/*"
	chown $APUSER:$APGROUP -R $ROOT/*
	echo ">> Droits apache attribués avec succès"
	echo ""
        echo "Mise à jour du fichier de configuation de drupal"
        echo "-----------------------------------------------------"
        echo "sed -E \"... database => $DBNAME \" sites/default/settings.php"
        sed -e '' -E "s/^([[:space:]]+[\'\"]database[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBNAME\2\3/" sites/default/settings.php
        echo "sed -E \"... username => $DBUSER \" sites/default/settings.php"
        sed -e '' -E "s/^([[:space:]]+[\'\"]username[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBUSER\2\3/" sites/default/settings.php
        echo "sed -E \"... password => $DBPASS \" sites/default/settings.php"
        sed -e '' -E "s/^([[:space:]]+[\'\"]password[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBPASS\2\3/" sites/default/settings.php
        echo "sed -E \"... host => $DBSERV \" sites/default/settings.php"
        sed -e '' -E "s/^([[:space:]]+[\'\"]host[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBSERV\2\3/" sites/default/settings.php

	echo "Vidage des caches Drupal"
	echo "-----------------------------------------------------"
	export DRUSH_OPTIONS="-q"
	sudo -u $APUSER DRUSH_PHP="$PHP" /usr/local/bin/drush cc all
	set -e

	echo ""
	echo ""
	echo ">>>>>>>>>>>>>> INSTALLATION EFFECTUEE AVEC SUCCESS"
	echo ""
	echo ""
 fi