Skip to content

Scheduled ClickHouse latest #74

Scheduled ClickHouse latest

Scheduled ClickHouse latest #74

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:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
CHECKS_DATABASE_HOST: ${{ secrets.CHECKS_DATABASE_HOST }}
CHECKS_DATABASE_USER: ${{ secrets.CHECKS_DATABASE_USER }}
CHECKS_DATABASE_PASSWORD: ${{ secrets.CHECKS_DATABASE_PASSWORD }}
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:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
CHECKS_DATABASE_HOST: ${{ secrets.CHECKS_DATABASE_HOST }}
CHECKS_DATABASE_USER: ${{ secrets.CHECKS_DATABASE_USER }}
CHECKS_DATABASE_PASSWORD: ${{ secrets.CHECKS_DATABASE_PASSWORD }}
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:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
CHECKS_DATABASE_HOST: ${{ secrets.CHECKS_DATABASE_HOST }}
CHECKS_DATABASE_USER: ${{ secrets.CHECKS_DATABASE_USER }}
CHECKS_DATABASE_PASSWORD: ${{ secrets.CHECKS_DATABASE_PASSWORD }}
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:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
CHECKS_DATABASE_HOST: ${{ secrets.CHECKS_DATABASE_HOST }}
CHECKS_DATABASE_USER: ${{ secrets.CHECKS_DATABASE_USER }}
CHECKS_DATABASE_PASSWORD: ${{ secrets.CHECKS_DATABASE_PASSWORD }}