test-eql.yml

name: "Test EQL"
on:
  push:
    branches:
      - main
    paths:
      - ".github/workflows/test-eql.yml"
      - "sql/*.sql"

  pull_request:
    branches:
      - main
    paths:
      - ".github/workflows/test-eql.yml"
      - "sql/*.sql"

  workflow_dispatch:

defaults:
  run:
    shell: bash -l {0}

jobs:
  test:
    name: "Test EQL SQL components"
    runs-on: ubuntu-latest-m

    strategy:
      fail-fast: false
      matrix:
        postgres-version: [17, 16, 15, 14]

    env:
      CS_DATABASE__NAME: test
      CS_DATABASE__PASSWORD:
      CS_DATABASE__PORT: 5532


    steps:
      - uses: actions/checkout@v4

      - uses: jdx/mise-action@v2
        with:
          version: 2025.1.0 # [default: latest] mise version to install
          install: true # [default: true] run `mise install`
          cache: true # [default: true] cache mise using GitHub's cache

      - uses: ankane/setup-postgres@v1
        with:
          postgres-version: ${{ matrix.postgres-version }}
          database: ${{ env.CS_DATABASE__NAME }}

      - name: Test EQL
        run: |
          mise run test