#!/bin/bash

mysql_apim_password=root
mysql_apim_host=localhost
mysql_apim_username=root


if [ ! "$(docker ps -q -f name=mysql-5.7)" ]; then
    echo -e "---> Starting MySQL docker container..."
    container_id=$(docker run -d --name mysql-5.7 -p 3306:3306 -e MYSQL_ROOT_HOST=% -e MYSQL_ROOT_PASSWORD=$mysql_apim_password mysql:5.7.19)
    echo $container_id

    docker ps -a
    echo -e "---> Waiting for MySQL to start on 3306..."
    while ! nc -z $mysql_apim_host 3306; do
        sleep 1
        printf "."
    done
    echo ""
    echo -e "---> MySQL Started."
else
    echo -e "---> MySQL is already running..."
fi

#sleep 10

echo -e "---> Creating databases..."
docker exec -it mysql-5.7 mysql -h$mysql_apim_host -u$mysql_apim_username -p$mysql_apim_password -e "DROP DATABASE IF EXISTS "am_db"; DROP DATABASE IF EXISTS "um_db"; DROP DATABASE IF EXISTS "reg_db"; CREATE DATABASE "am_db"; CREATE DATABASE "um_db"; CREATE DATABASE "reg_db";"

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)