SQL Query optimization is very important to run your project smoothly. By using these tips we can reduce the Query execution time, Unwanted DB calls and Queries, Reduce DB load. Query Optimization help to handle the Big data in your [...]
Apache POI is a Java API to read and write Documents in .xls and .xlsx formats. It contains classes and interfaces. An Apache POI library provides two implementations to read an excel file:Horrible Spreadsheet Format (HSSF) Implementation: It’s an API that [...]
When we write an automation framework one of the many challenges is to use test data in our test scripts. One way is to hardcode the test data in our test scripts but this approach is not extensible, what [...]
Query MethodsQuerySelector() method in HTML DOM is used to find the first HTML Element.This method function is similar to findElement() in selenium. Syntax: document.querySelector(selector)QuerySelectorAll() method in HTML DOM is used to return the list of HTML Elements.It can be accessed by [...]
What is ETL Testing? ETL Stands for Extraction, Transformation, and Load. So Basically ETL is a process of how data is load from the source system to the target systems. Firstly Data extracted from the database, transformed into a meaningful [...]
Prerequisites: SQLite, Java, Database What it covers?Creating and closing database connection (JDBC) Creating dynamic schema Creating a table and deleting table values Reading data from excel Importing excel data to DBHow does it work?To execute the SQL queries using java, we need to establish a [...]
Before executing the below code, confirm that pom is updated with the specified dependencies or add required jars to Java build path. We are using the Stopwatch of Apache Commons Lang to count the duration and reporter to log messages [...]
Prerequisites : -PHP 7.3 -Visual Studio CodeInstall slim via composer//run this command on terminal composer require slim/slim:”3.*”2. Install PHPUnit //run this command on terminal composer require-dev PHPUnit/PHPUnit ^7Now, PHPUnit is successfully installed you can see it in the demo/composer.json file and in the [...]
Installation:- Step1: Install the composer Step2: Install the Codeigniter 4 There are two ways to install the Codeigniter 4 Way 1: create-project codeigniter4/app starter codeigniter4POC Way 2: Visit the below link and download the Codeigniter 4 structure https://codeigniter.com/download Step3: run composer update from the project root terminal Step4: create [...]
In this blog, you will learn how to create a python function to read and fetch the data from an excel sheet and then call that function in your robot class. Task: Read Employee Name from the excel file whose [...]
© Copyright 2014. All Rights Reserved.
