#!/bin/bash

# MySQL Setup Script for DaProductApp
echo "Setting up MySQL database for DaProductApp..."

# Check if MySQL is running
if ! pgrep -x "mysqld" > /dev/null; then
    echo "MySQL is not running. Please start MySQL service first."
    echo "sudo systemctl start mysql"
    exit 1
fi

# Create databases
echo "Creating databases..."
mysql -u root -pdataaegis123 -e "CREATE DATABASE IF NOT EXISTS lic_project CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
mysql -u root -pdataaegis123 -e "CREATE DATABASE IF NOT EXISTS lic_project_testingteam CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"

# Set proper MySQL modes
echo "Configuring MySQL settings..."
mysql -u root -pdataaegis123 -e "SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO';"

# Verify databases
echo "Verifying databases..."
mysql -u root -pdataaegis123 -e "SHOW DATABASES LIKE 'lic_project%';"

echo "Database setup complete!"
echo ""
echo "Next steps:"
echo "1. Run: mix deps.get"
echo "2. Run: mix ecto.create"
echo "3. Run: mix ecto.migrate"
echo "4. Run: mix phx.server"