Azure Devops YAML-动态条件评估

Question

我试图根据SQL查询的结果使用条件来脱离循环。因此，我将查询输出分配给变量“ sqloutput”，如果该值为空字符串再次四处走动。我已经确认查询正在输出一个值，但是在后续循环中，变量仍在评估为null。

还试图明确声明该变量无济于事。

parameters:
- name: loop
  type: object
  default :  ["1","2","3","4","5","6","7","8","9","10"]

stages:
- stage: WaitforProcessing
  displayName: Wait For Processing
  jobs: 
  - deployment: Deployment 
    pool:
      vmImage: ubuntu-latest
    environment:
      name: 'Client_Data_Tests'
      resourceType: VirtualMachine
    strategy:
      runOnce:
        deploy:
          steps:
          - ${{each Looptimes in parameters.loop}}:
            - task: PowerShell@2
              name: checkImportProgress${{ Looptimes }}
              condition:  and(succeeded(), eq(variables['sqloutput'], ''))
              displayName: Check if job finished 
              inputs:
                targetType: inline
                script: |
                  $query = "IF EXISTS (select 1 from Job where JobFinishTime is null)
                              BEGIN
                                select '' as result
                              END
                              ELSE
                                select '1' as result
                              "
                  $sqloutput = Invoke-Sqlcmd -query $query -ServerInstance "$(DB_SERVER)" -Database "$(DB_DATABASE)" -Username "$(DB_USERNAME)" -Password "$(DB_PASSWORD)" -QueryTimeout 36000 -Verbose
                  $value = $sqloutput["result"]
                  Write-Host $value
                  Write-Host "##vso[task.setvariable variable=sqloutput]$value"
            - task: PowerShell@2
              condition:  and(succeeded(), eq(variables['sqloutput'], ''))
              displayName: 'Sleep for 30 seconds'
              inputs:
                targetType: inline
                script: |
                  Start-Sleep 30

Answer 1

下面的yaml应该起作用。

stages:
- stage: A
  jobs:
  - job: A
    displayName: SQL generate variable
    steps:
    - powershell: |
          $value = 'somevalue'
          echo "##vso[task.setvariable variable=sqloutput;isOutput=true]$value"
      name: setvarStep
    - script: echo $(setvarStep.sqloutput)
      name: echovar

  - job: B
    dependsOn: A
    displayName: Use variable that SQL script output as condition
    variables:
      myVarFromJobA: $[ dependencies.A.outputs['setvarStep.sqloutput'] ]  # map in the variable
      myvar: true    
    condition: eq(variables['myVarFromJobA'],'somevalue')
    steps:
    - script: echo $(myVarFromJobA)
      name: echovar

结果：