go-sqlcmd/.pipelines/TestSql2017.yml at b3ca1c7de372153a9b6287c7d1949ef955f79b6f · microsoft/go-sqlcmd · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
variables:
  PASSWORD: $(SQLPASSWORD)
pool:
   vmImage: 'ubuntu-latest'

steps:
  - template: include-install-go-tools.yml

  - task: Docker@2
    displayName: 'Run SQL 2022 docker image'
    inputs:
      command: run
      arguments: '-m 2GB -e ACCEPT_EULA=1 -d --name sql2022 -p:1433:1433 -e SA_PASSWORD=$(PASSWORD) mcr.microsoft.com/mssql/server:2022-latest'

  - template: include-runtests-linux.yml
    parameters:
      RunName: 'SQL2022'
      SQLCMDUSER: sa
      SQLPASSWORD: $(PASSWORD)

  - task: AzureCLI@2
    inputs:
      addSpnToEnvironment: true
      azureSubscription: $(AZURESUBSCRIPTION_SERVICE_CONNECTION_NAME)
      scriptType: pscore
      scriptLocation: inlineScript
      inlineScript: |
        Write-Host "##vso[task.setvariable variable=AZURESUBSCRIPTION_CLIENT_ID;]$env:AZURESUBSCRIPTION_CLIENT_ID"
        Write-Host "##vso[task.setvariable variable=AZURESUBSCRIPTION_TENANT_ID;]$env:AZURESUBSCRIPTION_TENANT_ID"
        gci env:* | sort-object name

  - template: include-runtests-linux.yml
    parameters:
      RunName: 'SQLDB'
      # AZURESERVER must be defined as a variable in the pipeline
      SQLCMDSERVER: $(AZURESERVER)
  - task: UseDotNet@2
    inputs:
      packageType: 'runtime'
      version: '8.x'

  - task: PublishCodeCoverageResults@2
    inputs:
      pathToSources: '$(Build.SourcesDirectory)'
      summaryFileLocation: $(Build.SourcesDirectory)/**/*coverage.xml
      failIfCoverageEmpty: true
    condition: always()
    continueOnError: true