appveyor.yml

version: "{build}"

environment:
  matrix:
    - nodejs_version: "10"
    - nodejs_version: "12"
    - nodejs_version: "14"

install:
  # https://www.appveyor.com/docs/lang/nodejs-iojs/#installing-any-version-of-nodejs-or-iojs
  - ps: Update-NodeJsInstallation (Get-NodeJsLatestBuild $env:nodejs_version) $env:PLATFORM
  - npm install
  - npm install msnodesqlv8@^2

platform:
  - x86
  - x64

cache:
  - node_modules

build: off

before_test:
  - sc config sqlbrowser start= auto
  - net start sqlbrowser

test_script:
  - node --version
  - npm --version

  - cmd: |
      SET EXITVAL=0

      npm run-script test-unit || SET EXITVAL=1

      SET MSSQL_VERSION=2008
      powershell %cd%\test\scripts\appveyor.ps1 SQL2008R2SP2
      npm run-script test-tedious || SET EXITVAL=1
      npm run-script test-msnodesqlv8 || SET EXITVAL=1
      net stop MSSQL$SQL2008R2SP2

      SET MSSQL_VERSION=2012
      powershell %cd%\test\scripts\appveyor.ps1 SQL2012SP1
      npm run-script test-tedious || SET EXITVAL=1
      npm run-script test-msnodesqlv8 || SET EXITVAL=1
      net stop MSSQL$SQL2012SP1

      SET MSSQL_VERSION=2014
      powershell %cd%\test\scripts\appveyor.ps1 SQL2014
      npm run-script test-tedious || SET EXITVAL=1
      npm run-script test-msnodesqlv8 || SET EXITVAL=1
      net stop MSSQL$SQL2014

      SET MSSQL_VERSION=2016
      powershell %cd%\test\scripts\appveyor.ps1 SQL2016
      npm run-script test-tedious || SET EXITVAL=1
      npm run-script test-msnodesqlv8 || SET EXITVAL=1
      net stop MSSQL$SQL2016

      EXIT /B %EXITVAL%