#!/bin/bash
clear
echo ""
echo "Install ASTPP Database"
echo "****************** WARNING WARNING  WARNING *****************"
echo " "
echo "      	   Please use MySQL Root Credencial          	  "     
echo "     Appropriate database should exist in database.        "     
echo ""
echo "*************************************************************"
echo ""

echo "Enter MySQL Hostname : "
read astpp_hostname

echo "Enter MySQL root UserName : "
read astpp_username

echo "Enter MySQL Password : "
read astpp_password

echo "Enter ASTPP Database Name : "
read astpp_dbname

mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname < astpp-1.7.1.sql
mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname < astpp-upgrade-1.7.2.sql

echo "";
read -n 1 -p "Press 0 For Freeswitch & Press 1 For Asterisk [Default:0]: ";
echo 
if [ "$REPLY" = "1" ]; then
      
    mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname -e "
    update system set value=0 where name='softswitch';
    update system set value='0' where name='users_dids_rt';
    update system set value='0' where name='users_dids_freeswitch';";

#   AsteriskCDRDB installation  
    REPLY="y";
    read -n 1 -p "Do You Want To Install AsteriskCDR? (y/n) [Default:y] : ";
    if [ "$REPLY" = "n" ]; then
	echo "";
    else
	echo "";
	REPLY="y";
	read -n 1 -p "Do You Want To Use Same Database Credencial As ASTPP ? (y/n) [Default:y] : ";
	echo 
	echo "";
	if [ "$REPLY" = "n" ]; then
	    
	    echo "Enter Asterisk CDR Hostname : "
	    read asteriskcdrdb_hostname

	    echo "Enter Asterisk CDR UserName : "
	    read asteriskcdrdb_username

	    echo "Enter Asterisk CDR Password : "
	    read asteriskcdrdb_password
	    
	    echo "Enter Asterisk CDR Database Name : "
	    read asteriskcdrdb_dbname

	else
	    echo "Enter Asterisk CDR Database Name : "
	    read asteriskcdrdb_dbname
	    
	    asteriskcdrdb_hostname=$astpp_hostname;
	    asteriskcdrdb_username=$astpp_username;
	    asteriskcdrdb_password=$astpp_password;
	fi
	mysql --user=$asteriskcdrdb_username --password=$asteriskcdrdb_password --host=$asteriskcdrdb_hostname $asteriskcdrdb_dbname < asteriskcdrdb-current.sql
	
	mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname -e "
	update system set value='$asteriskcdrdb_hostname' where name='cdr_dbhost';update system set value='$asteriskcdrdb_dbname' where name='cdr_dbname'; 
	update system set value='$asteriskcdrdb_username' where name='cdr_dbuser';update system set value='$asteriskcdrdb_password' where name='cdr_dbpass';";
    fi
#   Asterisk Realtime database installation  
  echo "";
  REPLY="y";
  read -n 1 -p "Do You Want To Install Realtime Asterisk Database? (y/n) [Default:y] : ";
  echo 
  
    if [ "$REPLY" = "n" ]; then
	echo "";
    else
# 	REPLY="y";
	read -n 1 -p "Do You Want To Use Same Database Credencial As ASTPP ? (y/n) [Default:y] : ";
	echo 
	if [ "$REPLY" = "n" ]; then
	  
	    echo "Enter Asterisk Realtime Hostname : "
	    read realtime_hostname

	    echo "Enter Asterisk Realtime UserName : "
	    read realtime_username

	    echo "Enter Asterisk Realtime Password : "
	    read realtime_password
	    
	    echo "Enter Asterisk Realtime Database Name : "
	    read realtime_dbname

	else
	    echo "Enter Asterisk Realtime Database Name : "
	    read realtime_dbname
	    
	    realtime_hostname=$astpp_hostname;
	    realtime_username=$astpp_username;
	    realtime_password=$astpp_password;
	fi
	mysql --user=$realtime_username --password=$realtime_password --host=$realtime_hostname $realtime_dbname < asterisk-realtime-current.sql	
	mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname -e "update system set value='1' where name='users_dids_rt';
	update system set value='$realtime_hostname' where name='rt_host';
	update system set value='$realtime_dbname' where name='rt_db';update system set value='$realtime_username' where name='rt_user';
	update system set value='$realtime_password' where name='rt_pass';";
    fi    
