Total-QA - Automation Tools

Prevent loading of stylesheets,images,subframes

total-qa June 27, 2020 No Comments

Web applications accessed using the web browser connects to the server and downloads all the HTML components including images,cascading style sheets – css, frames and iframes as well via HTTP requests. All these content is downloaded from Server via internet via HTTP requests. This results in time for loading the webpages.
IS there any possibility in preventing loading of web application contents??
The answer is Yes, it is possible using Selenium WebDriver tool which helps in preventing loading of HTML components.
They are three ways of loading the Page

EAGER
NORMAL
NONE

Preventing Page Loading

Page Loading Strategy: eager
Setting the Page Loading Strategy as eager, prevents loading of CSS,images and Subframes.


package totalqa;
import org.openqa.selenium.PageLoadStrategy;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import org.testng.annotations.Test;
import org.openqa.selenium.chrome.ChromeDriver;
public class EagerLoadStrategy {
	@Test
    public void pageloadStrategy() 
	{
        ChromeOptions chromeOptions = new ChromeOptions();
        chromeOptions.setPageLoadStrategy(PageLoadStrategy.NONE);
        WebDriver driver = new ChromeDriver(chromeOptions);
        driver.get("http://total-qa.com/");
        driver.quit();
       
    }
}

package totalqa;

import org.openqa.selenium.PageLoadStrategy;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.chrome.ChromeOptions;

import org.testng.annotations.Test;

import org.openqa.selenium.chrome.ChromeDriver;

public class EagerLoadStrategy {

@Test

public void pageloadStrategy()

{

ChromeOptions chromeOptions = new ChromeOptions();

chromeOptions.setPageLoadStrategy(PageLoadStrategy.NONE);

WebDriver driver = new ChromeDriver(chromeOptions);

driver.get("http://total-qa.com/");

driver.quit();

}

Refer to Time in milliseconds:

PageLoadingStrategy in Selenium WebDriver

Page Loading Strategy: normal
Setting the Page Loading Strategy as normal loads the CSS,images and Subframes as well. It loads all the components in the webpage.


package totalqa;
import org.openqa.selenium.PageLoadStrategy;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import org.testng.annotations.Test;
import org.openqa.selenium.chrome.ChromeDriver;
public class NormalLoadStrategy {
	@Test
    public void pageloadStrategy() 
	{
        ChromeOptions chromeOptions = new ChromeOptions();
        chromeOptions.setPageLoadStrategy(PageLoadStrategy.NORMAL);
        WebDriver driver = new ChromeDriver(chromeOptions);
        driver.get("http://total-qa.com/");
        driver.quit();
       
    }
}

package totalqa;

import org.openqa.selenium.PageLoadStrategy;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.chrome.ChromeOptions;

import org.testng.annotations.Test;

import org.openqa.selenium.chrome.ChromeDriver;

public class NormalLoadStrategy {

@Test

public void pageloadStrategy()

{

ChromeOptions chromeOptions = new ChromeOptions();

chromeOptions.setPageLoadStrategy(PageLoadStrategy.NORMAL);

WebDriver driver = new ChromeDriver(chromeOptions);

driver.get("http://total-qa.com/");

driver.quit();

}

Refer to Time in milliseconds:

PageLoadingStrategy in Selenium WebDriver

Page Loading Strategy: none
Setting the Page Loading Strategy as none waits until the initial page is loaded.


package totalqa;
import org.openqa.selenium.PageLoadStrategy;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeOptions;
import org.testng.annotations.Test;
import org.openqa.selenium.chrome.ChromeDriver;
public class NoneLoadStrategy {
	@Test
    public void pageloadStrategy() 
	{
        ChromeOptions chromeOptions = new ChromeOptions();
        chromeOptions.setPageLoadStrategy(PageLoadStrategy.NONE);
        WebDriver driver = new ChromeDriver(chromeOptions);
        driver.get("http://total-qa.com/");
        driver.quit();
       
    }
}

package totalqa;

import org.openqa.selenium.PageLoadStrategy;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.chrome.ChromeOptions;

import org.testng.annotations.Test;

import org.openqa.selenium.chrome.ChromeDriver;

public class NoneLoadStrategy {

@Test

public void pageloadStrategy()

{

ChromeOptions chromeOptions = new ChromeOptions();

chromeOptions.setPageLoadStrategy(PageLoadStrategy.NONE);

WebDriver driver = new ChromeDriver(chromeOptions);

driver.get("http://total-qa.com/");

driver.quit();

}

Refer to Time in milliseconds:

PageLoadingStrategy in Selenium WebDriver

Conclusion:
Preventing the web page from loading the html components is achieved using the Selenium WebDriver API.

Validate tabular data against Excel Data

total-qa June 20, 2020 No Comments

Map is a collection useful to store the things with a unique ID.Classes that implements Map are
HashTable,LinkedHashMap,HashMap,HashTable.
The HashMap is unsorted and unordered Map and useful to store the null key as well.In this post we will focus on using HashMap for storing the values from the Excel and storing the values in another HashMap by reading the values using the automation tools like Selenium WebDriver. Comparing the two HashMap and display the results.

Real Time Example Scenario
Validate the stock prices displayed in the Rediff.com website
1. Read the data in the XLS file.
2. Store the data in HashMap1.
3. Read the data using Selenium Webdriver.
4. Store the data in HashMap2.
5. Compare the values stored in the two HashMaps.
Store the data in the XLS in rows and columns as mentioned below:
HDFC Bank
1,031.35
SBI
184.45
Create a Maven Project in Eclipse
Add the following dependencies in the pom.xml


<dependency>
		<groupid>net.sourceforge.jexcelapi</groupid>
		<artifactid>jxl</artifactid>
		<version>2.6</version>
</dependency>
<dependency>
		<groupid>org.seleniumhq.selenium</groupid>
		<artifactid>selenium-java</artifactid>
		<version>3.141.59</version>
</dependency>
<dependency>
		<groupid>io.github.bonigarcia</groupid>
		<artifactid>webdrivermanager</artifactid>
		<version>3.6.2</version>
</dependency>

<groupid>net.sourceforge.jexcelapi</groupid>

</dependency>

<groupid>org.seleniumhq.selenium</groupid>

<artifactid>selenium-java</artifactid>

</dependency>

<groupid>io.github.bonigarcia</groupid>

<artifactid>webdrivermanager</artifactid>

</dependency>


package org.totalqa.seleniumexample;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Set;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
import io.github.bonigarcia.wdm.WebDriverManager;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
 
public class  HashMapSeleniumExample 
{
	public static HashMap<string,string> sharePriceExcelValuesfromXLS;
	public static HashMap<string,string> sharePriceExcelValuesfromWEB;

