#!/bin/bash

# Run the MySQL container, with a database named 'users' and credentials
# for a users-service user which can access it.
echo "Starting Database..."
docker run --name db -d \
  -e MYSQL_ROOT_PASSWORD=123 \
  -e MYSQL_DATABASE=users \
  -e MYSQL_USER=users_service \
  -e MYSQL_PASSWORD=123 \
  -p 3306:3306 \
  mysql:latest

# Wait for the database service to start
echo "Waiting for DB to start up..."
docker exec db mysqladmin --silen --wait=30 \
  -u users_service -p 123 ping || exit

# Run the setup script.
echo "Setting up initial data..."
docker exec -i db mysql -u users -p 123 users < setup.sql