appveyor.yml

image: Visual Studio 2015
configuration: Release
platform: x64
clone_depth: 1
environment:
  PGUSER: postgres
  PGPASSWORD: Password12!
  rversion: 4.1.0
  matrix:

  - pg: master
    PlatformToolset: v141
    configuration: Debug
    APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017

  - pg: REL_13_0
    PlatformToolset: v141
    configuration: Release
    APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017
  - pg: REL_12_0
    PlatformToolset: v141
    configuration: Release
    APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017

  - pg: 9.6.13-1
    PlatformToolset: v120
  - pg: 11.11-2
    PlatformToolset: v140
  - pg: 12.6-2
    PlatformToolset: v141
    APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017
  - pg: 13.2-2
    PlatformToolset: v141
    APPVEYOR_BUILD_WORKER_IMAGE: Visual Studio 2017

matrix:
  allow_failures:
    - pg: master

init: # Make %x64% available for caching
- ps: iex ((new-object net.webclient).DownloadString('https://raw.githubusercontent.com/appveyor/ci/master/scripts/enable-rdp.ps1'))
- if %PLATFORM%==x64 ( set pf=%ProgramFiles%&& set x64=-x64) else set pf=%ProgramFiles(x86)%
- set exe=postgresql-%pg%-windows%x64%.exe
- setx /m exe %exe%

install:
- if not exist R-%rversion%-win.exe appveyor downloadfile https://cran.r-project.org/bin/windows/base/old/%rversion%/R-%rversion%-win.exe
- R-%rversion%-win.exe /VERYSILENT
# We could have used RTools many R users have, but let's use msys64 existing on Appveyor intead
#- if not exist Rtools35.exe appveyor downloadfile https://cran.r-project.org/bin/windows/Rtools/Rtools35.exe
#- Rtools35.exe /VERYSILENT
- Set mingw=C:\msys64\mingw
#
# From the EnterpriseDB version name,
# if any, strip off the: right-most part dot, then numbers, then one hyphen, then numbers.
- ps: $env:pgversion = $env:pg -replace "[.]\d+-\d+$", ""
#
- echo pgversion=%pgversion%
- set pgroot=%pf%\PostgreSQL\%pgversion%
- echo %pgroot%
- SET R_HOME=%ProgramFiles%\R\R-%rversion%
- set RBIN=%PLATFORM:x86=i386%
- SET sed=C:\msys64\usr\bin\sed
# R in the path is not required: msvc compilation
# R in the path is required: find Rscript
- set PATH=%R_HOME%\bin\%rbin%;%PATH%
# environment variable "postgresrcroot" is required for msvc.diff.R
- set postgresrcroot=C:\projects\postgresql
- ps: |
    # notmatch - if no "dot is found" in pg name, then pg is a: git: branch, tag, or commit.
    if ("${env:pg}" -notmatch "[.]") {
      $env:Path += ";C:\msys64\usr\bin;C:\msys64\mingw64\bin;C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\amd64"
      git config --global advice.detachedHead false
      #
      # git commit
      #
      if(("${env:pg}" -cmatch  "^[a-z0-9]+$") -and ("${env:pghint}" -eq "commit")) {
        git clone -q  https://git.postgresql.org/git/postgresql.git  c:\projects\postgresql
        pushd c:\projects\postgresql
        git checkout -q  ${env:pg} -b ${env:pg}
        popd
      #
      # git branch or tag(detached head)
      # PostgreSQL case - git branches and tags have at least one capital letter - but expect mostly CAPS
      #
      } else {
        git clone -q --depth 1 --branch ${env:pg} https://git.postgresql.org/git/postgresql.git  c:\projects\postgresql
      }
      gendef - "$env:R_HOME\bin\$env:rbin\R.dll" > "R$env:PLATFORM.def" 2> $null
      lib "/def:R$env:PLATFORM.def" "/out:R$env:PLATFORM.lib" "/MACHINE:$env:PLATFORM"
      pushd c:\projects\postgresql
      cmd /c mklink /J contrib\plr $env:APPVEYOR_BUILD_FOLDER
      Rscript --vanilla "${env:APPVEYOR_BUILD_FOLDER}\msvc.diff.R"
      perl contrib\plr\buildsetup.pl
      popd
      $env:PROJ="C:\projects\postgresql\pgsql.sln"
      $env:dll="c:\projects\postgresql\$env:CONFIGURATION\plr\plr.dll"
    } else {
      $env:PROJ="plr.vcxproj"
      $env:dll="$($env:PLATFORM.replace('x86', '.'))\$env:CONFIGURATION\plr.dll"
      if (-not (Test-Path "$env:pgroot\bin")) {
        if (-not (Test-Path "$env:exe")) {
          Start-FileDownload "http://get.enterprisedb.com/postgresql/$env:exe"
        }
        & ".\$env:exe" --unattendedmodeui none --mode unattended --superpassword "$env:PGPASSWORD" --servicepassword "$env:PGPASSWORD" | Out-Null
        Stop-Service "postgresql$env:x64-$env:pgversion"
      }
    }

