.appveyor.yml

image: Visual Studio 2017 Preview
version: 3.3.0-{build}
environment:
  global:
    DOTNET_SKIP_FIRST_TIME_EXPERIENCE: true
    DOTNET_CLI_TELEMETRY_OPTOUT: 1
    NPGSQL_TEST_DB: Host=localhost;Database=postgres;Username=postgres;Password=Password12!
    PGUSER: postgres
    PGPASSWORD: Password12!
    POSTGIS_EXE: postgis-bundle-pg96x64-setup-2.3.2-1.exe
cache:
  - '%USERPROFILE%\.nuget\packages -> **\*.csproj'
  - 'C:\projects\npgsql\packages -> **\*.csproj'  # For VSIX
  - $(POSTGIS_EXE)
shallow_clone: true
install:
  - powershell .build\setup-pg.ps1
services:
  - postgresql
before_build:
  - '"C:\Program Files\PostgreSQL\9.6\bin\psql" -c "CREATE EXTENSION postgis"'
  - appveyor-retry dotnet restore -v Minimal
  - appveyor-retry nuget restore Npgsql.sln   # For VSIX
build_script:
  - dotnet build "src\Npgsql" -c ReleaseOptimizedCryptography
  - dotnet build "src\Npgsql.Json.NET" -c Release
  - dotnet build "src\Npgsql.NodaTime" -c Release
  - dotnet build "test\Npgsql.Tests" -c Debug -f net451
  - dotnet build "test\Npgsql.PluginTests" -c Debug -f net451
  - msbuild src\VSIX\VSIX.csproj /p:Configuration=Release
  - msbuild src\MSI\MSI.wixproj /p:Configuration=Release
after_build:
  - ps: $env:padded_build_number = $env:appveyor_build_number.PadLeft(5, '0')
  - dotnet pack src\Npgsql\Npgsql.csproj -c ReleaseOptimizedCryptography --version-suffix ci-%PADDED_BUILD_NUMBER%
  - dotnet pack src\Npgsql.Json.NET\Npgsql.Json.NET.csproj -c Release --version-suffix ci-%PADDED_BUILD_NUMBER%
  - dotnet pack src\Npgsql.NodaTime\Npgsql.NodaTime.csproj -c Release --version-suffix ci-%PADDED_BUILD_NUMBER%
test:
  assemblies:
    - test\Npgsql.Tests\bin\Debug\net451\Npgsql.Tests.dll
    - test\Npgsql.PluginTests\bin\Debug\net451\Npgsql.PluginTests.dll
artifacts:
  - path: 'src\Npgsql\bin\**\*.nupkg'
    name: Npgsql Nuget
  - path: 'src\Npgsql.Json.NET\bin\**\*.nupkg'
    name: Npgsql Json.NET Plugin Nuget
  - path: 'src\Npgsql.NodaTime\bin\**\*.nupkg'
    name: Npgsql NodaTime Plugin Nuget
  - path: 'src\VSIX\bin\**\*.vsix'
    name: Visual Studio Extension
  - path: 'src\MSI\bin\**\*.msi'
    name: MSI Installer
deploy:
  - provider: NuGet
    server: https://www.myget.org/F/npgsql-unstable/api/v2/package
    api_key:
      secure: kiMn9uBvgMa5EtEmTIhNBFUfyatiATnhkgx5Xj/1EsmKTtEkUv+hJAQs0L3VGzPw
    artifact: /.*\.nupkg/
    skip_symbols: true
    #skip_symbols: false
    #symbol_server: https://your.symbol.server/feed