Hybrid Test Automation Framework

Built with Java, Selenium WebDriver, TestNG, Rest Assured, JDBC, Maven, Log4j2 & Extent Reports

---

Overview

This is an End-to-End Hybrid Test Automation Framework designed for comprehensive testing across UI, API, and Database layers of a web application.

The framework is developed using Java, Selenium, Rest Assured, JDBC, TestNG, Maven, and Log4j2, enabling teams to write, manage, and execute reliable automated test cases efficiently.

It supports UI, API, and Database validations, following best practices like Page Object Model (POM) and emphasizing modularity, scalability, and maintainability. With integrated logging, parallel execution, and rich HTML reporting, this framework offers a robust solution for automation testing and continuous integration pipelines.

---

Key Features

• End-to-End UI, API & DB Test Automation
• Modular and Scalable Architecture
• API Testing with Rest Assured for request/response validation
• Database Testing using JDBC for query execution and result validation
• Parallel Execution Support using TestNG and Maven Surefire
• Page Object Model (POM) design pattern for UI automation
• Data-Driven Testing with Excel, JSON, or Property files
• Cross-Environment Execution via configuration files
• Detailed Logging using Log4j2
• Rich HTML Reports (ExtentReports or Allure)
• CI/CD Integration Ready (Jenkins, GitHub Actions, etc.)

---

Tech Stack

Technology	Purpose
Java	Core programming language
Selenium	UI automation
Rest Assured	API testing
JDBC	Database testing and validation
TestNG	Test orchestration
Maven	Build and dependency management
Log4j2	Logging and debugging
Extent Reports	Rich HTML reporting

---

Getting Started

1. Clone the Repository:

   git clone https://github.com/aeshamangukiya/AutomationPractice.git
   # or
   git clone git@github.com:aeshamangukiya/AutomationPractice.git

2. Run Tests:

   mvn clean test

---

Project Structure

Click to expand

📁 src/
├── 📁 main/
│   ├── 📁 java/
│   │   ├── 📁 pageBase/
│   │   │   └── BasePage.java
│   │   ├── 📁 pageObjects/
│   │   │   ├── 📁 pages/
│   │   │   │   ├── 📁 accounts/
│   │   │   │   │   ├── LoginPage.java
│   │   │   │   │   └── ProfilePage.java
│   │   │   │   └── 📁 common/
│   │   │   │       └── Dashboard.java
│   │   ├── 📁 db/
│   │   │   ├── DatabaseConnectionManager.java
│   │   │   ├── DatabaseUtils.java
│   │   │   └── QueryBuilder.java
│   │   ├── 📁 utilities/
│   │   │   ├── ConfigReader.java
│   │   │   ├── WaitUtil.java
│   │   │   └── WebDriverUtil.java
│   │   ├── 📁 constants/
│   │   │   ├── FrameworkConstants.java
│   │   │   └── Messages.java
│   └── 📁 resources/
│       └── log4j2.xml

📁 test/
├── 📁 java/
│   ├── 📁 apiTests/
│   │   └── GetUsersAPITest.java
│   ├── 📁 dbtests/
│   │   ├── DatabaseAssertions.java
│   │   └── TS_DB_001_UserTableValidation.java
│   ├── 📁 data/providers/
│   │   └── DataProviderUtil.java
│   ├── 📁 testBase/
│   │   └── BaseTest.java
│   └── 📁 listeners/
│       ├── TestListener.java
│       └── ExtentReportListener.java
├── 📁 resources/
│   └── config.properties

📁 testXML/
└── testng.xml

📁 testData/
└── accounts/
    └── login/
        └── LoginTestData.xlsx

📁 reports/
└── ExtentReport.html

📁 screenshots/
└── LoginPage_YYYY_MM_DD_HH_MM_SS.png

📄 pom.xml
📄 README.md

---

Database Testing

1. Database Utility Classes

• DatabaseConnectionManager.java → Manages DB connections using constants
• DatabaseUtils.java → Execute queries & print results (TABLE, RAW, JSON, ROW)
• QueryBuilder.java → Centralized SQL query generator

2. Assertions

• DatabaseAssertions.java → Custom TestNG assertions for DB validation

3. Sample DB Test (TS_DB_001_UserTableValidation.java)

@Test(priority = 1)
public void TC_DB_001_VerifyUserExists() {
    String query = QueryBuilder.getUserById(1);
    List<Map<String, Object>> result = DatabaseUtils.executeQuery(query);

    DatabaseAssertions.assertNotEmpty(result, "User should exist in DB");
    DatabaseAssertions.assertRowCount(result, 1, "Expected exactly one user");
    DatabaseAssertions.assertColumnValue(result, "idemployee", "1", "User ID mismatch");
}

---

API Testing with Rest Assured

1. API test sample (GetUsersAPITest.java):

@Test
public void verifyGetUsersAPI() {
    given()
        .baseUri("https://reqres.in")
        .when()
        .get("/api/users?page=2")
        .then()
        .statusCode(200)
        .body("data", not(empty()));
}

---

2. Location:

test/java/tests/api/users/GetUsersAPITest.java

---

3. Extend with:

• JSON Schema validation
• Token authentication
• Data-driven APIs using Excel or JSON

---

Naming Conventions

Component	Convention	Example
Packages/Folders	camelCase	dbtests, dataProviders
Classes	PascalCase	ConfigReader.java, LoginTest.java
Methods/Vars	camelCase	getUserDetails(), isActive
Files	kebab-case	style.css
Assets	snake_case	asset_1.svg

---

Parallel Execution

Configure via testng.xml:

<suite name="RegressionSuite" parallel="methods" thread-count="5">

Use with Selenium Grid for remote browsers.

---

Reporting & Logging

• ExtentReports: Saved in /reports
• Screenshots: On failure in /screenshots
• Logs: Module-specific under /logs
• Log4j2: Config in resources/log4j2.xml

---

Retry & Listeners

• Retry failed tests using RetryAnalyzer
• Custom TestNG listeners: screenshots, logs, reports

---

Contact & Credits

• Maintained by: Aesha Mangukiya
• Email: aeshamangukiya1@gmail.com
• GitHub: GitHub: aeshamangukiya