tests.yml

name: Tests

on: [push]

jobs:
  tests:

    strategy:
      fail-fast: false
      matrix:
        python-version: ["3.9", "3.10", "3.11"]
        os: [ubuntu-latest, windows-latest]
        exclude:
          - os: windows-latest
            python-version: "3.11"

    runs-on: ${{ matrix.os }}

    steps:

      - uses: actions/checkout@v4

      - name: Set up Python ${{ matrix.python-version }}
        uses: actions/setup-python@v5
        with:
          python-version: ${{ matrix.python-version }}

      - name: Install python dependencies
        run: |
          pip install --upgrade pip
          pip install -r requirements.txt
      
      - name: Set PYTHONPATH (Linux)
        if: matrix.os == 'ubuntu-latest'
        run: |
          parentdir="$(dirname `pwd`)";
          echo "PYTHONPATH=$parentdir:$PYTHONPATH" >> $GITHUB_ENV

      - name: Set PYTHONPATH (Windows)
        if: matrix.os == 'windows-latest'
        run: |
          $parentdir=(get-item (pwd) ).parent.FullName
          echo "PYTHONPATH=$parentdir" >> $env:GITHUB_ENV

      - name: Run unittests
        env:
          DB_READ_AND_WRITE_PASSWORD: ${{ secrets.DB_READ_AND_WRITE_PASSWORD }}
          DB_ENV: TEST
        run: |
          python -m unittest discover ./test

      - name: Check formatting
        run: |
          ruff format --check .

      - name: Check linting
        run: |
          ruff check .