Skip to content

Build and Deploy Hanzo SQL #18

Build and Deploy Hanzo SQL

Build and Deploy Hanzo SQL #18

Workflow file for this run

name: Build and Deploy Hanzo SQL
on:
push:
branches: [master, main]
tags: ['v*']
paths:
- 'hanzo/**'
- 'Dockerfile'
- '.github/workflows/deploy.yml'
workflow_dispatch:
jobs:
build:
runs-on: ubuntu-latest
permissions:
contents: read
packages: write
steps:
- uses: actions/checkout@v4
- name: Set up Docker Buildx
uses: docker/setup-buildx-action@v3
- name: Log in to GHCR
uses: docker/login-action@v3
with:
registry: ghcr.io
username: ${{ github.actor }}
password: ${{ secrets.GH_PAT }}
- name: Log in to Docker Hub
uses: docker/login-action@v3
continue-on-error: true
with:
registry: docker.io
username: ${{ secrets.DOCKERHUB_USERNAME }}
password: ${{ secrets.DOCKERHUB_TOKEN }}
- name: Image metadata
id: meta
uses: docker/metadata-action@v5
with:
images: |
ghcr.io/hanzoai/sql
hanzoai/sql
tags: |
type=raw,value=latest,enable={{is_default_branch}}
type=raw,value=16,enable={{is_default_branch}}
type=sha,prefix=
type=semver,pattern={{version}}
type=semver,pattern={{major}}.{{minor}}
type=semver,pattern={{major}}
- name: Build and push
uses: docker/build-push-action@v5
with:
context: .
push: true
platforms: linux/amd64,linux/arm64
tags: ${{ steps.meta.outputs.tags }}
labels: ${{ steps.meta.outputs.labels }}
cache-from: type=gha,scope=sql
cache-to: type=gha,mode=max,scope=sql
deploy-hanzo:
needs: build
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
- name: Install doctl
uses: digitalocean/action-doctl@v2
with:
token: ${{ secrets.DIGITALOCEAN_ACCESS_TOKEN }}
- name: Configure kubectl (hanzo-k8s)
run: doctl kubernetes cluster kubeconfig save hanzo-k8s
- name: Rolling update sql
run: |
kubectl -n hanzo set image statefulset/sql \
sql=ghcr.io/hanzoai/sql:${GITHUB_SHA::7}
kubectl -n hanzo rollout status statefulset/sql --timeout=120s