	public static void main(String args[]) throws BiffException, IOException
	{
		 
		sharePriceExcelValuesfromXLS = readXLSFile("SharePriceList.xls");
		sharePriceExcelValuesfromWEB = readDatafromWEB();
		 
//		  HashMap1 : Storing the values from WebPage
//		  HashMap2 : Storing the value from Excel
//		  Compare the values to validate the data
		  
		String expected = sharePriceExcelValuesfromXLS.get("Quess Corp");
		String actual   = sharePriceExcelValuesfromWEB.get("Quess Corp");

		if(actual.equals(expected))
		{
			System.out.println("TC Pass");
		}
		else
		{
			System.out.println("TC Fails");
		}

		Set<string> keyList = sharePriceExcelValuesfromXLS.keySet();
		for(String key : keyList)
		{
			System.out.println(key);
			if(sharePriceExcelValuesfromXLS.get(key).equals(sharePriceExcelValuesfromWEB.get(key)))
				System.out.println("Pass for the " + key);

			else
				System.out.println("Fail for the " + key);

		}
	}
	public static HashMap<string,string> readDatafromWEB()
	{
		WebDriverManager.chromedriver().setup();
		WebDriver driver = new ChromeDriver();
		driver.get("https://money.rediff.com/losers/bse/daily/groupa?src=gain_lose");
		List<webelement> currentPriceList = driver.findElements(By.xpath("//table[@class='dataTable']/tbody/tr/td[4]"));
		List<webelement> companyList = driver.findElements(By.xpath("//table[@class='dataTable']/tbody/tr/td[1]"));
		System.out.println("Size of the List ::" +currentPriceList.size() );
		HashMap<string,string> sharePriceExcelValuesfromWEB = new HashMap<string,string>();
		for(int i = 0 ;i <7;i++)
		{
			System.out.println("Key ::" +companyList.get(i).getText().trim()  +"Value ::"+currentPriceList.get(i).getText().trim() );
			sharePriceExcelValuesfromWEB.put(companyList.get(i).getText().trim(), currentPriceList.get(i).getText().trim());
		}
		return sharePriceExcelValuesfromWEB;

	}
	public static HashMap<string,string> readXLSFile(String fileName) throws IOException, BiffException
	{
		//Reading the data from XLS
		FileInputStream fis = new FileInputStream(new File(fileName));
		Workbook wb = Workbook.getWorkbook(fis);
		Sheet sheet = wb.getSheet(0);
		int rows = sheet.getRows();
		HashMap<string,string> sharePriceExcelValuesfromXLS = new HashMap<string,string>();
		for(int i = 0;i<rows;i=i+1) 
               { 
                      	Cell cell = sheet.getCell(0,i);
			String key = cell.getContents();

			cell  = sheet.getCell(1,i);
			String value= cell.getContents();

			System.out.print("Key  " + key);
			System.out.print("Value " + value);
			sharePriceExcelValuesfromXLS.put(key,value);
			System.out.println();
		}
		return sharePriceExcelValuesfromXLS;
	}

}
                                       
                             
 </string,string></string,string></string,string></string,string></string,string></webelement></webelement></string,string></string></string,string></string,string>

100

101

102

103

package org.totalqa.seleniumexample;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.util.HashMap;

import java.util.List;

import java.util.Set;

import org.openqa.selenium.By;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.WebElement;

import org.openqa.selenium.chrome.ChromeDriver;

import io.github.bonigarcia.wdm.WebDriverManager;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

public class HashMapSeleniumExample

{

public static HashMap<string,string> sharePriceExcelValuesfromXLS;

public static HashMap<string,string> sharePriceExcelValuesfromWEB;

public static void main(String args[]) throws BiffException, IOException

{

sharePriceExcelValuesfromXLS = readXLSFile("SharePriceList.xls");

sharePriceExcelValuesfromWEB = readDatafromWEB();

// HashMap1 : Storing the values from WebPage

// HashMap2 : Storing the value from Excel

// Compare the values to validate the data

String expected = sharePriceExcelValuesfromXLS.get("Quess Corp");

String actual = sharePriceExcelValuesfromWEB.get("Quess Corp");

if(actual.equals(expected))

{

System.out.println("TC Pass");

}

else

{

System.out.println("TC Fails");

}

Set<string> keyList = sharePriceExcelValuesfromXLS.keySet();

for(String key : keyList)

{

System.out.println(key);

if(sharePriceExcelValuesfromXLS.get(key).equals(sharePriceExcelValuesfromWEB.get(key)))

System.out.println("Pass for the " + key);

else

System.out.println("Fail for the " + key);

}

public static HashMap<string,string> readDatafromWEB()

{

WebDriverManager.chromedriver().setup();

WebDriver driver = new ChromeDriver();

driver.get("https://money.rediff.com/losers/bse/daily/groupa?src=gain_lose");

List<webelement> currentPriceList = driver.findElements(By.xpath("//table[@class='dataTable']/tbody/tr/td[4]"));

List<webelement> companyList = driver.findElements(By.xpath("//table[@class='dataTable']/tbody/tr/td[1]"));

System.out.println("Size of the List ::" +currentPriceList.size() );

HashMap<string,string> sharePriceExcelValuesfromWEB = new HashMap<string,string>();

for(int i = 0 ;i <7;i++)

{

System.out.println("Key ::" +companyList.get(i).getText().trim() +"Value ::"+currentPriceList.get(i).getText().trim() );

sharePriceExcelValuesfromWEB.put(companyList.get(i).getText().trim(), currentPriceList.get(i).getText().trim());

}

return sharePriceExcelValuesfromWEB;

}

public static HashMap<string,string> readXLSFile(String fileName) throws IOException, BiffException

{

//Reading the data from XLS

FileInputStream fis = new FileInputStream(new File(fileName));

Workbook wb = Workbook.getWorkbook(fis);

Sheet sheet = wb.getSheet(0);

int rows = sheet.getRows();

HashMap<string,string> sharePriceExcelValuesfromXLS = new HashMap<string,string>();

for(int i = 0;i<rows;i=i+1)

{

Cell cell = sheet.getCell(0,i);

String key = cell.getContents();

cell = sheet.getCell(1,i);

String value= cell.getContents();

System.out.print("Key " + key);

System.out.print("Value " + value);

sharePriceExcelValuesfromXLS.put(key,value);

System.out.println();

}

return sharePriceExcelValuesfromXLS;

}

</string,string></string,string></string,string></string,string></string,string></webelement></webelement></string,string></string></string,string></string,string>

Expected Result:
Comparison of HashMap is successful.

@DataProvider being a MySQL DataBase- JAVA,Selenium,Real time examples

total-qa September 14, 2019 No Comments

In TestNG we use the @DAtaProvider for passing the data values to the testcases. In majority of these cases the Data source used as an two dimensional Array,XLS or XLSX.
In this post we will look into the example where the Data source is MYSQL. For using the MYSQL to read the contents of the DB we have to use the following dependency in the maven pom.xml.
MYSQL Connector Dependency


<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.21</version>
</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

Preconditions:

Install MYSQL in the laptop. Refer to the

link

for more details on installation,configuration and examples on MYSQL.
Open Workbench and make sure the MYSQL server is started.

for more information on installation.

DataProvider Example using DataSource as MYSQL


package org.totalqa.util;

 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;

import com.mysql.jdbc.ResultSetMetaData;
 
public class ConnectionManager
{
	private static String url = "jdbc:mysql://localhost:3306/testDB";    
	private static String driverName = "com.mysql.jdbc.Driver";   
	private static String username = "root";   
	private static String password = "root";
	private static Connection con;
	private String[][] inputArr;
	/*
	 * 	<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.21</version>
		</dependency>
	 */
 
	public String[][]  readDB( ) 
	{
		try {
			Class.forName(driverName);
			try {
				//Create a connection to DB by passing Url,Username,Password as parameters
				con = DriverManager.getConnection(url, username, password);
				Statement stmt=con.createStatement();
				
				//Executing the Queries
				//stmt.executeUpdate("INSERT INTO testDB.employee VALUES ('john',2000)");
				//stmt.executeUpdate("truncate table testDB.employee");
				ResultSet rs = stmt.executeQuery("SELECT * FROM testDB.employee");
				rs.last();
				int rows = rs.getRow();
				 
				ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();
				int cols = rsmd.getColumnCount();
				System.out.println(rows +"--" + cols);
				inputArr= new String[rows][cols];
 
				int i =0;
				rs.beforeFirst();
				//Iterating the data in the Table
				while (rs.next())
				{
					for(int j=0;j<cols;j++)
					{
						inputArr[i][j]=rs.getString(j+1);
						System.out.print("values:: " + inputArr[i][j] +":::"+i +":::"+j); 
 
					}
					System.out.println();
					i++;
				}
			} catch (SQLException ex) {
				ex.printStackTrace();
				System.out.println("Failed to create the database connection."); 
			}
		} catch (ClassNotFoundException ex) {
			ex.printStackTrace();
			System.out.println("Driver not found."); 
		}
		return inputArr;
 
	}

	@DataProvider(name="DP")
	public String[][] feedDP()
	{
		String data[][]=readDB();
		for(int i=0;i<data.length;i++)
		{
			for(int j=0;j<data[i].length;j++)
			{
		 
				System.out.println("in for :: " + data[i][j]);
				 
			}
		}
		
		return data;
	}
	@Test(dataProvider="DP")
	public void login(String uname,String pword)
	{
		System.out.println("col1"+ uname);
		System.out.println("col2" + pword);
	}
	
  
}

100

101

102

103

package org.totalqa.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import org.testng.annotations.DataProvider;

import org.testng.annotations.Test;

import com.mysql.jdbc.ResultSetMetaData;

public class ConnectionManager

{

private static String url = "jdbc:mysql://localhost:3306/testDB";

private static String driverName = "com.mysql.jdbc.Driver";

private static String username = "root";

private static String password = "root";

private static Connection con;

private String[][] inputArr;

* <dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

public String[][] readDB( )

{

try {

Class.forName(driverName);

try {

//Create a connection to DB by passing Url,Username,Password as parameters

con = DriverManager.getConnection(url, username, password);

Statement stmt=con.createStatement();

//Executing the Queries

//stmt.executeUpdate("INSERT INTO testDB.employee VALUES ('john',2000)");

//stmt.executeUpdate("truncate table testDB.employee");

ResultSet rs = stmt.executeQuery("SELECT * FROM testDB.employee");

rs.last();

int rows = rs.getRow();

ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();

int cols = rsmd.getColumnCount();

System.out.println(rows +"--" + cols);

inputArr= new String[rows][cols];

int i =0;

rs.beforeFirst();

//Iterating the data in the Table

while (rs.next())

{

for(int j=0;j<cols;j++)

{

inputArr[i][j]=rs.getString(j+1);

System.out.print("values:: " + inputArr[i][j] +":::"+i +":::"+j);

}

System.out.println();

i++;

}

} catch (SQLException ex) {

ex.printStackTrace();

System.out.println("Failed to create the database connection.");

}

} catch (ClassNotFoundException ex) {

ex.printStackTrace();

System.out.println("Driver not found.");

}

return inputArr;

}

@DataProvider(name="DP")

public String[][] feedDP()

{

String data[][]=readDB();

for(int i=0;i<data.length;i++)

{

for(int j=0;j<data[i].length;j++)

{

System.out.println("in for :: " + data[i][j]);

}

return data;

}

@Test(dataProvider="DP")

public void login(String uname,String pword)

{

System.out.println("col1"+ uname);

System.out.println("col2" + pword);

}

Refer to the pom.xml details as mentioned below:


<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>org.iit.mmp</groupId>
	<artifactId>mmpmodule</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>mmpmodule</name>
	<url>http://maven.apache.org</url>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>
	<dependencies>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.17</version>
		</dependency>
		<dependency>
			<groupId>org.seleniumhq.selenium</groupId>
			<artifactId>selenium-java</artifactId>
			<version>3.141.59</version>
		</dependency>

		<dependency>
			<groupId>net.sourceforge.jexcelapi</groupId>
			<artifactId>jxl</artifactId>
			<version>2.6.12</version>
		</dependency>
		<dependency>
			<groupId>org.testng</groupId>
			<artifactId>testng</artifactId>
			<version>6.8</version>
		</dependency>
		<dependency>
			<groupId>io.github.bonigarcia</groupId>
			<artifactId>webdrivermanager</artifactId>
			<version>3.3.0</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.21</version>
		</dependency>
	</dependencies>
	<profiles>

		<profile>
			<id>QA</id>
			<build>
				<plugins>
					<plugin>
						<artifactId>maven-compiler-plugin</artifactId>
						<version>3.1</version>
						<configuration>
							<fork>true</fork>
							<executable>C:\Program Files\Java\jdk1.8.0_65\bin\javac.exe</executable>
						</configuration>
					</plugin>
					<plugin>
						<groupId>org.apache.maven.plugins</groupId>
						<artifactId>maven-surefire-plugin</artifactId>
						<version>3.0.0-M3</version>
						<configuration>
							<suiteXmlFiles>
								<suiteXmlFile>qa.xml</suiteXmlFile>
							</suiteXmlFiles>
						</configuration>
					</plugin>
				</plugins>
			</build>
		</profile>

		<profile>
			<id>DEV</id>
			<build>
				<plugins>
					<plugin>
						<artifactId>maven-compiler-plugin</artifactId>
						<version>3.1</version>
						<configuration>
							<fork>true</fork>
							<executable>C:\Program Files\Java\jdk1.8.0_65\bin\javac.exe</executable>
						</configuration>
					</plugin>
					<plugin>
						<groupId>org.apache.maven.plugins</groupId>
						<artifactId>maven-surefire-plugin</artifactId>
						<version>3.0.0-M3</version>
						<configuration>
							<suiteXmlFiles>
								<suiteXmlFile>dev.xml</suiteXmlFile>
							</suiteXmlFiles>
						</configuration>
					</plugin>
				</plugins>
			</build>

		</profile>
	</profiles>
</project>

100

101

102

103

104

105

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

<artifactId>mmpmodule</artifactId>

<version>0.0.1-SNAPSHOT</version>

<name>mmpmodule</name>

<url>http://maven.apache.org</url>

<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

</properties>

</dependency>

<groupId>org.seleniumhq.selenium</groupId>

<artifactId>selenium-java</artifactId>

</dependency>

<groupId>net.sourceforge.jexcelapi</groupId>

</dependency>

<groupId>org.testng</groupId>

<artifactId>testng</artifactId>

</dependency>

<groupId>io.github.bonigarcia</groupId>

<artifactId>webdrivermanager</artifactId>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

</dependencies>

<build>

<artifactId>maven-compiler-plugin</artifactId>

<executable>C:\Program Files\Java\jdk1.8.0_65\bin\javac.exe</executable>

</configuration>

</plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-surefire-plugin</artifactId>

</suiteXmlFiles>

</configuration>

</plugin>

</plugins>

</build>

</profile>

<build>

<artifactId>maven-compiler-plugin</artifactId>

<executable>C:\Program Files\Java\jdk1.8.0_65\bin\javac.exe</executable>

</configuration>

</plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-surefire-plugin</artifactId>

</suiteXmlFiles>

</configuration>

</plugin>

</plugins>

</build>

</profile>

</profiles>

</project>

OUTPUT

PASSED: login(“james”, “1000”)
PASSED: login(“john”, “2000”)

@Test Attributes TimeOut,expectedExceptions,invocationCount Attributes in Testng

total-qa July 6, 2019 No Comments

TestNG is a testing framework mainly used for unit testing of the Java projects. The Testng has pre-defined annotations and attributes associated with the annotations would help to verify the application accordingly as per the expected result. The following attributes are applied for @Test attribute

timeOut

expectedExceptions

invocationCount

timeOut Attribute:

The maximum number of milliseconds this test should take. If the execution time of the test case takes more than the timeOut value provided, the test case will Fail.

timeOut Attribute Example

import org.openqa.selenium.WebDriver; import org.openqa.selenium.firefox.FirefoxDriver; import org.testng.Assert; import org.testng.annotations.Test; public class TimeOutAttributeExample{ @Test(timeOut=25000) public void verifyTitle() { WebDriver driver = new FirefoxDriver(); driver.get("http://www.google.com"); String actual = driver.getTitle(); String expected="Google"; Assert.assertEquals(actual, expected,"Verifying the Title of Google Page"); } }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.Assert;
import org.testng.annotations.Test;

public class TimeOutAttributeExample{

@Test(timeOut=25000)
public void verifyTitle()
{
WebDriver driver = new FirefoxDriver();
driver.get("http://www.google.com");
String actual = driver.getTitle();
String expected="Google";
Assert.assertEquals(actual, expected,"Verifying the Title of Google Page");
}
}

timeOut,expectedExceptions Attribute

expectedExceptions Attribute:

The list of exceptions that a test method is expected to throw. If no exception or a different than one on this list is thrown, this test will be marked a failure.

expectedExceptions Attribute Example:

import org.testng.annotations.Test; public class ExpectedExceptionsAttributeExample{ @Test(expectedExceptions=NullPointerException.class) public void calculation() { int a =1; int b =0 ; int c =a/b; } }

1
2
3
4
5
6
7
8
9
10
11
12
13
14

import org.testng.annotations.Test;

public class ExpectedExceptionsAttributeExample{

@Test(expectedExceptions=NullPointerException.class)
public void calculation()
{
int a =1;
int b =0 ;
int c =a/b;
}
}

invocationCount Attribute:

The number of times this method should be invoked.

invocationCount Attribute Example

import org.openqa.selenium.WebDriver; import org.openqa.selenium.firefox.FirefoxDriver; import org.testng.Assert; import org.testng.annotations.Test; public class InvocationCountAttributeExample{ @Test(invocationCount =2) public void verifyTitle() { WebDriver driver = new FirefoxDriver(); driver.get("http://www.google.com"); String actual = driver.getTitle(); String expected="Google"; Assert.assertEquals(actual, expected,"Verifying the Title of Google Page"); } }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.Assert;
import org.testng.annotations.Test;

public class InvocationCountAttributeExample{

@Test(invocationCount =2)
public void verifyTitle()
{
WebDriver driver = new FirefoxDriver();
driver.get("http://www.google.com");
String actual = driver.getTitle();
String expected="Google";
Assert.assertEquals(actual, expected,"Verifying the Title of Google Page");
}
}

TESTNG expectedExceptions, invocationCount, timeOut

Copy,Xcopy,RoboCopy,RmDir Commands to copy and remove files and folders in Windows

total-qa    June 15, 2019 June 15, 2019    No Comments on Copy,Xcopy,RoboCopy,RmDir Commands to copy and remove files and folders in Windows

In this tutorial we will discuss about the commands to copy and remove the files and Directories in Windows with different options and examples.

COPY

XCOPY

ROBOCOPY

RMDIR

COPY Command:

copy command in windows copies the files from one directory to another directory. It also helps to combine files where multiple files as a source and single file as a destination.
Syntax:
COPY source destination COPY source1+source2 destination

Copy a file in the Current Folder:
copy abc.txt new_file.txt
Copy from a different folder to directory:
copy C:\Dir1\abc.txt C:\Dir2\new_file.txt

Copy Multiple Files as a Source and Single file as a destination:
copy file1.txt+file2.txt file3.txt

COPY,XCOPY,ROBOCOPY,RMDIR

XCOPY Command:

Copies the files and directories into another directory.
Syntax:
XCOPY source destination [options].

They are so many options available. We will see few of them which would be helpful

/S Copy folders and subfolders
xcopy C:\Dir1\Dir2 c:\Dir3 /S

/P Prompt before creating each file.

/C Continue copying if error occurs.

Xcopy Limitation:Insufficient Memory Error

Xcopy fails with an “insufficient memory” error when the path plus filename is longer than 254 characters. The alternative to Xcopy is Robocopy.

ROBOCOPY Command:

Its a Robust File and Folder Copy.
Syntax:
ROBOCOPY source_folder destination_folder [options]
They are so many options available. We will see few of them which would be helpful.
/E: Copy Subfolders, including Empty Folders

Skipped Files:

During the copy of files, some of the files which are empty are Skipped. To overcome this issue use the following Option.
/MIN:n : MINimum file size – exclude files smaller than n bytes.

Example:
ROBOCOPY source_folder destination_folder /E /MIN:0

RMDIR Command

Deletes files and folders.
Syntax:
RD path [options]

/S : Delete all files and subfolders

/Q : Quiet – do not display Y/N confirmation

Example:
Deletes the Folder dir2 and subfolders with-in the dir2 with out prompting the confirmation.
rmdir /S /Q C:\dir1\dir2

DevOps, Selenium    copy, insufficient memory, jenkins, rd, rmdir, robocopy, Windows, xcopy

Execute Selenium WebDriver Tests from Jenkins 2.0 Pipeline

total-qa    June 5, 2019 June 5, 2019    No Comments on Execute Selenium WebDriver Tests from Jenkins 2.0 Pipeline

Pipelines allows Jenkins to support continuous integration (CI) and Continous Delivery (CD). Pipeline are nothing but the Jenkins jobs the simple text scripts are based on Groovy Programming language. Pipeline terms such as “Step”, “Node” and “Stage” are subset of vocabulary using in Jenkins.

Step:
It defines the Single task which is part of the sequence tell Jenkins what to do.

Node:
A “node” means any computer that is part of your Jenkins installation.

Stage:
A “stage” is comprised of one or more build steps.

Pre-requisites:
Download Jenkins 2.0 from this link https://jenkins.io/download/ which is recommended.
Core Pipeline Plugin

Plugin Name – Pipeline:
In this tutorial we will learn about using Pipeline plugin and its usage.
It allows Jenkins to execute the Pipeline API and Basic Steps.
Download the Pipeline Plugin from this link https://wiki.jenkins.io/display/JENKINS/Pipeline+Plugin

SCM’s:
Git Plugin

Cloud Plugins{optional}:
Docker
ec2
Jenkins Environmental Variables:
echo “BUILD_NUMBER” :: $BUILD_NUMBER
echo “BUILD_ID” :: $BUILD_ID
echo “BUILD_DISPLAY_NAME” :: $BUILD_DISPLAY_NAME
echo “JOB_NAME” :: $JOB_NAME
echo “JOB_BASE_NAME” :: $JOB_BASE_NAME
echo “BUILD_TAG” :: $BUILD_TAG
echo “EXECUTOR_NUMBER” :: $EXECUTOR_NUMBER
echo “NODE_NAME” :: $NODE_NAME
echo “NODE_LABELS” :: $NODE_LABELS
echo “WORKSPACE” :: $WORKSPACE
echo “JENKINS_HOME” :: $JENKINS_HOME
echo “JENKINS_URL” :: $JENKINS_URL
echo “BUILD_URL” ::$BUILD_URL
echo “JOB_URL” :: $JOB_URL

Note:
Any of the Jenkins Environmental Variables are used in the Pipeline Script in the following way:
echo ${env.BUILD_NUMBER}

Creating a Simple Pipeline Script:

1. Open the Jenkins Home Page URL. Click on New Item in Jenkins home Page.

2. Provide the new item name. Select the Pipeline option. Click on OK button.

Jenkins Pipeline Script Example

3. Open the Jenkins job created in Step2. Click on Configure->Pipeline Syntax link to generate the Script automatically.

Pipeline Syntax Example

3. Create a Jenkinsfile with the pipeline script mentioned below:

Github Repository-> Link

pipeline { agent any stages { stage('Execute Selenium Tests from Github Repo Using Jenkins 2.0 Pipeline') { steps { echo 'Execute Tests' echo "Running ${env.BUILD_ID} on ${env.JENKINS_URL}" echo "Jenkins Workspace ${env.WORKSPACE}" bat "mvn -f openmrs clean" bat "mvn -f openmrs test -P QA" } } } } }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

pipeline {
  agent any
  stages {
    stage('Execute Selenium Tests from Github Repo Using Jenkins 2.0 Pipeline') {
      steps {
        echo 'Execute Tests'
        echo "Running ${env.BUILD_ID} on ${env.JENKINS_URL}"
        echo "Jenkins Workspace ${env.WORKSPACE}"
        bat "mvn -f openmrs clean"
        bat "mvn -f openmrs test -P QA"
      }
    }
  }
}
}

4. Configure the Jenkins job created in Step2. Refer to the Jenkinsfile from the Github Repository.

Jenkins Pipeline SCM Configuration

5. Click on Build Now to execute the Job Successfully.

6. Open the JOB Console to view the Results.

JenkinsfileExecution

DevOps    DevOPS, Groovy, Jenkins2.0, Pipeline, Script

Uploading the Sonarlint results to SonarQube[Cloud Server]

total-qa    June 4, 2019 June 5, 2019    No Comments on Uploading the Sonarlint results to SonarQube[Cloud Server]

Before getting into this tutorial please read the information about the Sonarlint by clicking on this link.
Sonarlint helps the developer analyzes the code quality on the fly and displays the scan results. Now the Question is, would it be possible to push these results to SonarQube.

What is SonarQube??

SonarQube provides the capability of displaying the results in a Dashboard. And it also helps to configure the Quality Gate to improve the Code Quality. If we want to publish the results from Sonarlint to SonarQube the code does not require any compilation. Once the code scans are done we can push the results directly into SonarQube.

Bind the Sonarlint to SonarQube:

Right click on the project in Eclipse Select Sonarlint->Bind to SonarQube to SonarCloud option as mentioned below:

Binding Sonarlint to SonarQube or SonarCloud

Select the connection type as SonarCloud and click on Next button.

SonarCloud Connection

Provide the Token generated from SonarCloud Server in the mentioned dialog box.

GenerateToken

Access the SonarCloud server URL https://sonarcloud.io/projects as mentioned below.
Click on Analyze new project button and

SonarCloudServer-Analyze New Projects

Provide all the required information and click onSet Up button.

AnalyzeProjects -SonarCloudServer

Click on the Generate button for generating new token.

GenerateToken

Run the analysis on your project.

Sonar Cloud – Run Analysis

Execute the Command from the Command line to push results of Sonarlint to the SonarQube Cloud.

mvn sonar:sonar \
-Dsonar.projectKey=SonarlintScanResults \
-Dsonar.organization=totalqa \
-Dsonar.host.url=https://sonarcloud.io \
-Dsonar.login=5a24ca7f4b56ccabd93da62f36915f08f8517482

Sonarlint-Scan Results

Conclusion

Results generated from Sonarlint are pushed into SonarQube Server Successfully.

DevOps    Analyze, SonarCloud, Sonarlint, SonarQube, StaticCodeChecks

Sonarlint-Instant Feedback Selenium,JAVA,Eclipse

total-qa    June 1, 2019 June 4, 2019    1 Comment on Sonarlint-Instant Feedback Selenium,JAVA,Eclipse

Sonarlint helps the developers to identify the issues on the fly when you write the code immediately. It helps to detect the common mistakes and vulnerabilities based on the thousands of rules in various languages such as Java,Javascript,PHP and PHP . It also helps to scan the source code in different IDE’s such as Eclipse IDE,Intellij IDEA,Visual Studio and VS Code. Please find the list of Sonarlint rules from the link mentioned below:

https://rules.sonarsource.com

Vulnerability Examples:

Its a weakness in the code, which can be exploited by an actor to perform unauthorized actions within a computer system.
“public static” fields should be constant:
Noncompliant Code Example:

Vulnerability|Noncompliant Code Example

public class TotalQA{ public static ClassA a1 = new ClassA(); }

1
2
3
4
5

public class TotalQA{

public static ClassA a1 = new ClassA();

}

Compliant Code Example:

Vulnerability|Compliant Code Example

public class TotalQA{ public static final ClassA a1 = new ClassA(); }

1
2
3

public class TotalQA{
public static final ClassA a1 = new ClassA();
}

Bug Example:

Loops should not be infinite:
Noncompliant Code Example:

Bug Example|Noncompliant Code Example

for (;;) { // Noncompliant; end condition omitted // ... }

1
2
3

for (;;) {  // Noncompliant; end condition omitted
  // ...
}

Code Smells:

Nothing but the violation of the Fundamental Design Principals.
Tests Should include Assertions:
Noncompliant Code Example:

Code Smells|Noncompliant Code Example

public void verityTitle() { WebDriver driver = new ChromeDriver(); driver.get("http://www.total-qa.com"); driver.getTitle(); }

1
2
3
4
5
6

public void verityTitle()
{
WebDriver driver = new ChromeDriver();
driver.get("http://www.total-qa.com");
driver.getTitle();
}

default Clauses should be last in the Switch Case

Code Smells|Noncompliant Code Example

switch (param) { case 0: break; default: error(); break; case 1: break; }

1
2
3
4
5
6
7
8
9

switch (param) {
  case 0:
    break;
  default:
    error();
    break;
  case 1:
    break;
}

Code Smells|Compliant Code Example

switch (param) { case 0: break; case 1: break; default: break; }

1
2
3
4
5
6
7
8

switch (param) {
  case 0:
    break;
  case 1:
    break;
   default:
    break;
}

Using Sonarlint in Eclipse:

Download the Sonarlint Plugin from the Eclipse Market Place. During the Development of the Code, the Sonarlint highlights the issues in the editor. It also gives the rule description on the the fly.Once the plugin is installed successfully. Open the Eclipse and write a sample program to verify the rules.
Sonarlint-Eclipse Marketplace

Analyze the Java Source Code using Sonarlint:

Sonarlint-Instant Code Scan

Click on the rule to view the Rule Description

Sonarlint:RuleDescription

Enable the rules in Sonarlint:
Navigate to the Window->Preferences->Sonarlint->Rules Configuration to select the rule configuration for different languages.

Sonarlint-Rules

SonarlintRules_Enable_Disable

Conclusion:

Sonarlint plugin in Eclipse enables the Developers to identify the issues early in the Coding phase to fix the issues during the time of development and fix them on the fly with Compliant Solution.

JAVA    Eclipse, InstantFeedback, Java, Sonarlint

Soft Asserts and Hard Asserts in TestNG

total-qa    May 12, 2019 May 12, 2019    No Comments on Soft Asserts and Hard Asserts in TestNG

TestNG is mainly used by the JAVA Developers to perform Unit Testing of the Code. This Framework is used mainly in Selenium as well to verify the outcome of the automation test Scenario. To verify the outcome the assert statements are available in the org.testng.Assert Class used such as

Assert.assertEquals

Assert.assertTrue

Assert.assertFalse

Assert.assertNotNull

.
They are different types of Assert types such as

Hard Assert

Soft Assert

Hard Assert:

In Hard Assert if the assertion is failing the execution stops.
Assert.assertTrue statement fails the test and stops the execution and makes the test case as failing.
Assert.assertFalse statement continues the test, if the element is not present in the Web Application.
Assert.assertFalse statement stops the execution of the test, if the element is present in the Web Application.

package org.totalqa.tests; import org.testng.Assert; import org.testng.annotations.Test; import org.openqa.selenium.chrome.ChromeDriver; import io.github.bonigarcia.wdm.WebDriverManager; public class Totalqa_HardAssert { ChromeDriver driver; @Test public void verifyTitle() { WebDriverManager.chromedriver().setup(); driver = new ChromeDriver(); driver.get("http://total-qa.com/"); String expected = "Total-QA - Future of Software Testing"; String actual = driver.getTitle(); Assert.assertEquals(actual, expected); } }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

package org.totalqa.tests;
import org.testng.Assert;
import org.testng.annotations.Test;
import org.openqa.selenium.chrome.ChromeDriver;
import io.github.bonigarcia.wdm.WebDriverManager;
public class Totalqa_HardAssert {

ChromeDriver driver;
@Test
public void verifyTitle() {

WebDriverManager.chromedriver().setup();
driver = new ChromeDriver();
driver.get("http://total-qa.com/");
String expected = "Total-QA - Future of Software Testing";
String actual =   driver.getTitle();
Assert.assertEquals(actual, expected);
}
}

Soft Assert:

In Soft Assert if the assertion is failed the execution doesn’t stops. The execution continues to the next step. The org.testng.asserts.SoftAssert object collects all the errors. If you need to throw an exception then you need to use the method assertAll() as the last statement in the @Test. And the execution continues to the next @Test.
assertAll fails the test case if any of the assertions are failed.

package org.totalqa.tests; import org.testng.Assert; import org.testng.annotations.Test; import org.openqa.selenium.chrome.ChromeDriver; import io.github.bonigarcia.wdm.WebDriverManager; public class Totalqa_SoftAssert { ChromeDriver driver; @Test public void verifyTitle() { WebDriverManager.chromedriver().setup(); driver = new ChromeDriver(); driver.get("http://total-qa.com/"); SoftAssert sa = new SoftAssert(); String expectedTitle = "Selenium QA"; String actualTitle = driver.getTitle(); //First Assertion actual is matching as expected //Assertion is failed, continue with the execution sa.assertEquals(actualTitle, expectedTitle); String expectedText ="Advanced Selenium"; String actualText = driver.findElement(By.linkText("Advanced Selenium")).getText(); sa.assertEquals(actualText, expectedText); //Its mandatory to call this statement //If any of the assertions are failed the Test case will fail sa.assertAll(); } }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

package org.totalqa.tests;
import org.testng.Assert;
import org.testng.annotations.Test;
import org.openqa.selenium.chrome.ChromeDriver;
import io.github.bonigarcia.wdm.WebDriverManager;

public class Totalqa_SoftAssert {

ChromeDriver driver;
@Test
public void verifyTitle() {

WebDriverManager.chromedriver().setup();
driver = new ChromeDriver();
driver.get("http://total-qa.com/");
SoftAssert sa = new SoftAssert();

String expectedTitle = "Selenium QA";
String actualTitle =   driver.getTitle();
//First Assertion actual is matching as expected
//Assertion is failed, continue with the execution
sa.assertEquals(actualTitle, expectedTitle);

String expectedText ="Advanced Selenium";
String actualText = driver.findElement(By.linkText("Advanced Selenium")).getText();
sa.assertEquals(actualText, expectedText);

//Its mandatory to call this statement
//If any of the assertions are failed the Test case will fail
sa.assertAll();
}
}

Summary

It’s important to decide what kind of Assertion is required.
If you want your assert method to fail and stops the execution use the Hard Assert.
If you want your assert method to fail and continues with the execution of the second assert and collect all the results at the end of the test use Soft Assert.

Selenium, TESTNG    assert, assertEquals, assertTrue, hard assert, soft assert

Enabling Writing Tests with in JIRA using Zephyr Plugin

total-qa    April 27, 2019 April 27, 2019    No Comments on Enabling Writing Tests with in JIRA using Zephyr Plugin

Follow this Atlassian Software-JIRA Registration Link to register for a free account for using JIRA. Click on the Link received in your email inbox to verify your email Address.This product is available in the Cloud, free for 7 days .
Login to JIRA by clicking on the Link received in the email.Click on Create Issue to view the Issue Types available. Currently issue types visible in JIRA by default are as follows: Story,EPIC,Task,Bug

JIRA Issue Types-Story,Epic,Task,Bug

To view the Test as Issue type in JIRA a plugin named Zephyr has to be installed.
Follow the Steps to enable the Zephyr plugin in JIRA. JIRA Settings->Apps->Find new Apps

Filter Apps in JIRA

Provide the name to filter the apps named by Zephyr.

ZephyrPlugin

Once the Zephyr plugin is successfully installed the issue Type Test is not visible in the Issue List.
Enabling Test to write Tests with in JIRA using Zephyr Plugin JIRA Settings->Issues->Issue type Schemas->Edit.
Drag and Drop the Issue Type Test from Available Issue Types to the section
Issue Types for Current Schema.

Test Issue Type in JIRA

Click on Save button to save the Issue type Schema.

Zephyr Test Issue

Verify the issue Test is visible in JIRA as mentioned below:

Issue Type Test

Testing    Atlassian, JIRA, Zephyr

Posts pagination

« Previous 1 2 3 4 5 … 10 Next »