#on_finish:
# - ps: $blockRdp = $true; iex ((new-object net.webclient).DownloadString('https://raw.githubusercontent.com/appveyor/ci/master/scripts/enable-rdp.ps1'))

cache:
- '%exe%'
- R-%rversion%-win.exe

build_script:
- msbuild /p:PlatformToolset=%PlatformToolset% /p:configuration=%CONFIGURATION% /p:platform=%PLATFORM%
          %PROJ%
          /verbosity:minimal /logger:"C:\Program Files\AppVeyor\BuildAgent\Appveyor.MSBuildLogger.dll"

after_build:
- appveyor AddMessage Packing -Category Information
- md tmp\share\extension
- copy *.sql tmp\share\extension\
- copy *.control tmp\share\extension\
- copy LICENSE tmp\PLR_LICENSE
- md tmp\lib
- md tmp\symbols
- copy %dll% tmp\lib
- copy %dll:.dll=.pdb% tmp\symbols
- set zip=plr-%APPVEYOR_REPO_COMMIT:~0,8%-pg%pgversion%-R%rversion%-%PLATFORM%-%CONFIGURATION%.zip
- 7z a -r %zip% .\tmp\* > nul
- ps: |
    if ("$env:pg" -notmatch "[.]") {
      pushd c:\projects\postgresql\src\tools\msvc
      perl install.pl "$env:pgroot"
      popd
    }

test_script:
- path %pgroot%\bin;%PATH%
- ps: |
    if ("$env:pg" -notmatch "[.]") {
      Set-Content -path pg.pass -value "$env:pgpassword" -encoding ascii
      initdb -A md5 -U "$env:PGUSER" --pwfile=pg.pass C:\pgdata
      pg_ctl register -S demand -N "postgresql$env:x64-$env:pgversion" -D c:\pgdata
    } else {
      Add-AppveyorMessage "Copying the extension files to the PostgreSQL directories." -Category Information
      7z x "$env:zip" "-o$env:pgroot"
    }
- appveyor AddMessage "Starting the database server." -Category Information
- setx /M PATH "%R_HOME%\bin\%rbin%;%PATH%"
- net start postgresql%x64%-%pgversion%

- ps: |
    Add-AppveyorTest Regression -Framework pg_regress -FileName sql\ -Outcome Running
    if (("9.3", "9.4").Contains("$env:pgversion")) {
      $env:psqlopt="--psqldir"
    } else {
      $env:psqlopt="--bindir"
    }
    $env:Outcome="Passed"
    $elapsed=(Measure-Command {
      pg_regress "$env:psqlopt=$env:pgroot\bin" --dbname=pl_regression plr `
        bad_fun opt_window do out_args plr_transaction opt_window_frame 2>&1 |
        %{ if ($_ -is [System.Management.Automation.ErrorRecord]) { $_.Exception.Message } else { $_ } } |
          Out-Default
      if ($LASTEXITCODE -ne 0) {
        $env:Outcome="Failed"
      }
    }).TotalMilliseconds
    Update-AppVeyorTest Regression -Framework pg_regress -FileName sql\ -Outcome "$env:Outcome" -Duration $elapsed
    if ("$env:Outcome" -ne "Passed") {
      type regression.diffs
      $host.SetShouldExit($LastExitCode)
    }

artifacts:
- path: '*.zip'

deploy:
   provider: GitHub
   release: $(appveyor_repo_tag_name)
   draft: false
   prerelease: false
   auth_token:
      secure: sFXG3dBiC2S9bnHbDfg2fS0OdaxiSr6fGSlMQvQPb0lJGyKM3E5UZum4rik60zyi
   on:
      appveyor_repo_tag: true