helm-posgresql.yml

name: helm-postgresql

on:
  workflow_dispatch:

env:
  K8S_NAMESPACE: helm

jobs:
  build:
    name: Build
    runs-on: ubuntu-latest
    strategy:
      matrix:
        java-version: [ 21 ]
    steps:
      - uses: actions/checkout@v3

      - name: Set up JDK
        uses: actions/setup-java@v3
        with:
          distribution: 'temurin'
          java-version: ${{matrix.java-version}}
          check-latest: true
          cache: 'maven'

      #- name: Install jbang
      #  run: |
      #    curl -Ls https://sh.jbang.dev | bash -s - app setup

      #- name: Kubernetes KinD Cluster
      #  uses: container-tools/kind-action@v1
      #  with:
      #    version: v0.11.1
      #    registry: true

      - name: Kubernetes KinD Cluster
        uses: helm/kind-action@v1
        with:
          registry: false
          #registry_name: my-registry
          #registry_port: 5001

      - name: Wait for Cluster Readiness
        run: |
          echo "Waiting for nodes to be ready..."
          kubectl wait --for=condition=Ready nodes --all --timeout=300s
          
          echo "Waiting for system pods to be ready..."
          kubectl wait --for=condition=Ready pods --all -n kube-system --timeout=300s
      
          echo "Cluster is ready!"
          
          echo "########### Cluster pods ##########"
          kubectl get pods -A
          
          echo "############ Wait for the pod to reach 'Ready' status ######"
          kubectl wait --for=condition=ready pod -l app=local-path-provisioner -n local-path-storage --timeout=60s
          
          echo "############ Check pods ######"
          kubectl get pods -A
          
      - name: Install helm 4
        run: |
          #sudo apt remove helm
          which helm
          curl -fsSL -o get_helm.sh https://raw.githubusercontent.com/helm/helm/main/scripts/get-helm-4
          chmod 700 get_helm.sh
          ./get_helm.sh
          helm version

      #- name: Change the storage class volumeBindingMode to immediate
      #  run: |
      #    kubectl get sc
      #    kubectl delete sc standard
      #    cat <<EOF | kubectl apply -f -
      #    apiVersion: storage.k8s.io/v1
      #    kind: StorageClass
      #    metadata:
      #      name: standard
      #      annotations:
      #        storageclass.kubernetes.io/is-default-class: "true"
      #    provisioner: rancher.io/local-path
      #    reclaimPolicy: Delete
      #    volumeBindingMode: Immediate
      #    EOF
      #    kubectl get sc

      - name: Install Postgresql helm chart
        run: |
          CHARTS=$(pwd)/.github/charts
          kubectl create namespace $K8S_NAMESPACE
          
          RELEASE_NAME=postgresql-db
          MAX_ATTEMPTS=20
          SLEEP_TIME=5
          
          cat <<EOF > values.yml
          postgresql:
            enabled: true
            global:
              postgresql:
                auth:
                  database: my_db_name
                  key: value
                  postgresPassword: secret
            primary:
              containerSecurityContext:
                enabled: false
              podSecurityContext:
                enabled: false
            volumePermissions:
              enabled: true
          EOF
          
          helm install $RELEASE_NAME $CHARTS/postgresql-18.2.4 -n $K8S_NAMESPACE -f values.yml
          helm status $RELEASE_NAME -n $K8S_NAMESPACE
  
          echo "Waiting for Helm release '$RELEASE_NAME' to be 'deployed'..."
          
          for ((i=1; i<=MAX_ATTEMPTS; i++)); do
            # -o json allows us to parse the status accurately with jq
            STATUS=$(helm status $RELEASE_NAME -n $K8S_NAMESPACE -o json | jq -r '.info.status')
             
            if [ "$STATUS" == "deployed" ]; then
              echo "✅ Success: Release is deployed."
              exit 0
            fi
   
            echo "Attempt $i/$MAX_ATTEMPTS: Current status is '$STATUS'. Waiting..."
            sleep $SLEEP_TIME
          done
          
          echo "::error::Timed out waiting for Helm release to deploy."
          helm status $RELEASE_NAME -n $K8S_NAMESPACE
          kubectl get events -n $K8S_NAMESPACE --sort-by='.lastTimestamp' | tail -n 10
          exit 1

      - name: Check postgresql pod
        run: |
          echo "########## Wait till Pod is running #########"
          kubectl wait -n $K8S_NAMESPACE --for=condition=ready pod/postgresql-db-0 --timeout=90s
          kubectl -n $K8S_NAMESPACE get pod/postgresql-db-0
          
          echo "########## Get PV #########"
          kubectl get pv
          
          echo "########## Get PVC #########"
          kubectl -n $K8S_NAMESPACE get pvc
          kubectl -n $K8S_NAMESPACE describe pvc/data-postgresql-db-0
          
          echo "########## Get Events #########"
          kubectl events -A
          
          echo "########## Get log #########"
          kubectl -n $K8S_NAMESPACE logs pod/postgresql-db-0