Project Architecture

  • Describe overall architecture:

    • Java (Core logic)

    • Selenium (UI automation)

    • Excel (Object Repository)

    • MS Access (Test case management)

    • JDBC (Connectivity)




Framework Components

Break it down by files/folders and explain the purpose:

Component
Description
ScenarioStepGenerator.java
Reads test steps from DB
ObjectRepo.xlsx
Stores element locators
RUNCHART table
Tracks execution
FUNC_MASTER, SUBFUNC_STEPS
Modular test step definitions
Apache POI
For Excel reading/writing
JDBC
For database interaction

Comments

Post a Comment

Popular posts from this blog

Beginner’s Guide to Setting Up Mobile Automation for Android

 Mobile automation has become a crucial part of modern software QA. With mobile apps used for banking, travel, e-commerce, education, and more, ensuring reliable performance on real devices is essential. This blog walks you through the core steps required to set up a mobile automation environment for Android , covering device configuration, tool setup, environment variables, and basic inspection techniques. 1. Install Java (JDK 8u111 Recommended) Mobile automation tools rely heavily on Java. Start by downloading: Java SE Development Kit (JDK 8u111) After installation, configure the environment variable: Set JAVA_HOME Open Environment Variables on your system. Under System Variables , click New . Add: JAVA_HOME = C:\Program Files\Java\jdk1.8.0_111 Edit the Path variable and add: %JAVA_HOME%\bin This ensures Java commands run globally on your machine. 2. Install Android Studio Android Studio includes the Android SDK , which is required for automation tools t...
Read more

Hybrid Framework Flow: Keyword + Data-Driven

Image
 Functional Regression Testing using a Hybrid Framework Combines Keyword-driven and Data-driven techniques. Likely built for Web UI automation. Breakdown: MS Access (RUNCHART Table) Test execution summary is stored in a table ( RUNCHART ). Fields like RUNID , SCN_ID , SCN_DESCRIPTION , EXECUTED_BY , etc. Tags like Regression and execution status are tracked. Indicates test case execution tracking and reporting is handled through MS Access database . Java Code (Eclipse – ScenarioStepGenerator.java ) Code is preparing and executing SQL queries to fetch test scenario steps. Interacts with tables like SCN_FUNC_BATCHING and SCN_STEPS_AUTOMATION . Implements logic to insert/update test steps dynamically. Core automation engine is Java-based and fetches test steps dynamically using scenario IDs . JDBC is used for database connection and query execution.   Excel (Object Repository) Excel file ( iDataSyncr ) is used as UI Object Repository . Fields...
Read more

Which Framework is Best: Data-Driven or Keyword-Driven?

  Keyword-Driven Framework Best for teams with mixed skill levels (non-coders + testers). Easier to maintain in the long run. Ideal when application changes often —you only update keywords, not scripts. Needs more time and effort to set up initially. Data-Driven Framework Best when test data changes frequently but test logic stays the same. Suitable if your team is comfortable with coding . Less complex than keyword-driven but harder for non-programmers to contribute. ✅ When to Choose What Scenario Recommended Framework Team has non-programmers Keyword-Driven Frequent data changes Data-Driven Need long-term maintainability Keyword-Driven Small team with coding skills Data-Driven Application updates often Keyword-Driven
Read more