scheduled-regression-clickhouse-latest.yml

name: 🗓 Scheduled ClickHouse latest
run-name: 🗓 Scheduled ClickHouse latest
on:
  workflow_dispatch:
  #Run At 00:00 (UTC) on Sunday, Tuesday, and Thursday
  schedule:
    - cron: "0 0 * * 6,2,4"

jobs:
  get_clickhouse_version:
    runs-on: [ self-hosted, x86, type-cpx41, image-x86-app-docker-ce ]
    outputs:
      version: ${{ steps.version.outputs.version }}
    steps:
      - name: Pull Docker image
        run: docker pull clickhouse/clickhouse-server:latest

      - name: Get version
        id: version
        run: |
          VERSION_LATEST=$(docker image inspect --format '{{json .}}' "clickhouse/clickhouse-server:latest" | jq -r '.Config.Labels."com.clickhouse.build.version" | ltrimstr("v") | split("-")[0]')
          echo "version=$VERSION_LATEST" >> "$GITHUB_OUTPUT"
          echo $VERSION_LATEST

  clickhouse-latest-x86-with-analyzer-zookeeper:
    needs: get_clickhouse_version
    uses: ./.github/workflows/reusable-workflow-x86.yml
    name: "x86-with-analyzer-${{ needs.get_clickhouse_version.outputs.version }}-alpine-zookeeper"
    with:
      package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      extra_args: '--with-analyzer'
      artifact_name: "clickhouse-latest-x86-with-analyzer-zookeeper"
    secrets: inherit

  clickhouse-latest-arm-with-analyzer-zookeeper:
    needs: get_clickhouse_version
    uses: ./.github/workflows/reusable-workflow-arm.yml
    name: "arm-with-analyzer-${{ needs.get_clickhouse_version.outputs.version }}-alpine-zookeeper"
    with:
      package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      extra_args: '--with-analyzer'
      artifact_name: "clickhouse-latest-arm-with-analyzer-zookeeper"
    secrets: inherit

  clickhouse-latest-x86-with-analyzer-keeper:
    needs: get_clickhouse_version
    uses: ./.github/workflows/reusable-workflow-x86.yml
    name: "x86-with-analyzer-${{ needs.get_clickhouse_version.outputs.version }}-alpine-keeper"
    with:
      package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      extra_args: '--with-analyzer --use-keeper'
      artifact_name: "clickhouse-latest-x86-with-analyzer-keeper"
    secrets: inherit

  clickhouse-latest-arm-with-analyzer-keeper:
    needs: get_clickhouse_version
    uses: ./.github/workflows/reusable-workflow-arm.yml
    name: "arm-with-analyzer-${{ needs.get_clickhouse_version.outputs.version }}-alpine-keeper"
    with:
      package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
      extra_args: '--with-analyzer --use-keeper'
      artifact_name: "clickhouse-latest-arm-with-analyzer-keeper"
    secrets: inherit