lth.yml

name: Liquibase Test Harness
on:
  workflow_dispatch:
  pull_request:
  push:
    branches:
      - main

# static value to the workflow group to ensure only one run of the workflow can be in progress at a time.
concurrency:
  group: liquibase-test-harness
  cancel-in-progress: false

jobs:
  liquibase-test-harness:
    name: Liquibase Test Harness
    runs-on: ubuntu-latest
    permissions:
      checks: write
      pull-requests: write
      contents: write
    env:
      TF_VAR_DBX_HOST: ${{ secrets.TH_DATABRICKS_WORKSPACE_HOST }}
      TF_VAR_DBX_TOKEN: ${{ secrets.TH_DATABRICKS_WORKSPACE_TOKEN }}
      TF_VAR_TEST_CATALOG: main
      TF_VAR_TEST_SCHEMA: liquibase_harness_test_ds
      WORKSPACE_ID: ${{ secrets.TH_DATABRICKS_WORKSPACE_ID }}
      LIQUIBOT_TOKEN: ${{ secrets.LIQUIBOT_PAT }}
      GITHUB_TOKEN: ${{ secrets.BOT_TOKEN }}
    strategy:
      max-parallel: 1
      matrix:
        liquibase-support-level: [Foundational, Contributed, Advanced] # Define the different test levels to run
      fail-fast: false # Set fail-fast to false to run all test levels even if some of them fail

    steps:
      - name: Checkout code
        uses: actions/checkout@v4

      - run: terraform init
        working-directory: src/test/terraform

      - run: terraform plan
        working-directory: src/test/terraform

      - run: |
          terraform import databricks_schema.test_harness main.liquibase_harness_test_ds || true
          terraform taint databricks_schema.test_harness || true
          terraform apply -auto-approve
        working-directory: src/test/terraform

      - name: Collect Databricks Config
        working-directory: src/test/terraform
        run: |
          CLUSTER_ID=$(terraform output -raw endpoint_url)
          DATABRICKS_HOST=${TF_VAR_DBX_HOST#https://}
          echo "DATABRICKS_URL=jdbc:databricks://$DATABRICKS_HOST:443/default;transportMode=http;ssl=1;httpPath=/sql/1.0/warehouses/$CLUSTER_ID;AuthMech=3;ConnCatalog=$TF_VAR_TEST_CATALOG;ConnSchema=$TF_VAR_TEST_SCHEMA;EnableArrow=0" >> "$GITHUB_ENV" 

      - name: Setup Temurin Java 17
        uses: actions/setup-java@v4
        with:
          java-version: 17
          distribution: temurin
          cache: 'maven'

      - name: maven-settings-xml-action
        uses: whelk-io/maven-settings-xml-action@v22
        with:
          repositories: |
            [
              {
                "id": "liquibase",
                "url": "https://maven.pkg.github.com/liquibase/liquibase",
                "releases": {
                  "enabled": "false"
                },
                "snapshots": {
                  "enabled": "true",
                  "updatePolicy": "always"
                }
              },
              {
                "id": "liquibase-pro",
                "url": "https://maven.pkg.github.com/liquibase/liquibase-pro",
                "releases": {
                  "enabled": "false"
                },
                "snapshots": {
                  "enabled": "true",
                  "updatePolicy": "always"
                }
              }
            ]
          servers: |
            [
              {
                "id": "liquibase-pro",
                "username": "liquibot",
                "password": "${{ secrets.LIQUIBOT_PAT }}"
              },
              {
                "id": "liquibase",
                "username": "liquibot",
                "password": "${{ secrets.LIQUIBOT_PAT }}"
              }
            ]

      - name: Build with Maven # Build the code with Maven (skip tests)
        run: mvn -B -ntp -Dmaven.test.skip package -Dliquibase.version=master-SNAPSHOT

      - name: Run ${{ matrix.liquibase-support-level }} Liquibase Test Harness # Run the Liquibase test harness at each test level
        if: always() # Run the action even if the previous steps fail
        run: mvn -B -ntp -DdbPassword=${{env.TF_VAR_DBX_TOKEN}} -DdbUrl='${{env.DATABRICKS_URL}}' -Dtest=liquibase.ext.databricks.${{ matrix.liquibase-support-level }}ExtensionHarnessTestSuite test -Dliquibase.version=master-SNAPSHOT # Run the Liquibase test harness at each test level

      - name: Test Reporter # Generate a test report using the Test Reporter action
        uses: dorny/test-reporter@v1.9.1
        if: always() # Run the action even if the previous steps fail
        with:
          name: Liquibase Test Harness - ${{ matrix.liquibase-support-level }} Reports # Set the name of the test report
          path: target/surefire-reports/TEST-*.xml # Set the path to the test report files
          reporter: java-junit # Set the reporter to use
          fail-on-error: false # Set fail-on-error to false to show report even if it has failed tests

      - name: Stop test database
        if: always() # Always destroy, even if the previous steps fail
        working-directory: src/test/terraform
        run: |
          set -e
          TERRAFORM_OUTPUT=$(terraform show -json)
          if [ -z "$TERRAFORM_OUTPUT" ]; then
            echo "Terraform output is empty. Skipping removal."
          else
            SCHEMA_EXISTS=$(echo $TERRAFORM_OUTPUT | jq -r '.values.root_module.resources[] | select(.address == "databricks_schema.test_harness") | .values.name')
            if [ "$SCHEMA_EXISTS" == "liquibase_harness_test_ds" ]; then
              terraform destroy -auto-approve
            else
              echo "Schema does not exist. Skipping removal."
            fi
          fi