feat: Python API and SQL Validator framework #1

	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

Provide feedback