testrail-backup.yml

name: TestRail Backup

on:
  workflow_dispatch:
  schedule:
    - cron: "0 15 * * *" # Run every day at 3pm

env:
  BUCKET: backups-testrail-test-suites
  DEFAULT_DIR: ./backup-tools
  PROJECT_IDS: 59 14 27 48
  # Fenix Browser: 59
  # Firefox for iOS: 14 
  # Focus for iOS: 27 
  # Focus for Android: 48
  STORAGE_URL_PREFIX: https://storage.googleapis.com

jobs:
  test:
    name: Backup test suites
    runs-on: ubuntu-24.04
    permissions:
      contents: write
    defaults:
      run:
        working-directory: ${{ env.DEFAULT_DIR }}

    env:
      TESTRAIL_HOST: ${{ secrets.TESTRAIL_HOST }}
      TESTRAIL_USERNAME: ${{ secrets.TESTRAIL_USERNAME }}
      TESTRAIL_PASSWORD: ${{ secrets.TESTRAIL_PASSWORD }}

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

      - name: Set up Python
        uses: actions/setup-python@v6
        with:
          python-version: 3.11

      - name: Install dependencies
        run: |
          pip install -r requirements.txt
          sudo apt-get install gnupg

      - name: Fetch test cases
        run: |
          python backup_testrail.py ${{ env.PROJECT_IDS }}

      - name: Create file listing
        run: |
          touch Listing.md
          echo "# Projects & Test Suites" >> Listing.md
          echo "" >> Listing.md
          echo "| Project | Test Suite | File |" >> Listing.md
          echo "|---------|------------|------|" >> Listing.md
          ls *.csv > files.txt
          awk -F '_' '{print "| " $2 " | " $3 " | `" $0 "` |"}' < files.txt >> Listing.md

      - name: Create gzip file containing csv and listing
        run: |
          today=`date "+%Y-%m-%d"`
          subdir=`openssl rand -hex 20`
          filename=$today-TestRail-backup

          mkdir $filename
          mv *.csv $filename
          mv Listing.md $filename
          cp README.md $filename
          tar -cvzf $filename.tgz $filename/*

          echo "filename=$filename" >> $GITHUB_ENV
          echo "subdir=$subdir" >> $GITHUB_ENV

      - name: Establish Google Cloud connection
        uses: google-github-actions/auth@v3
        with:
          credentials_json: ${{ secrets.GCLOUD_AUTH }}

      - name: Upload CSV files to GCP bucket
        id: upload-file
        uses: google-github-actions/upload-cloud-storage@v3
        with:
          path: ${{ env.DEFAULT_DIR }}/${{ env.filename }}.tgz
          destination: ${{ env.BUCKET }}/${{ env.subdir }}

      - name: Output URL to Github Actions summary
        run: |
          echo "[Download CSV files](${{ env.STORAGE_URL_PREFIX }}/${{ env.BUCKET }}/${{ steps.upload-file.outputs.uploaded }})" >> $GITHUB_STEP_SUMMARY
          echo "" >> $GITHUB_STEP_SUMMARY
          echo "Projects Included in the Backup" >> $GITHUB_STEP_SUMMARY
          cd $filename
          ls *.csv > files.txt
          awk -F '_' '{print "* " $2 }' < files.txt | uniq >> $GITHUB_STEP_SUMMARY

      - name: Output test case counts to Github Actions summary
        run: bash output-test-counts.sh test-counts.json slack-counts.json

      - name: Commit updated test counts
        run: |
          git config user.name "github-actions[bot]"
          git config user.email "github-actions[bot]@users.noreply.github.com"
          git add test-counts.json
          git diff --staged --quiet || git commit -m "Update test case counts [skip ci]"
          git push

      - name: Notify Slack - Test case counts
        uses: slackapi/slack-github-action@v3.0.2
        with:
          webhook: ${{ secrets.SLACK_WEBHOOK_URL_TEST_ALERTS_SANDBOX }}
          webhook-type: incoming-webhook
          payload-file-path: ${{ env.DEFAULT_DIR }}/slack-counts.json

      - name: Notify Slack (Fail)
        uses: slackapi/slack-github-action@v3.0.2
        if: ${{ failure() }}
        with:
          webhook: ${{ secrets.SLACK_WEBHOOK_MOBILE_ALERTS_TOOLING }}
          webhook-type: incoming-webhook
          payload-file-path: ${{ env.DEFAULT_DIR }}/slack-fail.json
          payload-templated: true
        env:
          server_url: ${{ github.server_url }}
          repository: ${{ github.repository }}
          run_id: ${{ github.run_id }}
          branch: ${{ github.ref_name }}