MYSQL_IMAGE_TAG="5.6.41"
DATABASE_NAME="sample"
MYSQL_HOST_PORT="3306"
USER="user"
PASSWORD="password"
HOST="127.0.0.1"

.PHONY: run_mysql
run_mysql:
    docker run -it \
    -e MYSQL_ROOT_PASSWORD=password \
    -e MYSQL_DATABASE=${DATABASE_NAME} \
    -e MYSQL_USER=${USER} \
    -e MYSQL_PASSWORD=${PASSWORD} \
    -p ${MYSQL_HOST_PORT}:3306 \
    -d \
    mysql:${MYSQL_IMAGE_TAG}

.PHONY: kill_mysql
kill_mysql:
    docker kill $(shell docker ps  --filter "ancestor=mysql:${MYSQL_IMAGE_TAG}" --quiet)

.PHONY: login_to_mysql
login_to_mysql:
    mysql --host=${HOST} \
    --user=${USER} \
    --password=${PASSWORD} \
    --port=${MYSQL_HOST_PORT} \
    --database=${DATABASE_NAME}

.PHONY: apply_sql_file
apply_sql_file:
    mysql --host=${HOST} \
    --user=${USER} \
    --password=${PASSWORD} \
    --port=${MYSQL_HOST_PORT} \
    --database=${DATABASE_NAME} < ${FILE_LOCATION}