PMM_PXC.yaml

name: PMM_PXC
on:
  workflow_dispatch:
    inputs:
      pxc_version:
        description: "pxc version, example: 8.0.33-25 Fetched from https://github.com/Percona-QA/package-testing/blob/master/VERSIONS"
        default: 'https://github.com/Percona-QA/package-testing/blob/master/VERSIONS'
        required: true
        type: string
      pxc_glibc:
        description: "pxc glibc version, example: 2.35"
        default: '2.35'
        required: true
      pmm_qa_branch:
        description: "Branch for qa-integration to checkout"
        required: false
        type: string
      pmm_ui_tests_branch:
        description: "Branch for PMM-UI tests to checkout"
        required: false
        type: string
      pmm_server_image:
        description: "pmm_image, example: perconalab/pmm-server:3-dev-latest"
        default: 'perconalab/pmm-server:3-dev-latest'
        required: false
        type: string
      pmm_client_version:
        description: 'PMM Client version (3-dev-latest|pmm3-rc|x.xx.x|https...)'
        default: '3-dev-latest'
        required: false
        type: string
  push:
    branches:
      - v3

  pull_request:
    branches:
      - v3

jobs:
  PMM_PXC_TEST:
    runs-on: ubuntu-latest
    timeout-minutes: 20
    env:
      ADMIN_PASSWORD: 'admin'
      PXC_VERSION: ${{ github.event.inputs.pxc_version || '8.0' }}
      PXC_GLIBC: ${{ github.event.inputs.pxc_glibc || '2.35' }}
      PMM_SERVER_IMAGE: ${{ github.event.inputs.pmm_server_image || 'perconalab/pmm-server:3-dev-latest' }}
      PMM_QA_BRANCH: ${{ github.event.inputs.pmm_qa_branch || 'v3' }}
      PMM_UI_BRANCH: ${{ github.event.inputs.pmm_ui_tests_branch || 'v3' }}
      PMM_CLIENT_VERSION: ${{ github.event.inputs.pmm_client_version || '3-dev-latest' }}

    steps:
    - uses: actions/checkout@v2

    - name: PXC_VERSION ENV Setup
      run: |
        if [[ "${{ github.event.inputs.pxc_version }}" != http* ]]; then
          PXC_VERSION="${{ github.event.inputs.pxc_version }}"
          PXC_VERSION_PATH=$(echo "pxc-$PXC_VERSION")
          PXC_VERSION_TRIMED=$(echo ${PXC_VERSION%-*})
        else
          wget https://raw.githubusercontent.com/Percona-QA/package-testing/master/VERSIONS
          PXC_VERSION="$(grep 'PXC80_VER' VERSIONS | cut -d = -f 2)"
          PXC_VERSION_PATH=$(echo "pxc-$PXC_VERSION.1")
          PXC_VERSION_TRIMED=$(echo ${PXC_VERSION%-*})
        fi
        echo "PXC_VERSION=${PXC_VERSION}"  | sed 's/"//g'  >> $GITHUB_ENV
        echo "PXC_VERSION_TAR=${PXC_VERSION}.1"  | sed 's/"//g' >> $GITHUB_ENV
        echo "PXC_VERSION_PATH=${PXC_VERSION_PATH}" >> $GITHUB_ENV
        echo "PXC_VERSION_TRIMED=${PXC_VERSION_TRIMED}" >> $GITHUB_ENV

    - name: Concatenate values to environment file
      run: |
        echo "PXC_TARBALL_PATH=https://downloads.percona.com/downloads/TESTING/${{env.PXC_VERSION_PATH}}/Percona-XtraDB-Cluster_${{env.PXC_VERSION_TAR}}_Linux.x86_64.glibc${{env.PXC_GLIBC}}.tar.gz" >> $GITHUB_ENV
        echo "PMM_QA_REPO_URL=https://github.com/percona/pmm-qa/" >> $GITHUB_ENV

    - name: Install Ansible and update the node
      run: sudo apt-get update -y && sudo apt-get install ansible -y

    - name: Run the PMM Server container
      run: docker run --detach --restart always -p 443:8443 -p 8081:8080 --name pmm-server ${{ env.PMM_SERVER_IMAGE }}

    - name: Checkout qa-integration repo
      uses: actions/checkout@v4
      with:
        ref: ${{ env.PMM_QA_BRANCH }}
        repository: Percona-Lab/qa-integration
        path: ./qa-integration

    - name: Export path to qa-integration repo
      working-directory: qa-integration
      run: echo "PATH_TO_PMM_QA=$(pwd)" >> $GITHUB_ENV

    - name: Run Setup for E2E Tests
      working-directory: qa-integration/pmm_qa
      run: |
        mkdir -m 777 -p /tmp/backup_data
        python3 -m venv virtenv
        . virtenv/bin/activate
        pip install --upgrade pip
        pip install -r requirements.txt
        if [[ "${{ github.event.inputs.pxc_version }}" != http* ]]; then
          python pmm-framework.py --verbose --pmm-server-password=${{ env.ADMIN_PASSWORD }} --client-version=${{ env.PMM_CLIENT_VERSION }} --database PXC=${{ env.PXC_VERSION }}
        else
          python pmm-framework.py --verbose --pmm-server-password=${{ env.ADMIN_PASSWORD }} --client-version=${{ env.PMM_CLIENT_VERSION }} --database PXC,TARBALL=${{ env.PXC_TARBALL_PATH }}
        fi

    - name: Checkout PMM UI tests
      uses: actions/checkout@v4
      with:
        ref: ${{ env.PMM_UI_BRANCH }}
        repository: percona/pmm-ui-tests
        path: ./pmm-ui-tests

    - name: Install npx dependencies
      run: npm ci && npx playwright install --with-deps && npx codeceptjs def pr.codecept.js
      working-directory: pmm-ui-tests

    - name: Run the Integration tests of PXC
      run: |
        export PMM_UI_URL="http://127.0.0.1:8081/" 
        npx codeceptjs run -c pr.codecept.js tests/qa-integration/pmm_pxc_integration_test.js --steps --debug
      working-directory: pmm-ui-tests