#!/bin/bash

set -x
echo ">>>>>>> $0 $* <<<<<<<"

#mysql -u root -e "SHOW GRANTS FOR 'nextdom'@'localhost';"
mysql -u root -e "SHOW DATABASES;"

case "$1" in
  upgrade)

    # Test if Nextdom conf file parameters are equivalent to nextdom-mysql parameters and if not, adjust
    nextdom_secret=/var/lib/nextdom/config/common.config.php
    if [[ -f ${nextdom_secret} ]] ; then
      nextdom_host=$(grep "'host'" /var/lib/nextdom/config/common.config.php | awk -F "=>" '{print $2}' | awk -F "'" '{print $2}')
      nextdom_port=$(grep "'port'" /var/lib/nextdom/config/common.config.php | awk -F "=>" '{print $2}' | awk -F "'" '{print $2}')
      nextdom_dbname=$(grep "'dbname'" /var/lib/nextdom/config/common.config.php | awk -F "=>" '{print $2}' | awk -F "'" '{print $2}')
      nextdom_username=$(grep "'username'" /var/lib/nextdom/config/common.config.php | awk -F "=>" '{print $2}' | awk -F "'" '{print $2}')
      nextdom_password=$(grep "'password'" /var/lib/nextdom/config/common.config.php | awk -F "=>" '{print $2}' | awk -F "'" '{print $2}')
      #
      if [[ ${nextdom_host}     != "${MYSQL_HOSTNAME}" ]] ;       then sed -i s#^MYSQL_HOSTNAME=.*#MYSQL_HOSTNAME=\"${nextdom_host}\"#g /etc/nextdom/mysql/secret ; fi
      if [[ ${nextdom_port}     != "${MYSQL_PORT}" ]] ;           then sed -i s#^MYSQL_PORT=.*#MYSQL_PORT=\"${nextdom_port}\"#g /etc/nextdom/mysql/secret ; fi
      if [[ ${nextdom_dbname}   != "${MYSQL_NEXTDOM_DB}" ]] ;     then sed -i s#^MYSQL_NEXTDOM_DB=.*#MYSQL_NEXTDOM_DB=\"${nextdom_dbname}\"#g /etc/nextdom/mysql/secret ; fi
      if [[ ${nextdom_username} != "${MYSQL_NEXTDOM_USER}" ]] ;   then sed -i s#^MYSQL_NEXTDOM_USER=.*#MYSQL_NEXTDOM_USER=\"${nextdom_username}\"#g /etc/nextdom/mysql/secret ; fi
      if [[ ${nextdom_password} != "${MYSQL_NEXTDOM_PASSWD}" ]] ; then sed -i s#^MYSQL_NEXTDOM_PASSWD=.*#MYSQL_NEXTDOM_PASSWD=\"${nextdom_password}\"#g /etc/nextdom/mysql/secret ; fi
    fi

    cp -ax /etc/nextdom/mysql/secret /tmp/nextdom-secret
    chmod 600 /tmp/nextdom_secret

    # Test if nextdom DB user is present and if not recreate it
    if [[ ${nextdom_host} = 'localhost' ]] ; then
        isOK=$(mysql -u root -e "SELECT user, host, db, select_priv, insert_priv, grant_priv FROM mysql.db WHERE user='${nextdom_username}' AND host='localhost' AND db='${nextdom_dbname}';" |wc -l)
        #isOK=$(mysql -u root -e "SELECT user, host, db, select_priv, insert_priv, grant_priv FROM mysql.db WHERE user='nextdom' AND host='localhost' AND db='nextdom';" |wc -l)
        if [[ ${isOK} -eq 0 ]] ; then
            mysql -u root -e "DROP USER IF EXISTS '${nextdom_username}'@'localhost';"
            mysql -u root -e "CREATE USER '${nextdom_username}'@'localhost' IDENTIFIED BY '${nextdom_password}';"
            mysql -u root -e "GRANT ALL PRIVILEGES ON ${nextdom_dbname}.* TO '${nextdom_username}'@'localhost';"
            mysql -u root -e "SHOW GRANTS FOR '${nextdom_username}'@'localhost';"
        fi
        mysqldump -u root --all-databases >/tmp/nextdom_upgrade.sql
    fi
    ;;
esac