release.yml

name: Generate query bundle and push release
on:
  workflow_dispatch:
  push:
    branches:
      - main

jobs:
  test:
    runs-on: ubuntu-latest

    steps:
    - uses: actions/checkout@v4
    - name: Set up Python 3.10
      uses: actions/setup-python@v3
      with:
        python-version: "3.10"
    - name: Install dependencies
      run: |
        python -m pip install --upgrade pip
        pip install -r requirements.txt

    - name: Test queries with pytest
      run: |
        pytest tests/test_cypher_syntax.py

    - name: Add test report to summary
      run: cat test-report.md >> $GITHUB_STEP_SUMMARY

    - name: Upload test report 
      uses: actions/upload-artifact@v4
      with:
        name: test-report
        path: test-report.md


  release:
    runs-on: ubuntu-latest
    needs: test
    steps:
      - uses: actions/checkout@v4
      - name: Set up Python 3.10
        uses: actions/setup-python@v3
        with:
          python-version: "3.10"
        
      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r requirements.txt
    
      - name: Convert queries into single zip file
        run: |
          python utilities/python/convert.py ./queries ./Queries.zip --file-format zip

      - name: Convert queries into single json file
        run: |
          python utilities/python/convert.py ./queries ./Queries.json
      
      - name: Set metadata
        id: release_meta
        run: |
          release_date="$(date -u +%Y-%m-%d)"
          echo "release_date=${release_date}" >> "$GITHUB_OUTPUT"
          echo "release_tag=queries-${release_date}" >> "$GITHUB_OUTPUT"
          echo "release_name=Queries ${release_date}" >> "$GITHUB_OUTPUT"
    
      - name: Create release
        uses: softprops/action-gh-release@v2
        with:
          tag_name: ${{ steps.release_meta.outputs.release_tag }}
          name: ${{ steps.release_meta.outputs.release_name }}
          files: |
            Queries.zip
            Queries.json
          body: | 
            This release contains all queries exported as JSON and bundled in a single file. The compressed .zip file can be uploaded to BloodHound to bulk-import all queries.
          draft: true