1#!/bin/bash
2# Apply EF Core database migrations to Azure SQL using Managed Identity authentication.
3#
4# USAGE: Copy this file to scripts/apply-migrations.sh in your project root and add
5#        a postprovision hook in azure.yaml:
6#
7#   hooks:
8#     postprovision:
9#       posix:
10#         shell: sh
11#         run: ./scripts/apply-migrations.sh
12#       windows:
13#         shell: pwsh
14#         run: ./scripts/apply-migrations.ps1
15#
16# ENVIRONMENT VARIABLES (sourced from azd env):
17#   SQL_SERVER    - SQL server name (without .database.windows.net)
18#   SQL_DATABASE  - Database name
19#
20# PREREQUISITES:
21#   - dotnet-ef tool (installed automatically if missing)
22#   - A valid managed identity or Entra-authenticated session
23#
24# CONFIGURATION:
25#   Set APP_PROJECT_PATH below to the path of your application project (.csproj directory)
26 
27set -e
28 
29APP_PROJECT_PATH="src/api"  # Adjust to your project directory
30 
31# Safely load azd environment variables without eval
32while IFS= read -r line; do
33  [ -n "$line" ] || continue
34  key=${line%%=*}
35  value=${line#*=}
36  case "$value" in
37    \"*\") value=${value#\"}; value=${value%\"} ;;
38    \'*\') value=${value#\'}; value=${value%\'} ;;
39  esac
40  export "$key=$value"
41done < <(azd env get-values)
42 
43# Install dotnet-ef only when it is not already installed (no-op when already present)
44if ! dotnet tool list --global 2>/dev/null | grep -q '^\s*dotnet-ef\s'; then
45  dotnet tool install --global dotnet-ef
46fi
47export PATH="$PATH:$HOME/.dotnet/tools"
48 
49CONNECTION_STRING="Server=tcp:${SQL_SERVER}.database.windows.net,1433;Database=${SQL_DATABASE};Authentication=Active Directory Default;Encrypt=True;"
50 
51echo "Applying EF Core migrations..."
52cd "$APP_PROJECT_PATH"
53dotnet ef database update --connection "$CONNECTION_STRING"
54echo "Migrations applied successfully."
55