migrate_deploy.yml

name: Database Migrations and Deploy

on:
  workflow_dispatch:
    inputs:
      branch:
        description: 'Branch to run the workflow'
        required: true
        default: 'release'

jobs:
  migrate-and-deploy:
    runs-on: ubuntu-latest
    if: github.event.inputs.branch == 'release'

    steps:
      - name: Checkout code
        uses: actions/checkout@v4

      - name: Set up .NET
        uses: actions/setup-dotnet@v4
        with:
            dotnet-version: '8.x'

      - name: Install dotnet-ef Tool
        run: dotnet tool install --global dotnet-ef
            
      - name: Restore Dependencies
        run: dotnet restore Shortify.NET.API/Shortify.NET.API.csproj
            
      - name: Generate Migration Script
        run: dotnet ef migrations script --idempotent --context AppDbContext --startup-project Shortify.NET.API/Shortify.NET.API.csproj --project Shortify.NET.Persistence/Shortify.NET.Persistence.csproj -o migrations.sql
        
      - name: Apply Migration Script
        env:
          PGHOST: ${{ secrets.DATABASE_HOST }}
          PGPORT: ${{ secrets.DATABASE_PORT }}
          PGUSER: ${{ secrets.DATABASE_USER }}
          PGPASSWORD: ${{ secrets.DATABASE_PASSWORD }}
          PGDATABASE: ${{ secrets.DATABASE_NAME }}
        run: psql -h $PGHOST -p $PGPORT -U $PGUSER -d $PGDATABASE -f migrations.sql $PGPASSWORD
        
      - name: Deploy to Render
        env:
          deploy_url: ${{ secrets.RENDER_DEPLOY_HOOK_URL }}
        run: |
          curl "$deploy_url"