#!/bin/bash
PASSWD=$(date | md5sum)
PASSWD=$(echo -n "${PASSWD//[[:space:]]/}" | sed -e 's/-//g')
if [ "$#" -lt 1 ]; then
    echo "$0 DATABASE_NAME [DBUSER] [DBPASS]"
    exit 1
fi
if [ "$#" -lt 2 ]; then
    DBUSR=${1}_user
else
    DBUSR=${2}
fi
if [ "$#" -eq 3 ]; then
    PASSWD=${3}
fi

MYSQLCMD=$(cat <<EOC
create database if not exists ${1};
grant all on ${1}.* to ${DBUSR}@localhost identified by 'ftf';
grant all on ${1}.* to ${DBUSR}@'%' identified by 'ftf';
FLUSH PRIVILEGES;
EOC
)

echo "DATABASE: ${1}"
echo "USER: $DBUSR"
echo "PASSWORD: $PASSWD"

echo $MYSQLCMD

MYSQL='exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'

docker run -it --link mysql:mysql --rm hypriot/rpi-mysql sh -c "$MYSQL -e '$MYSQLCMD'"