action.yml

name: 'Teardown PostgreSQL Preview Schema'
description: 'Drops the PostgreSQL preview schema'
inputs:
  namespace:
    description: 'Kubernetes namespace'
    required: true
  preview-number:
    description: 'Preview number (PR number)'
    required: true
  configmap-name:
    description: 'Name of the ConfigMap containing database connection details'
    required: false
    default: 'app-spring-deployment-environments'
  secret-name:
    description: 'Name of the secret containing DB password'
    required: false
    default: 'app-secrets'
  postgres-image:
    description: 'PostgreSQL image to use'
    required: false
    default: 'postgres:18'
  db-host-key:
    description: 'Key for DB_HOST in ConfigMap'
    required: false
    default: 'DB_HOST'
  db-port-key:
    description: 'Key for DB_PORT in ConfigMap'
    required: false
    default: 'DB_PORT'
  db-name-key:
    description: 'Key for DB_NAME in ConfigMap'
    required: false
    default: 'DB_NAME'
  db-schema-key:
    description: 'Key for DB_SCHEMA in ConfigMap'
    required: false
    default: 'DB_SCHEMA'
  db-username-key:
    description: 'Key for DB_USERNAME in ConfigMap'
    required: false
    default: 'DB_USERNAME'
  db-password-key:
    description: 'Key for DB_PASSWORD in Secret'
    required: false
    default: 'DB_PASSWORD'

runs:
  using: "composite"
  steps:
    - name: Prepare teardown-schema job
      env:
        JOB_NAME: "drop-schema-preview-${{ inputs.preview-number }}"
        CONFIGMAP_NAME: "${{ inputs.configmap-name }}"
        SECRET_NAME: "${{ inputs.secret-name }}"
        PREVIEW_SCHEMA_NAME: "preview_${{ inputs.preview-number }}"
        POSTGRES_IMAGE: "${{ inputs.postgres-image }}"
        DB_HOST_KEY: "${{ inputs.db-host-key }}"
        DB_PORT_KEY: "${{ inputs.db-port-key }}"
        DB_NAME_KEY: "${{ inputs.db-name-key }}"
        DB_SCHEMA_KEY: "${{ inputs.db-schema-key }}"
        DB_USERNAME_KEY: "${{ inputs.db-username-key }}"
        DB_PASSWORD_KEY: "${{ inputs.db-password-key }}"
      run: |
        envsubst '
          $JOB_NAME
          $CONFIGMAP_NAME
          $SECRET_NAME
          $PREVIEW_SCHEMA_NAME
          $POSTGRES_IMAGE
          $DB_HOST_KEY
          $DB_PORT_KEY
          $DB_NAME_KEY
          $DB_SCHEMA_KEY
          $DB_USERNAME_KEY
          $DB_PASSWORD_KEY
        ' < ${{ github.action_path }}/job-template.yml > job-teardown-schema.yml

        echo "Prepared job manifest: job-teardown-schema.yml"
      shell: bash

    - name: Create teardown-schema job
      run: |
        kubectl apply --namespace ${{ inputs.namespace }} -f job-teardown-schema.yml
      shell: bash

    - name: Wait for teardown-schema job to complete
      env:
        JOB_NAME: "drop-schema-preview-${{ inputs.preview-number }}"
        NAMESPACE: "${{ inputs.namespace }}"
      run: |
        echo "Waiting for job $JOB_NAME in namespace $NAMESPACE..."
        
        if kubectl wait --namespace $NAMESPACE --for=condition=complete --timeout=60s job/$JOB_NAME; then
          echo "Job finished with status: Complete"
          kubectl logs job/$JOB_NAME --namespace $NAMESPACE
        elif kubectl wait --namespace $NAMESPACE --for=condition=failed --timeout=1s job/$JOB_NAME; then
          echo "Job finished with status: Failed"
          kubectl logs job/$JOB_NAME --namespace $NAMESPACE
          exit 1
        else
          echo "Timeout waiting for job to complete."
          kubectl logs job/$JOB_NAME --namespace $NAMESPACE || true
          exit 1
        fi
      shell: bash