#!/bin/bash

# Quick MySQL Setup for BondaCare
# This is a simplified version for quick setup

echo "🚀 BondaCare MySQL Quick Setup"
echo "================================"
echo ""

# Step 1: Check MySQL
echo "Checking MySQL..."
if ! command -v mysql &> /dev/null; then
    echo "❌ MySQL not found. Please install MySQL first:"
    echo "   macOS: brew install mysql && brew services start mysql"
    echo "   Ubuntu: sudo apt-get install mysql-server"
    exit 1
fi

echo "✅ MySQL found!"
echo ""

# Step 2: Prompt for password
echo "Please enter your MySQL root password:"
read -sp "Password: " MYSQL_PASSWORD
echo ""
echo ""

# Step 3: Create database
echo "Creating database 'bondacare'..."
mysql -u root -p"$MYSQL_PASSWORD" -e "CREATE DATABASE IF NOT EXISTS bondacare CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;" 2>/dev/null

if [ $? -eq 0 ]; then
    echo "✅ Database created!"
else
    echo "❌ Failed to create database. Please check your password."
    exit 1
fi

# Step 4: Update .env (already done, but update password)
echo ""
echo "Updating .env file..."
if [ -n "$MYSQL_PASSWORD" ]; then
    # Update password in .env
    if [[ "$OSTYPE" == "darwin"* ]]; then
        # macOS
        sed -i '' "s/^DB_PASSWORD=.*/DB_PASSWORD=$MYSQL_PASSWORD/" .env
    else
        # Linux
        sed -i "s/^DB_PASSWORD=.*/DB_PASSWORD=$MYSQL_PASSWORD/" .env
    fi
fi
echo "✅ Configuration updated!"

# Step 5: Clear cache
echo ""
echo "Clearing cache..."
php artisan config:clear > /dev/null 2>&1
php artisan cache:clear > /dev/null 2>&1
echo "✅ Cache cleared!"

# Step 6: Run migrations
echo ""
echo "Running migrations (this may take a minute)..."
php artisan migrate:fresh --force

if [ $? -eq 0 ]; then
    echo "✅ Migrations completed!"
else
    echo "❌ Migration failed. Please check the error above."
    exit 1
fi

# Step 7: Done!
echo ""
echo "================================"
echo "✨ Setup Complete! ✨"
echo "================================"
echo ""
echo "Your BondaCare application is now using MySQL!"
echo ""
echo "Database Details:"
echo "  📦 Database: bondacare"
echo "  🔗 Host: 127.0.0.1:3306"
echo "  👤 User: root"
echo ""
echo "Next steps:"
echo "  1. Start your app: php artisan serve"
echo "  2. Visit: http://localhost:8000"
echo ""
echo "Happy coding! 🎉"
echo ""