appveyor.yml

install:
  - git submodule update --init --recursive
  - ps: |
      Add-Type -AssemblyName System.IO.Compression.FileSystem
      if (!(Test-Path -Path "C:\sbt" )) {
        (new-object System.Net.WebClient).DownloadFile(
          'https://piccolo.link/sbt-0.13.17.zip',
          'C:\sbt-bin.zip'
        )
        [System.IO.Compression.ZipFile]::ExtractToDirectory("C:\sbt-bin.zip", "C:\sbt")
      }
  - cmd: SET JDK_HOME=C:\Program Files\Java\jdk11
  - cmd: SET JAVA_HOME=C:\Program Files\Java\jdk11
  - cmd: SET PATH=C:\sbt\sbt\bin;%JDK_HOME%\bin;%PATH%
  - cmd: SET SBT_OPTS=-Xmx4g -Xss2m -Dslick.testkit-config=test-dbs/testkit.appveyor.conf
# Start up sqlservers: 2008 on port 1433, 2012 on 1533, 2014 on 1633, 2017 on 1733. Enable tcp connections
  - ps: |
      [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null;
      [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement") | Out-Null;
      $port = 1433
      foreach($instancename in @('SQL2008R2SP2', 'SQL2012SP1', 'SQL2014', 'SQL2017'))
      {
          $wmi = New-Object('Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer');
          $tcp = $wmi.GetSmoObject("ManagedComputer[@Name='${env:computername}']/ServerInstance[@Name='${instancename}']/ServerProtocol[@Name='Tcp']");
          $tcp.IsEnabled = $true;
          foreach ($ipAddress in $tcp.IPAddresses)
          {
            $ipAddress.IPAddressProperties["TcpDynamicPorts"].Value = ""
            $ipAddress.IPAddressProperties["TcpPort"].Value = "${port}"
          }
          $tcp.Alter();
          Start-Service -Name "MSSQL`$$instancename";
          $wmi = New-Object('Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer');
          $ipall = $wmi.GetSmoObject("ManagedComputer[@Name='${env:computername}']/ServerInstance[@Name='${instancename}']/ServerProtocol[@Name='Tcp']/IPAddress[@Name='IPAll']");
          $config = @{
            instanceName = $instancename;
            config = @{
              server = "localhost";
              userName = "sa";
              password = "Password12!";
              options = @{
                port = ${port};
                database = "master";
                  cryptoCredentialsDetails = @{
                ciphers = "RC4-MD5"
                }
              }
            }
          } | ConvertTo-Json -Depth 3;
          Write-Host "${config}"
          $port += 100
      }
  - bash -v ./travis/extractNonPublicDeps
build_script:
  - sbt ++2.12.9 clean compile test:compile
test_script:
  - sbt ++2.12.9 testkit/test:test
cache:
  - C:\Users\appveyor\.ivy2