docker-build-push.yml

name: Docker Image CI

on:
  push:
    branches: [ main ]
  schedule:
    - cron: '0 5 * * *'
  workflow_dispatch:

jobs:

  get-version-number:
    runs-on: windows-latest
    outputs:
      FLYWAY_VERSION: ${{ steps.step1.outputs.CURRENT_FLYWAY_VERSION }}
      CONTINUE: ${{ steps.step1.outputs.Continue }}
      WIN2019_VERSION: ${{ steps.step1.outputs.WIN2019_VERSION }}
      WIN2022_VERSION: ${{ steps.step1.outputs.WIN2022_VERSION }}
    steps:    
    - uses: actions/checkout@v3
    - id: step1
      name: Compare latest flyway version with container
      run: |
        $manifestDataRaw = Invoke-WebRequest "https://download.red-gate.com/maven/release/org/flywaydb/enterprise/flyway-commandline/maven-metadata.xml"
        $manifestData = [Xml]$manifestDataRaw

        $latestFlywayVersion = $manifestData.metadata.versioning.release

        $workerToolsTags = Invoke-RestMethod "https://registry.hub.docker.com/v2/repositories/octopuslabs/flyway-enterprise-workertools/tags?page_size=50"
        $matchingTag = $workerToolsTags.results | Where-Object { $_.name -eq $latestFlywayVersion }

        echo "CURRENT_FLYWAY_VERSION=$latestFlywayVersion" >> $env:GITHUB_OUTPUT

        if ($null -ne $matchingTag)
        {
            Write-Host "Docker container already has latest version of flyway"
            echo "CONTINUE=No" >> $env:GITHUB_OUTPUT
        }
        else
        {
            Write-Host "We need to upgrade the flyway container to $latestFlywayVersion"            
        
            Write-Host "Getting OS versions for windows 2022 and 2019"
            $win2019_manifest = (docker manifest inspect --verbose "octopuslabs/workertools:latest-windows.2019" | ConvertFrom-Json)
            $WIN2019_VERSION = $win2019_manifest.Descriptor.Platform.'os.version'
            Write-Host "WIN2019_VERSION: $WIN2019_VERSION"

            $win2022_manifest = (docker manifest inspect --verbose "octopuslabs/workertools:latest-windows.2022" | ConvertFrom-Json)
            $WIN2022_VERSION = $win2022_manifest.Descriptor.Platform.'os.version'
            Write-Host "WIN2022_VERSION: $WIN2022_VERSION"

            if([string]::IsNullOrWhiteSpace($WIN2019_VERSION) -or [string]::IsNullOrWhiteSpace($WIN2022_VERSION)) {
              throw "Could not establish OS versions for windows 2022 and 2019 needed for docker manifest"
            }

            echo "WIN2019_VERSION=$WIN2019_VERSION" >> $env:GITHUB_OUTPUT
            echo "WIN2022_VERSION=$WIN2022_VERSION" >> $env:GITHUB_OUTPUT

            Write-Host "We have everything we need, continuing."
            echo "CONTINUE=Yes" >> $env:GITHUB_OUTPUT
        }
      shell: powershell

  build-ubuntu:
    needs: [get-version-number]
    runs-on: ubuntu-latest

    steps:
    - uses: actions/checkout@v3    
    
    - name: DockerHub Login
      env:
        USERNAME: ${{ secrets.DOCKER_HUB_USER }}
        PASSWORD: ${{ secrets.DOCKER_HUB_PAT }}
      run: docker login --username $USERNAME --password "$PASSWORD"
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
    
    - name: Build the ubuntu.2004 image 
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker build ./ubuntu-2004 --tag octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-ubuntu.2004 --tag octopuslabs/flyway-enterprise-workertools:latest-ubuntu.2004 --build-arg FLYWAY_VERSION=$FLYWAY_VERSION_TO_BUILD
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the ubuntu.2004 version-specific image
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker push octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-ubuntu.2004
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the ubuntu.2004 latest image
      run: docker push octopuslabs/flyway-enterprise-workertools:latest-ubuntu.2004
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}

    - name: Build the ubuntu.2204 image      
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker build ./ubuntu-2204 --tag octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-ubuntu.2204 --tag octopuslabs/flyway-enterprise-workertools:latest-ubuntu.2204 --build-arg FLYWAY_VERSION=$FLYWAY_VERSION_TO_BUILD
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the ubuntu.2204 version-specific image
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker push octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-ubuntu.2204
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the ubuntu.2204 latest image
      run: docker push octopuslabs/flyway-enterprise-workertools:latest-ubuntu.2204
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
  build-win-2019:
    needs: [get-version-number]
    runs-on: windows-2019

    steps:
    - uses: actions/checkout@v3
        
    - name: DockerHub Login
      env:
        USERNAME: ${{ secrets.DOCKER_HUB_USER }}
        PASSWORD: ${{ secrets.DOCKER_HUB_PAT }}
      run: docker login --username ${env:USERNAME} --password "${env:PASSWORD}"
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
    
    - name: Build the win2019 image
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker build ./windows-2019 --tag octopuslabs/flyway-enterprise-workertools:${env:FLYWAY_VERSION_TO_BUILD}-windows.2019 --tag octopuslabs/flyway-enterprise-workertools:latest-windows.2019 --build-arg FLYWAY_VERSION=${env:FLYWAY_VERSION_TO_BUILD}
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the win2019 version-specific image
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker push octopuslabs/flyway-enterprise-workertools:${env:FLYWAY_VERSION_TO_BUILD}-windows.2019
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the win2019 latest image
      run: docker push octopuslabs/flyway-enterprise-workertools:latest-windows.2019
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}

  build-win-2022:
    needs: [get-version-number]
    runs-on: windows-2022

    steps:
    - uses: actions/checkout@v3
        
    - name: DockerHub Login
      env:
        USERNAME: ${{ secrets.DOCKER_HUB_USER }}
        PASSWORD: ${{ secrets.DOCKER_HUB_PAT }}
      run: docker login --username ${env:USERNAME} --password "${env:PASSWORD}"
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
    
    - name: Build the win2022 image
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker build ./windows-2022 --tag octopuslabs/flyway-enterprise-workertools:${env:FLYWAY_VERSION_TO_BUILD}-windows.2022 --tag octopuslabs/flyway-enterprise-workertools:latest-windows.2022 --build-arg FLYWAY_VERSION=${env:FLYWAY_VERSION_TO_BUILD}
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the win2022 version-specific image
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker push octopuslabs/flyway-enterprise-workertools:${env:FLYWAY_VERSION_TO_BUILD}-windows.2022
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push the win2022 latest image
      run: docker push octopuslabs/flyway-enterprise-workertools:latest-windows.2022
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
  
  build-docker-manifest:
    needs: [get-version-number, build-ubuntu, build-win-2019, build-win-2022]
    runs-on: ubuntu-latest
    
    steps:
    - name: DockerHub Login
      env:
        USERNAME: ${{ secrets.DOCKER_HUB_USER }}
        PASSWORD: ${{ secrets.DOCKER_HUB_PAT }}
      run: docker login --username $USERNAME --password "$PASSWORD"
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Create docker manifest for latest tag
      run: docker manifest create octopuslabs/flyway-enterprise-workertools:latest octopuslabs/flyway-enterprise-workertools:latest-windows.2019 octopuslabs/flyway-enterprise-workertools:latest-windows.2022 octopuslabs/flyway-enterprise-workertools:latest-ubuntu.2204
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}

    - name: Annotate docker manifest for latest tag
      env:
        WIN2019_VERSION: ${{ needs.get-version-number.outputs.WIN2019_VERSION }}
        WIN2022_VERSION: ${{ needs.get-version-number.outputs.WIN2022_VERSION }}
      run: |
       docker manifest annotate --os "windows" --os-version "$WIN2019_VERSION" --arch "amd64" "octopuslabs/flyway-enterprise-workertools:latest" "octopuslabs/flyway-enterprise-workertools:latest-windows.2019" && \
       docker manifest annotate --os "windows" --os-version "$WIN2022_VERSION" --arch "amd64" "octopuslabs/flyway-enterprise-workertools:latest" "octopuslabs/flyway-enterprise-workertools:latest-windows.2022"
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push docker manifest for latest tag
      run: docker manifest push octopuslabs/flyway-enterprise-workertools:latest
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Create docker manifest for version-specific tag
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}      
      run: docker manifest create octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-windows.2019 octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-windows.2022 octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-ubuntu.2204
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}

    - name: Annotate docker manifest for version-specific tag
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}      
        WIN2019_VERSION: ${{ needs.get-version-number.outputs.WIN2019_VERSION }}
        WIN2022_VERSION: ${{ needs.get-version-number.outputs.WIN2022_VERSION }}
      run: |
        docker manifest annotate --os "windows" --os-version "$WIN2019_VERSION" --arch "amd64" "octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD" "octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-windows.2019" && \
        docker manifest annotate --os "windows" --os-version "$WIN2022_VERSION" --arch "amd64" "octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD" "octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD-windows.2022"
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}
      
    - name: Push docker manifest for version-specific tag
      env:
        FLYWAY_VERSION_TO_BUILD: ${{ needs.get-version-number.outputs.FLYWAY_VERSION }}
      run: docker manifest push octopuslabs/flyway-enterprise-workertools:$FLYWAY_VERSION_TO_BUILD
      if: ${{ needs.get-version-number.outputs.CONTINUE == 'Yes' }}