else  
    mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname -e "update system set value=1 where name='softswitch';";
#   Freeswitch CDR installation  
    echo "";
#     REPLY="y";  
    read -n 1 -p "Do You Want To Install FreeswitchCDR? (y/n) [Default:y] : ";
    echo 
    if [ "$REPLY" = "n" ]; then
	echo "";
    else
# 	REPLY="y";
	echo "";  
	read -n 1 -p "Do You Want To Use Same Database Credencial As ASTPP ? (y/n) [Default:y] : ";
	echo 
	echo "";
	if [ "$REPLY" = "n" ]; then
	  
	    echo "Enter Freeswitch CDR Hostname : "
	    read fscdrdb_hostname

	    echo "Enter Freeswitch CDR UserName : "
	    read fscdrdb_username

	    echo "Enter Freeswitch CDR Password : "
	    read fscdrdb_password
	    
	    echo "Enter Freeswitch CDR Database Name : "
	    read fscdrdb_dbname

	else
	    echo "Enter Freeswitch CDR Database Name : "
	    read fscdrdb_dbname
	    
	    fscdrdb_hostname=$astpp_hostname;
	    fscdrdb_username=$astpp_username;
	    fscdrdb_password=$astpp_password;
	fi
	mysql --user=$fscdrdb_username --password=$fscdrdb_password --host=$fscdrdb_hostname $fscdrdb_dbname < freeswitchcdrdb-current.sql
	
	mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname -e "
	update system set value='$fscdrdb_hostname' where name='cdr_dbhost';update system set value='$fscdrdb_dbname' where name='cdr_dbname'; 
	update system set value='$fscdrdb_username' where name='cdr_dbuser';update system set value='$fscdrdb_password' where name='cdr_dbpass';";
    fi
#   Freeswitch database installation  
  echo "";
#   REPLY="y";
  read -n 1 -p "Do You Want To Install Freeswitch Database? (y/n) [Default:y] : ";
  echo   
    if [ "$REPLY" = "n" ]; then
	echo "";
    else
	echo "";
# 	REPLY="y";
	read -n 1 -p "Do You Want To Use Same Database Credencial As ASTPP ? (y/n) [Default:y] : ";
	echo 
	echo "";
	if [ "$REPLY" = "n" ]; then
	  
	    echo "Enter Freeswitch Hostname : "
	    read fs_hostname

	    echo "Enter Freeswitch UserName : "
	    read fs_username

	    echo "Enter Freeswitch Password : "
	    read fs_password
	    
	    echo "Enter Freeswitch Database Name : "
	    read fs_dbname

	else
	    echo "Enter Freeswitch Database Name : "
	    read fs_dbname
	    
	    fs_hostname=$astpp_hostname;
	    fs_username=$astpp_username;
	    fs_password=$astpp_password;
	fi
	mysql --user=$fs_username --password=$fs_password --host=$fs_hostname $fs_dbname < freeswitch-current.sql
	mysql --user=$astpp_username --password=$astpp_password --host=$astpp_hostname $astpp_dbname -e "update system set value='1' where name='users_dids_freeswitch';update system set value='$fs_hostname' where name='freeswitch_dbhost';update system set value='$fs_dbname' where name='freeswitch_dbname';update system set value='$fs_username' where name='freeswitch_dbuser';update system set value='$fs_password' where name='freeswitch_dbpass';";
    fi        
fi

echo "";
echo "-----------------------------";
echo "Database Installation Done";
echo "-----------------------------";
echo "";
# All done, exit ok
exit 0