build-win.yml

name: Build and Run Windows Tests

on: [push, pull_request]

jobs:
  build:

    runs-on: windows-latest
    strategy:
      fail-fast: false
      matrix:
        pg-version:
          - 9.3.25-1
          - 9.4.26-1
          - 9.5.25-1
          - 9.6.24-1
          - 10.23-1
          - 11.21-1
          - 12.16-1
          - 13.12-1
          - 14.9-1
          - 15.4-1
          - 16.0-1
          - 17.0-1
        platform:
          - x64
        include:
          - pg-version: 9.3.25-1
            platform: x86
          - pg-version: 9.4.26-1
            platform: x86
          - pg-version: 9.5.25-1
            platform: x86
          - pg-version: 9.6.24-1
            platform: x86
          - pg-version: 10.23-1
            platform: x86

    steps:
      - name: Install PostgreSQL
        run: |
          $ErrorActionPreference = "Stop"

          $pg_full_version = "${{ matrix.pg-version }}"
          $pg_version = $pg_full_version.Substring(0, $pg_full_version.lastIndexOf('.'))
          if ("${{ matrix.platform }}" -eq "x64") {
            $x64 = "-x64"
            $pg_root = "C:\Program Files\PostgreSQL\$pg_version"
            $release_dir = "x64\Release"
          } else {
            $pg_root = "C:\Program Files (x86)\PostgreSQL\$pg_version"
            $release_dir = "Release"
          }
          if (("$pg_version" -eq "9.3") -or ("$pg_version" -eq "9.4")) {
            $psql_opt = "--psqldir"
          } else {
            $psql_opt = "--bindir"
          }

          # Uninstall existing PostgreSQL installation in windows-latest (windows-2025) runner
          # https://github.com/actions/runner-images/blob/main/images/windows/Windows2025-Readme.md#postgresql
          if ("$pg_version" -eq "17") {
            & "C:\Program Files\PostgreSQL\17\uninstall-postgresql.exe" --mode unattended 2>&1 | Out-Default
            Remove-Item -Recurse -Force "C:\Program Files\PostgreSQL\17"
          }

          "PG_VERSION=$pg_version" >> $env:GITHUB_ENV
          "PG_ROOT=$pg_root" >> $env:GITHUB_ENV
          "X64=$x64" >> $env:GITHUB_ENV
          "RELEASE_DIR=$release_dir" >> $env:GITHUB_ENV
          "PSQL_OPT=$psql_opt" >> $env:GITHUB_ENV
          if ("$pg_version" -eq "17") {
            "PG_REGRESS=$pg_root\lib\pgxs\src\test\regress\pg_regress.exe" >> $env:GITHUB_ENV
          } else {
            "PG_REGRESS=$pg_root\bin\pg_regress.exe" >> $env:GITHUB_ENV
          }

          Invoke-webrequest -uri https://get.enterprisedb.com/postgresql/postgresql-${pg_full_version}-windows${x64}.exe -OutFile postgresql.exe

          if ("$pg_version" -eq "9.6") {
            & ".\postgresql.exe" --unattendedmodeui none --mode unattended --superpassword password --servicepassword password --install_runtimes 0 2>&1 | Out-Default
          } else {
            & ".\postgresql.exe" --unattendedmodeui none --mode unattended --superpassword password --servicepassword password 2>&1 | Out-Default
          }

      - uses: actions/checkout@v3

      - uses: microsoft/setup-msbuild@v1.1

      - name: Build app for release
        run: |
          msbuild temporal_tables.vcxproj -t:rebuild -verbosity:minimal -property:Configuration=Release -property:Platform=${{ matrix.platform }} -property:PlatformToolset=v143
        env:
          pgversion: ${{ matrix.pg-version }}
          pgroot: ${{ env.PG_ROOT }}

      - name: Run Tests
        run: |
          $ErrorActionPreference = "Stop"

          $serviceName = "postgresql$env:X64-$env:PG_VERSION"
          $pgData = "C:\pgdata"
          $pgPort = "55432"

          $env:PGPORT = $pgPort
          $env:PGHOST = "localhost"
          $env:Path = "$env:PG_ROOT\bin;$env:Path"

          if (Get-Service -Name $serviceName -ErrorAction SilentlyContinue) {
            Stop-Service -Name $serviceName -Force -ErrorAction SilentlyContinue
            & "$env:PG_ROOT\bin\pg_ctl.exe" unregister -N "$serviceName" 2>&1 | Out-Default
            Start-Sleep -Seconds 2
          }
          Remove-Item -Recurse -Force "$pgData" -ErrorAction SilentlyContinue

          Copy ".\$env:RELEASE_DIR\temporal_tables.dll" "$env:PG_ROOT\lib"
          Copy ".\*.sql" "$env:PG_ROOT\share\extension"
          Copy ".\*.control" "$env:PG_ROOT\share\extension"

          Set-Content -path pg.pass -value $env:PGPASSWORD -encoding ascii
          & "$env:PG_ROOT\bin\initdb.exe" -A md5 -U postgres --pwfile=pg.pass "$pgData" 2>&1 | Out-Default
          & "$env:PG_ROOT\bin\pg_ctl.exe" register -S demand -N "$serviceName" -D "$pgData" -o "-p $pgPort" 2>&1 | Out-Default

          Start-Service -Name "$serviceName"

          Get-ChildItem "$env:PG_REGRESS"

          & "$env:PG_REGRESS" "$env:PSQL_OPT=$env:PG_ROOT\bin" --dbname=pl_regression install no_system_period invalid_system_period no_history_table no_history_system_period invalid_types invalid_system_period_values versioning versioning_custom_system_time structure uninstall 2>&1 | Out-Default

          if ($LASTEXITCODE -ne 0) {
            if (Test-Path -Path ".\regression.diffs") {
              Get-Content -Path ".\regression.diffs" | Out-Host
            }
            Write-Error "Tests failed"
          }
        env:
          PGUSER: postgres
          PGPASSWORD: password

      - name: Package Artifacts
        if: startsWith(github.ref, 'refs/tags/')
        run: |
          $ErrorActionPreference = "Stop"

          New-Item -ItemType Directory -Force -Path .\package\lib
          New-Item -ItemType Directory -Force -Path .\package\share\extension

          Copy ".\LICENSE" ".\package\TEMPORAL_TABLES_LICENSE"
          Copy ".\$env:RELEASE_DIR\temporal_tables.dll" ".\package\lib"
          Copy ".\*.sql" ".\package\share\extension"
          Copy ".\*.control" ".\package\share\extension"

          Compress-Archive -Path ".\package\*" -DestinationPath temporal_tables-pg${{ env.PG_VERSION }}-${{ matrix.platform }}.zip

      - name: Deploy Artifacts
        uses: softprops/action-gh-release@v1
        if: startsWith(github.ref, 'refs/tags/')
        with:
          fail_on_unmatched_files: true
          files: |
            temporal_tables-pg${{ env.PG_VERSION }}-${{ matrix.platform }}.zip