azure-pipelines-prod.yml

parameters:
- name: LBCOMMAND
  displayName: Choose a Liquibase command to run
  values:
    - update
    - rollback
  default: update
- name: TAG
  displayName: Specify a tag when LBCOMMAND=UPDATE
  type: string
  default: release1
- name: ARTIFACTNUMBER
  displayName: Artifact Number to use for PROD deployment and rollback # Human-readable name for the parameter
  type: string
  default: 0
- name: ROLLBACKTAG
  displayName: Specify a tag when LBCOMMAND=ROLLBACK
  type: string
  default: release1

pr: 
  branches:
    include: 
      - release

  # Trigger on merges to any branch
trigger: none
# trigger:
  # branches:
    # include:
    # - 'dev'
    # - 'release'
    # - 'prod'
    # - 'AB#*'

name: $(Application.Name)-$(Build.BuildId)-PROD

variables:
- template: variables.yml
- group: Liquibase_Variables

pool:
  name: $(Agent.PoolName)

stages:

- stage: PROD_Update
  # condition: and(true, contains(variables['system.pullRequest.targetBranchName'], 'release'))
  condition: and (true, contains(variables['Build.SourceBranch'], 'release'), eq('${{ parameters.LBCOMMAND }}', 'update'))
  pool: Windows
  jobs:
  - job: DBUpdate
    displayName: 'DB Update'
    steps:
    - checkout: none    # Disable repository checkout for this step.
      # Download an artifact named 'WebApp' from a specific build run to 'bin' in $(Build.SourcesDirectory)
    - task: DownloadPipelineArtifact@2
      displayName: 'Download-Artifact-${{ parameters.ARTIFACTNUMBER }}'
      inputs:
        buildType: 'specific'
        artifactName: '$(Application.Name)-${{ parameters.ARTIFACTNUMBER }}'
        targetPath: $(Build.SourcesDirectory)
        project: 'Engie'
        definition: ALPS DB - UAT
        buildVersionToDownload: 'specific'
        pipelineId: ${{ parameters.ARTIFACTNUMBER }}
        itemPattern: |
          sqlcode/**
          changelog.xml
    - task: PowerShell@2
      displayName: 'Liquibase-Flow'
      inputs:
        targetType: 'inline'
        script: |
          echo "========== Database UPDATE ==========="
          echo parameters.LBCOMMAND=${{ parameters.LBCOMMAND }}
          echo SCHEMA=${env:SCHEMA}
          echo ROLLBACKTAG=${env:ROLLBACKTAG}
          echo Build.BuildId=$(Build.BuildId)
          dir
          C:\agent\_work\_tool\liquibase-4.24.0\liquibase.bat flow --flow-file=liquibase.flowfile-cd.yaml
          Write-Host Last exit code: $LASTEXITCODE
      env:
        LBCOMMAND: ${{ parameters.LBCOMMAND }}
        SCHEMA: $(PROD_SCHEMA)
        TAG: ${{ parameters.TAG }}        # When updating PROD, the TAG is user provided parameter which is also the artifact from UAT
        LIQUIBASE_COMMAND_URL: $(PROD_URL)
        LIQUIBASE_COMMAND_USERNAME: $(PROD_USERNAME)
        LIQUIBASE_COMMAND_PASSWORD: $(PROD_PASSWORD)


- stage: PROD_Rollback
  # condition: and(true, contains(variables['system.pullRequest.targetBranchName'], 'release'))
  condition: and (true, contains(variables['Build.SourceBranch'], 'release'), eq('${{ parameters.LBCOMMAND }}', 'rollback'))
  pool: Windows
  jobs:
  - job: DBRollback
    displayName: 'DB Rollback tag=${{ parameters.ROLLBACKTAG }}'
    steps:
    - checkout: none    # Disable repository checkout for this step.
      # Download an artifact named 'WebApp' from a specific build run to 'bin' in $(Build.SourcesDirectory)
    - task: DownloadPipelineArtifact@2
      displayName: 'Download-Artifact-${{ parameters.ARTIFACTNUMBER }}'
      inputs:
        buildType: 'specific'
        artifactName: '$(Application.Name)-${{ parameters.ARTIFACTNUMBER }}'
        targetPath: $(Build.SourcesDirectory)
        project: 'Engie'
        definition: ALPS DB - UAT
        buildVersionToDownload: 'specific'
        pipelineId: ${{ parameters.ARTIFACTNUMBER }}
        itemPattern: |
          sqlcode/**
          changelog.xml
    - task: PowerShell@2
      displayName: 'Liquibase-Flow'
      inputs:
        targetType: 'inline'
        script: |
          echo "========== Database ROLLBACK ==========="
          echo parameters.LBCOMMAND=${{ parameters.LBCOMMAND }}
          echo SCHEMA=${env:SCHEMA}
          echo ROLLBACKTAG=${env:ROLLBACKTAG}
          echo Build.BuildId=$(Build.BuildId)
          dir
          C:\agent\_work\_tool\liquibase-4.24.0\liquibase.bat flow --flow-file=liquibase.flowfile-cd-rollback.yaml
          Write-Host Last exit code: $LASTEXITCODE
      env:
        LBCOMMAND: ${{ parameters.LBCOMMAND }}
        SCHEMA: $(PROD_SCHEMA)
        ROLLBACKTAG: ${{ parameters.ROLLBACKTAG }}        # When rolling back PROD, the ROLLBACKTAG is user provided parameter
        LIQUIBASE_COMMAND_URL: $(PROD_URL)
        LIQUIBASE_COMMAND_USERNAME: $(PROD_USERNAME)
        LIQUIBASE_COMMAND_PASSWORD: $(PROD_PASSWORD)