Coverage workflow (knex/knex)

---
name: Coverage
 
on:
  push:
    branches:
      - master
  pull_request:
    branches:
      - master
 
permissions:
  contents: read
 
concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true
 
jobs:
  build:
    timeout-minutes: 30
    # skip on:
    #   - PRs labeled `skip-tests` (changes that can't affect runtime
    #     behaviour: docs, CI scripts, release tooling)
    #   - the auto-generated "release X.Y.Z" commit pushed by the
    #     release workflow (only changes lib/**, package.json, and
    #     changelogs; same source already tested on the parent commit)
    if: >-
      ${{
        !contains(github.event.pull_request.labels.*.name, 'skip-tests') &&
        !(github.actor == 'github-actions[bot]' && startsWith(github.event.head_commit.message, 'release '))
      }}
    env:
      DOCKERHUB_USERNAME: ${{ secrets.DOCKERHUB_USERNAME }}
    permissions:
      checks: write # for coverallsapp/github-action to create new checks
      contents: read # for actions/checkout to fetch code
    runs-on: latchkey-small
 
    name: Coverage
 
    strategy:
      fail-fast: false
      matrix:
        node-version: [22.x]
 
    steps:
      - name: Checkout Repository
        uses: actions/checkout@v6
        with:
          fetch-depth: 1
 
      - name: Setup Node ${{ matrix.node-version }}
        uses: actions/setup-node@v6
        with:
          cache: 'npm'
          always-auth: false
          package-manager-cache: false
          node-version: ${{ matrix.node-version }}
 
      - name: Login to Docker Hub
        uses: docker/login-action@v3
        with:
          username: ${{ secrets.DOCKERHUB_USERNAME }}
          password: ${{ secrets.DOCKERHUB_TOKEN }}
        if: env.DOCKERHUB_USERNAME != ''
 
      - name: Start Databases
        run: npm run db:start:no-oracle
 
      - name: Run npm install
        run: |
          n=0
          until npm install; do
            n=$((n + 1))
            if [ "$n" -ge 3 ]; then
              echo "npm install failed after $n attempts"
              exit 1
            fi
            echo "npm install failed, retrying in 15s... (attempt $n)"
            sleep 15
          done
 
      - name: Install pg-native
        run: npm i pg-native
 
      - run: npm run build
 
      - name: Run Tests
        run: npm run test:coverage  || true
        env:
          CI: true
          DB: 'postgres pgnative mysql mysql2 mariadb mssql sqlite3 cockroachdb'
          KNEX_TEST_TIMEOUT: 60000
 
      - name: Stop Databases
        run: npm run db:stop
 
      - name: Generate LCOV
        run: npx nyc report --reporter=lcov
 
      - name: Upload coverage reports to Codecov
        uses: codecov/codecov-action@v5
        with:
          token: ${{ secrets.CODECOV_TOKEN }}
          slug: knex/knex