ci.yml

name: QA Validator CI Pipeline

on:
  push:
    branches: [ "main" ]
  pull_request:
    branches: [ "main" ]

jobs:
  python-api-sql-tests:
    runs-on: ubuntu-latest
    name: Python API & SQL Tests
    steps:
      - name: Checkout code
        uses: actions/checkout@v3

      - name: Set up Python
        uses: actions/setup-python@v4
        with:
          python-version: '3.11'

      - name: Install Python dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r tests/python/requirements.txt

      - name: Start API and Database (Docker Compose)
        run: docker compose up -d --build

      - name: Wait for API to be ready
        run: |
          while ! curl -s http://localhost:8000/docs > /dev/null; do
            echo "Waiting for API..."
            sleep 2
          done

      - name: Run Pytest
        run: pytest tests/python/ -v

      - name: Tear down Docker Compose
        if: always()
        run: docker compose down -v

  postman-newman-tests:
    runs-on: ubuntu-latest
    name: Postman Zero Code Tests
    steps:
      - name: Checkout code
        uses: actions/checkout@v3

      - name: Start API and Database (Docker Compose)
        run: docker compose up -d --build

      - name: Wait for API to be ready
        run: |
          while ! curl -s http://localhost:8000/docs > /dev/null; do
            echo "Waiting for API..."
            sleep 2
          done

      - name: Install Node.js
        uses: actions/setup-node@v3
        with:
          node-version: '18'

      - name: Install Newman
        run: npm install -g newman

      - name: Run Newman Tests
        run: newman run tests/postman/postman_collection.json -e tests/postman/postman_environment.json --reporters cli

      - name: Tear down Docker Compose
        if: always()
        run: docker compose down -v