run_tests.yml

name: 🐘 Datamodel | Tests

concurrency:
  group: ${{ github.workflow }}-${{ github.event.pull_request.number || github.ref }}
  cancel-in-progress: true

on:
  push:
    branches:
      - master
    tags:
      - '*'
  pull_request:
    branches:
      - master

  release:
    types: ['prereleased', 'released']


jobs:

  run-tests:
    name: Run unit tests on datamodel
    runs-on: ubuntu-24.04

    services:
      postgres:
        image: postgis/postgis:15-3.5
        env:
          POSTGRES_DB: qwat_test
          POSTGRES_PASSWORD: postgres
        ports:
          - 5432:5432
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
    env:
      PGSERVICEFILE: ${{github.workspace}}/datamodel/tests/pg_service.conf

    steps:

      - uses: actions/checkout@v4

      - name: Install PostgreSQL client
        run: |
          sudo apt-get update
          sudo apt-get install --yes postgresql-client

      - name: Install Python dependencies
        run: pip install -r datamodel/requirements.txt

      - name: Grant execute permissions for tests.sh
        run: chmod +x datamodel/tests/tests.sh

      - name: Run tests
        run: datamodel/tests/tests.sh

      - name: Grant execute permissions for tests_scalability.sh
        run: chmod +x datamodel/tests/tests_scalability.sh

      - name: Run scalability tests
        run: datamodel/tests/tests_scalability.sh -i 20

      - name: Grant execute permissions for tests_scalability_multithread.sh
        run: chmod +x datamodel/tests/tests_scalability_multithread.sh

      - name: Run scalability tests multithreaded
        run: datamodel/tests/tests_scalability_multithread.sh -i 20

      - name: Grant execute permissions for tests_upgrade.sh
        run: chmod +x datamodel/tests/tests_upgrade.sh

      - name: Run upgrade tests
        run: datamodel/tests/tests_upgrade.sh