start-local-env.ps1

## SQL
# Create volumes
# Run MySQL container
function Start-MySQLContainer {
  docker volume create --name mysql8-data
  docker volume create --name mysql8-conf

  # Must specify --all to get stopped containers
  $ExistingId = docker container list --all --quiet --filter name=mysql
  if ($ExistingId) {
    docker container start mysql
  }
  else {
    docker container run --detach --name mysql `
      --hostname mysql `
      -p 3308:3306 `
      --env MYSQL_DATABASE=canopeum_db `
      --env MYSQL_ROOT_PASSWORD=Canopeum12345!@ `
      --env MYSQL_USER=canopeum_user `
      --env MYSQL_PASSWORD=CanopeumUser12345!@ `
      --volume mysql8-data:/var/lib/mysql `
      --volume mysql8-conf:/etc/mysql/conf.d mysql:8
  }
}

# Backend
# Update virtual environment / Install dependencies
# Run Django server
$commandsBackend = @'
  cd canopeum_backend
  uv sync --locked
  uv run manage.py runserver
'@

# Frontend
# Install dependencies
# Run React Vite server
$commandsFrontend = @'
cd canopeum_frontend
npm install
npm run dev
'@

# Initialize database
$commandsInitializeDatabase = @'
  cd canopeum_backend
  uv run manage.py initialize_database
  cd ..
'@

# Generate OpenAPI specs
$commandsGenerateOpenAPI = @'
  cd canopeum_frontend
  npm run generate-api-client
  cd ..
'@

function Show-Menu {
  param (
    [string]$Title = 'Run Local Environment'
  )
  Write-Host "================ $Title ================"

  Write-Host '1: Run all services'
  Write-Host '2: Run MySQL container'
  Write-Host '3: Run Django server'
  Write-Host '4: Run React Vite server'
  Write-Host '5: Initialize database'
  Write-Host '6: Generate OpenAPI specs'
  Write-Host 'Q: Quit'
}

do {
  Show-Menu
  $userInput = Read-Host 'Please make a selection'
  # Use Invoke-Expression to run in the same window if the command isn't long-running
  switch ($userInput) {
    '1' {
      Start-MySQLContainer
      Start-Process powershell -ArgumentList '-NoExit', '-Command', $commandsBackend
      Start-Process powershell -ArgumentList '-NoExit', '-Command', $commandsFrontend
    }
    '2' {
      Start-MySQLContainer
    }
    '3' {
      Start-Process powershell -ArgumentList '-NoExit', '-Command', $commandsBackend
    }
    '4' {
      Start-Process powershell -ArgumentList '-NoExit', '-Command', $commandsFrontend
    }
    '5' {
      Invoke-Expression $commandsInitializeDatabase
    }
    '6' {
      Invoke-Expression $commandsGenerateOpenAPI
    }
    'q' {
      break
    }
  }
}

until ($true)