🚀 Hybrid QA Automation Framework (Python + Selenium + API + DB + CI/CD)

A production-style hybrid test automation framework built using Python, Selenium, PyTest, API testing, database validation, and CI/CD pipelines.

This framework demonstrates how modern QA systems validate applications across multiple layers:

• UI (Frontend)
• API (Backend services)
• Database (Data integrity)

---

🔗 Live Reports

• Allure Report: https://cyphermorgan.github.io/fullstack-qa-automation-framework/

🔥 Key Features

🖥️ UI Automation

• Selenium WebDriver
• Page Object Model (POM)
• Multi-browser support
• Screenshot capture on failure

🌐 API Testing

• Python-based API client
• Postman collection support
• Newman CLI execution
• API validation with structured logging

🗄️ Database Validation

• SQLite DB integration
• API vs DB validation tests
• Data integrity checks

🧪 Test Framework

• PyTest test runner
• Parametrized (data-driven) tests
• Retry mechanism for flaky tests
• Parallel execution (pytest-xdist)

📊 Reporting

• Allure Reports (rich UI)
• HTML reports
• Postman HTML reports

⚙️ Configuration Management

• YAML-based config system
• Environment support (dev, staging, etc.)
• CLI overrides (browser, env)

🧾 Logging

• Centralized logging system
• Logs for UI, API, DB layers

🚀 CI/CD Pipeline

• GitHub Actions integration
• Automated test execution
• Allure report deployment (GitHub Pages)
• Postman test execution via Newman

🧪 Mock API Server

• Built with FastAPI
• Ensures deterministic and reliable API tests

---

🧱 Project Structure

fullstack-qa-automation-framework
│
├── tests/
│   ├── ui/
│   ├── api/
│   └── db/
│
├── pages/
│
├── framework/
│   ├── core/
│   ├── api/
│   ├── db/
│   └── utils/
│
├── mock_server/
│
├── postman/
│
├── config/
│
├── reports/
├── screenshots/
├── logs/
│
├── conftest.py
├── pytest.ini
├── requirements.txt
└── README.md

---

🧠 Framework Architecture

UI Layer

Handles frontend automation using Selenium and Page Object Model.

API Layer

Handles backend validation using:

• Python API client
• Postman + Newman

DB Layer

Validates backend data using SQL queries.

Integration Layer

Combines:

• API responses
• Database data to validate consistency across systems.

---

▶️ Running Tests

🔹 Install dependencies

pip install -r requirements.txt

---

🔹 Run all tests

pytest tests --env=dev

---

🔹 Run with parallel execution

pytest tests -n 4

---

🔹 Run specific layer

pytest tests/ui
pytest tests/api
pytest tests/db

---

📊 Reporting

Allure Report

pytest --alluredir=allure-results
allure serve allure-results

👉 CI Report (GitHub Pages): https://cyphermorgan.github.io/fullstack-qa-automation-framework/

---

Postman (Newman)

newman run postman/Hybrid_QA_API.postman_collection.json

HTML report:

reports/postman_report.html

---

🧪 Mock API Server

Run locally:

uvicorn mock_server.app:app --reload

Base URL:

http://127.0.0.1:8000

---

🔄 CI/CD Pipeline

GitHub Actions automatically:

• Runs UI + API + DB tests
• Executes Postman collection
• Generates Allure report
• Deploys report to GitHub Pages

---

🔍 Example Test Flow

Start CI pipeline
    ↓
Start Mock API
    ↓
Run PyTest (UI + API + DB)
    ↓
Run Postman (Newman)
    ↓
Validate API ↔ DB consistency
    ↓
Generate Allure report
    ↓
Deploy report to GitHub Pages

---

🚀 What This Project Demonstrates

• Real-world QA automation architecture
• Multi-layer validation strategy
• CI/CD integration
• Clean, scalable framework design
• Strong debugging & reporting practices

---

🔮 Future Enhancements

• Docker containerization
• Cross-browser grid execution (Selenium Grid)
• Allure + Newman report integration
• Performance testing integration
• Cloud execution (BrowserStack / Sauce Labs)

---

👤 Author

Built as a hands-on project to simulate a real-world QA automation framework used in modern engineering teams.

---

⭐ If you like this project

Give it a ⭐ and feel free to fork & extend it!