ci.yml

name: "CI: Build and Test"

on:
  push:
    branches: [main, feat/automatic_E2E_testing]
    # paths:
    #   - "**.cs"
    #   - "**.tsx"
    #   - "**.js"
    #   - "**.csproj"
    #   - "**.props"
    #   - "**.targets"
    #   - "**.sln"
    #   - "**/Client/**/*.json"
  pull_request:
    branches: [main]
    paths:
      - "**.cs"
      - "**.cshtml"
      - "**.tsx"
      - "**.js"
      - "**.json"
      - "**.csproj"
      - "**.props"
      - "**.targets"
      - "**.sln"

jobs:
  build_and_test:
    name: Test E2E
    runs-on: ubuntu-latest
    defaults:
      run:
        shell: pwsh

    env:
      ASPNETCORE_ENVIRONMENT: CI
      DATABASE_BACKUP_FILENAME: ""
      DOTNET_CLI_TELEMETRY_OPTOUT: 1
      DOTNET_SKIP_FIRST_TIME_EXPERIENCE: 1
      DOTNET_NOLOGO: 1
      PROJECT_NAME: DancingGoat
      ASPNETCORE_URLS: https://localhost:14070
      STATUS_CHECK_URL: https://localhost:14070/status
      DATABASE_USER: "sa"
      DATABASE_PASSWORD: "Pass@12345"
      DATABASE_NAME: "XByK_DancingGoat_Zapier"
      XPERIENCE_BY_KENTICO_LICENSE: ${{ secrets.XPERIENCE_BY_KENTICO_LICENSE }}

    steps:
      - uses: actions/checkout@v4

      - name: Setup .NET
        uses: actions/setup-dotnet@v4
        with:
          global-json-file: global.json

      - name: Setup Node
        uses: actions/setup-node@v4
        with:
          node-version: lts/*

      - name: Install NPM
        run: |
          cd tests/Playwright
          npm ci
          npx playwright install --with-deps
          cd ../..

      - name: Get Database Backup Name
        run: |
          $latestBackup = Get-Content -Path "./database/backups.txt" -TotalCount 1
          "DATABASE_BACKUP_FILENAME=$latestBackup" >> $env:GITHUB_ENV

      - name: Extract Database Backup
        run: |
          Expand-Archive `
            -Path "./database/${{ env.DATABASE_BACKUP_FILENAME }}.zip" `
            -DestinationPath "./database"

      - name: Install a SQL Server suite of tools (SQLEngine, SQLPackage)
        uses: potatoqualitee/mssqlsuite@9a0136e208df60b8ecb62909f076bc34854fa55a # set as a commit hash for security - v1.7
        with:
          install: sqlpackage, sqlengine
          sa-password: ${{ env.DATABASE_PASSWORD }}
          version: 2022

      - name: Restore Database .bak
        run: |
          docker exec sql mkdir /var/opt/mssql/backup
          docker cp "./database/${{ env.DATABASE_BACKUP_FILENAME }}" sql:/var/opt/mssql/backup
          sqlcmd `
            -S localhost `
            -d master `
            -U ${{ env.DATABASE_USER }} `
            -P ${{ env.DATABASE_PASSWORD }} `
            -Q "RESTORE DATABASE [XByK_DancingGoat_Zapier] FROM DISK='/var/opt/mssql/backup/${{ env.DATABASE_BACKUP_FILENAME }}' WITH MOVE 'XByK_DancingGoat_Zapier' TO '/var/opt/mssql/data/XByK_DancingGoat_Zapier.mdf', MOVE 'XByK_DancingGoat_Zapier_log' TO '/var/opt/mssql/data/XByK_DancingGoat_Zapier_log.ldf'"      
      
      - name: Imports license key to DB
        run: |
          sqlcmd `
            -S localhost `
            -d ${{ env.DATABASE_NAME }} `
            -U ${{ env.DATABASE_USER }} `
            -P ${{ env.DATABASE_PASSWORD }} `
            -Q "UPDATE CMS_SettingsKey SET KeyValue='${{ env.XPERIENCE_BY_KENTICO_LICENSE }}' WHERE KeyName='CMSLicenseKey'"
      
      - name: Seed DB with data for testing purposes
        run: |
          cd scripts
          ./Seed-Database.ps1
          cd ..      

      - name: Reset DB consistency for last applied hotfix
        run: |
          dotnet build `
            --configuration Release
          cd scripts
          ./Reset-DatabaseConsistency.ps1
          cd ..
      
      - name: Build Solution for last hotfix
        run: |
          dotnet build `
            --configuration Release `
            -p:XbyKVersion=*
          cd scripts
          ./Reset-DatabaseConsistency.ps1 -ExcludeCIRestore
          cd ..

      - name: Publish Application
        run: |
          dotnet publish `
            ./examples/${{ env.PROJECT_NAME }} `
            -c Release `
            -o ./publish `
            --no-build `
            --no-restore
        
      - name: Install Azurite
        id: azuright
        uses: potatoqualitee/azuright@e56d2754eb15218d507961493bc83ca037216887 # set as a commit hash for security - v1.1


      - name: Test Solution
        run: |
          dotnet test `
            --configuration Release `
            --no-build `
            --no-restore

      - name: Run Application and E2E Tests
        run: |
          # Run the ASP.NET Core app as a background job
          cd ./publish
          Start-Job -ScriptBlock { dotnet ./${{ env.PROJECT_NAME }}.dll } -Name ${{ env.PROJECT_NAME }}
          Receive-Job -Name ${{ env.PROJECT_NAME }}
          cd ../
          # The ASP.NET Core app can take a few seconds to start, so we delay running tests
          #   until it is ready, and fail if we go over a maximum wait time
          $limit = 10
          $attempts = 0
          $success = $false
          while ($attempts -lt $limit -and -not $success) {
              Start-Sleep -Seconds 1
              try {
                  $response = Invoke-WebRequest -Uri ${{ env.STATUS_CHECK_URL }} -Method Get -SkipCertificateCheck
                  if ($response.StatusCode -eq 200) {
                      Write-Output "Application is ready."
                      $success = $true
                  }
              }
              catch {
                  Write-Output "Attempt $attempts - Application not ready yet."
              }
              $attempts++
          }
          if (-not $success) {
              Write-Output "Application did not respond in time."
              exit 1
          }
          # Run the E2E tests
          cd tests/Playwright
          npx playwright test
          cd ../..
  

          # Stop the background ASP.NET Core application
          Receive-Job -Name ${{ env.PROJECT_NAME }}
          Stop-Job -Name ${{ env.PROJECT_NAME }}
          Remove-Job -Name ${{ env.PROJECT_NAME }}

      - uses: actions/upload-artifact@v4
        with:
          name: playwright-report
          path: ./tests/Playwright/playwright-report/
          retention-days: 30