Refactor SQL agent #2636
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: tests | |
| on: | |
| push: | |
| branches: | |
| - main | |
| pull_request: | |
| branches: | |
| - "*" | |
| workflow_dispatch: | |
| inputs: | |
| target: | |
| description: "How much of the test suite to run" | |
| type: choice | |
| default: default | |
| options: | |
| - default | |
| - full | |
| - downstream | |
| cache: | |
| description: "Use cache" | |
| type: boolean | |
| default: true | |
| schedule: | |
| - cron: "0 17 * * SUN" | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }} | |
| cancel-in-progress: true | |
| defaults: | |
| run: | |
| shell: bash -e {0} | |
| env: | |
| DISPLAY: ":99.0" | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| COV: "--cov=./lumen --cov-report=xml" | |
| jobs: | |
| pre_commit: | |
| name: Run pre-commit | |
| needs: [setup] | |
| runs-on: "ubuntu-latest" | |
| steps: | |
| - uses: holoviz-dev/holoviz_tasks/pre-commit@v0 | |
| - uses: pre-commit/[email protected] | |
| if: needs.setup.outputs.img_change == 'true' | |
| with: | |
| extra_args: -a --hook-stage manual oxipng || true -- | |
| - uses: stefanzweifel/git-auto-commit-action@v4 | |
| if: needs.setup.outputs.img_change == 'true' | |
| with: | |
| commit_message: "Optimize PNG images (lossless)" | |
| file_pattern: "*.png" | |
| setup: | |
| name: Setup workflow | |
| runs-on: ubuntu-latest | |
| outputs: | |
| img_change: ${{ steps.filter.outputs.img }} | |
| matrix: ${{ env.MATRIX }} | |
| steps: | |
| - uses: actions/checkout@v4 | |
| if: github.event_name != 'pull_request' | |
| - name: Check for code changes | |
| uses: dorny/paths-filter@v3 | |
| id: filter | |
| with: | |
| filters: | | |
| img: | |
| - '**/*.png' | |
| - name: Set matrix option | |
| run: | | |
| if [[ '${{ github.event_name }}' == 'workflow_dispatch' ]]; then | |
| OPTION=${{ github.event.inputs.target }} | |
| elif [[ '${{ github.event_name }}' == 'schedule' ]]; then | |
| OPTION="full" | |
| elif [[ '${{ github.event_name }}' == 'push' && '${{ github.ref_type }}' == 'tag' ]]; then | |
| OPTION="full" | |
| else | |
| OPTION="default" | |
| fi | |
| echo "MATRIX_OPTION=$OPTION" >> $GITHUB_ENV | |
| - name: Set test matrix with 'default' option | |
| if: env.MATRIX_OPTION == 'default' | |
| run: | | |
| MATRIX=$(jq -nsc '{ | |
| "os": ["ubuntu-latest", "macos-latest", "windows-latest"], | |
| "environment": ["test-310", "test-312"] | |
| }') | |
| echo "MATRIX=$MATRIX" >> $GITHUB_ENV | |
| - name: Set test matrix with 'full' option | |
| if: env.MATRIX_OPTION == 'full' | |
| run: | | |
| MATRIX=$(jq -nsc '{ | |
| "os": ["ubuntu-latest", "macos-latest", "windows-latest"], | |
| "environment": ["test-310", "test-311", "test-312"] | |
| }') | |
| echo "MATRIX=$MATRIX" >> $GITHUB_ENV | |
| - name: Set test matrix with 'downstream' option | |
| if: env.MATRIX_OPTION == 'downstream' | |
| run: | | |
| MATRIX=$(jq -nsc '{ | |
| "os": ["ubuntu-latest"], | |
| "environment": ["test-311"] | |
| }') | |
| echo "MATRIX=$MATRIX" >> $GITHUB_ENV | |
| pixi_lock: | |
| name: Pixi lock | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: holoviz-dev/holoviz_tasks/pixi_lock@v0 | |
| with: | |
| cache: ${{ github.event.inputs.cache == 'true' || github.event.inputs.cache == '' }} | |
| unit_test_suite: | |
| name: unit:${{ matrix.environment }}:${{ matrix.os }} | |
| needs: [pre_commit, setup, pixi_lock] | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| fail-fast: false | |
| matrix: ${{ fromJson(needs.setup.outputs.matrix) }} | |
| timeout-minutes: 120 | |
| steps: | |
| - uses: holoviz-dev/holoviz_tasks/pixi_install@v0 | |
| with: | |
| environments: ${{ matrix.environment }} | |
| - name: Test Unit | |
| run: | | |
| pixi run -e ${{ matrix.environment }} test-unit $COV | |
| - uses: codecov/codecov-action@v4 | |
| with: | |
| token: ${{ secrets.CODECOV_TOKEN }} | |
| core_test_suite: | |
| name: core:${{ matrix.environment }}:${{ matrix.os }} | |
| needs: [pre_commit, setup, pixi_lock] | |
| runs-on: ${{ matrix.os }} | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| os: ["ubuntu-latest"] | |
| environment: ["test-core"] | |
| timeout-minutes: 120 | |
| steps: | |
| - uses: holoviz-dev/holoviz_tasks/pixi_install@v0 | |
| with: | |
| environments: ${{ matrix.environment }} | |
| - name: Test Unit | |
| run: | | |
| pixi run -e ${{ matrix.environment }} test-unit | |
| result_test_suite: | |
| name: result:test | |
| needs: [unit_test_suite, core_test_suite] | |
| if: always() | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: check for failures | |
| if: contains(needs.*.result, 'failure') || contains(needs.*.result, 'cancelled') | |
| run: echo job failed && exit 1 |