#! /bin/bash

source "$(dirname "${BASH_SOURCE[0]}")"/../use-env-vars.sh

echo -e "\e[1m\e[32m\nCreate database \e[33m${MYSQL_DATABASE} \e[1m\e[32m?\n\e[30mNeed system package mysql-client (sudo apt install mysql-client)\e[0m"
IFS= read -n1 -srp "Press ENTER to continue or SPACE to skip..." k <&1
if [[ $k = "" ]] ; then
  echo -e "\e[1m\e[32m\nCommand running...\n\e[0m"
  mysql --user="${MYSQL_USER}" --password="${MYSQL_PASSWORD}" --host="${MYSQL_HOSTNAME}" -e "
  CREATE DATABASE IF NOT EXISTS \`${MYSQL_DATABASE}\` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  GRANT ALL PRIVILEGES ON \`${MYSQL_DATABASE}\`.* TO \`${MYSQL_USER}\`@\`localhost\`;
  FLUSH PRIVILEGES;
  "
  echo -e "\e[1m\e[32m\nDatabase ${MYSQL_DATABASE} created !\n\e[0m"
else
  echo -e "\e[1m\e[31mSkipped...\n\e[0m"
fi