Java Real Time Interview Questions Selenium WebDriver

File upload in Selenium,Java,Robot Class

total-qa August 15, 2020 No Comments

File Upload is achieved using the Java API java.awt.Robot class where awt stands for Abstract window Toolkit.
1. Robot class in java mainly useful to generate native system input events for the purposes of test automations.
2. The primary usage of Robot class is to facilitate automated testing of Java platform implementations
Test Steps:
1. Open Chrome Browser.
2. Enter the URL https://www.zamzar.com/.
3. Click on the button -Add Files
4. Opens the window Dialog box
5. Enter the absolute path of the file : C:\SeleniumArtifacts\TestCaseData.xlsx
6. Click on Enter button in the keyboard.

Java Logic


package org.openqa.selenium.tests;

import java.awt.AWTException;
import java.awt.Robot;
import java.awt.Toolkit;
import java.awt.datatransfer.StringSelection;
import java.awt.event.KeyEvent;

import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import org.testng.annotations.Test;

public class FileUploadUsingRobot {

	WebDriver driver;
	@Test
	public void fileuploadTest() throws AWTException, InterruptedException  
	{
		System.setProperty("webdriver.chrome.driver", "chromedriver.exe");
		driver = new ChromeDriver();
		driver.get("https://www.zamzar.com/");
		driver.manage().window().maximize();
		driver.findElement(By.xpath("//button[@class='btn btn-default btn-lg']")).click();
		String fileAbsolutePath = "C:\\SeleniumArtifacts\\TestCaseData.xlsx";
		StringSelection clipBoardPath = new StringSelection(fileAbsolutePath);
		Toolkit.getDefaultToolkit().getSystemClipboard().setContents(clipBoardPath, null);
		
		Thread.sleep(5000);
		
		//Robot Class
		Robot robot = new Robot();
		
		//Keyboard Action : CTRL+V
		robot.keyPress(KeyEvent.VK_CONTROL);
		robot.keyPress(KeyEvent.VK_V);
		
		robot.keyRelease(KeyEvent.VK_CONTROL);
		robot.keyRelease(KeyEvent.VK_V);
		
		//Keyboard Action : Enter
		robot.keyPress(KeyEvent.VK_ENTER);
		robot.keyPress(KeyEvent.VK_ENTER);
		
			
		 
	}

}

package org.openqa.selenium.tests;

import java.awt.AWTException;

import java.awt.Robot;

import java.awt.Toolkit;

import java.awt.datatransfer.StringSelection;

import java.awt.event.KeyEvent;

import org.openqa.selenium.By;

import org.openqa.selenium.WebDriver;

import org.openqa.selenium.chrome.ChromeDriver;

import org.testng.annotations.Test;

public class FileUploadUsingRobot {

WebDriver driver;

@Test

public void fileuploadTest() throws AWTException, InterruptedException

{

System.setProperty("webdriver.chrome.driver", "chromedriver.exe");

driver = new ChromeDriver();

driver.get("https://www.zamzar.com/");

driver.manage().window().maximize();

driver.findElement(By.xpath("//button[@class='btn btn-default btn-lg']")).click();

String fileAbsolutePath = "C:\\SeleniumArtifacts\\TestCaseData.xlsx";

StringSelection clipBoardPath = new StringSelection(fileAbsolutePath);

Toolkit.getDefaultToolkit().getSystemClipboard().setContents(clipBoardPath, null);

Thread.sleep(5000);

//Robot Class

Robot robot = new Robot();

//Keyboard Action : CTRL+V

robot.keyPress(KeyEvent.VK_CONTROL);

robot.keyPress(KeyEvent.VK_V);

robot.keyRelease(KeyEvent.VK_CONTROL);

robot.keyRelease(KeyEvent.VK_V);

//Keyboard Action : Enter

robot.keyPress(KeyEvent.VK_ENTER);

}

Expected Result:
File is uploaded successfully

Keyboard Actions:
1. ctrl + v ->C:\SeleniumArtifacts\TestCaseData.xlsx
2. enter
Conclusion:
File Upload is achieved in Selenium Automation Tool using the Java API.

Loggers in Java,Selenium for Beginners

total-qa August 11, 2020 No Comments

A Logger object is used to log messages for a specific system or application component.
A Logger is useful to track the sequence of actions.
Each Logger has a “Level” associated with it. This reflects a minimum Level that this logger cares about.
The log level can be configured on the Logger.setLevel method.
Refer to the API Link for different levels.
Log Levels

SEVERE (highest value)
WARNING
INFO
CONFIG
FINE
FINER
FINEST (lowest value)
OFF
ALL

Logic


package total_qa_logger;

import java.io.File;
import java.io.IOException;
import java.util.logging.FileHandler;
import java.util.logging.Level;
import java.util.logging.Logger;
import java.util.logging.SimpleFormatter;
import java.util.logging.XMLFormatter;

public class LoggerExample {
	
	public static void main(String args[]) throws SecurityException, IOException
	{
		
		String logFilePath = new File(System.getProperty("user.dir"))+"/Logs/logs.txt";
		FileHandler handler = new FileHandler(logFilePath,false);//true append the logs , false it will override the logs
		Logger log = Logger.getLogger(logFilePath);
		log.addHandler(handler);
		handler.setFormatter(new XMLFormatter());
	    log.setLevel(Level.INFO);
	    
	    log.info("Browser Launched Successfully");
	    log.info("Validated Login Functionality");
	    
	    handler.setFormatter(new SimpleFormatter());
	    log.setLevel(Level.SEVERE);
	    log.severe("Browser Launched Successfully");
	    log.severe("Validated Login Functionality");
	}

}

package total_qa_logger;

import java.io.File;

import java.io.IOException;

import java.util.logging.FileHandler;

import java.util.logging.Level;

import java.util.logging.Logger;

import java.util.logging.SimpleFormatter;

import java.util.logging.XMLFormatter;

public class LoggerExample {

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

{

String logFilePath = new File(System.getProperty("user.dir"))+"/Logs/logs.txt";

FileHandler handler = new FileHandler(logFilePath,false);//true append the logs , false it will override the logs

Logger log = Logger.getLogger(logFilePath);

log.addHandler(handler);

handler.setFormatter(new XMLFormatter());

log.setLevel(Level.INFO);

log.info("Browser Launched Successfully");

log.info("Validated Login Functionality");

handler.setFormatter(new SimpleFormatter());

log.setLevel(Level.SEVERE);

log.severe("Browser Launched Successfully");

log.severe("Validated Login Functionality");

}

Conclusion:
Logging using a java.util.logging.Logger class is easy to implement in Java and Selenium automation projects.
OUTPUT:

java.util.logging.Logger

Write XLSX using Apache POI-Maven Project

total-qa August 10, 2020 No Comments

Apache POI (Poor Obfuscation Implementation File System) is the Java API for Microsoft Documents such as XLS,XLSX,DOC and PPT as well.
HSSF (Horrible Spreadsheet Format)
Read or write an Excel file format – XLS
XSSF (XML Spreadhsheet Format)
Read or write an Excel file format – XLSX
To download the Apache POI Library access the below link -> https://poi.apache.org/download.html
Download the Binary Distribution

Linux : poi-bin-xx.tar.gz
Windows : poi-bin-xx.zip

Writing the XLSX in JAVA project
1. Create JAVA Project
2. Add the dependencies of the Apache POI to the Build Path of the project.

Java Project – Build Path

3. Create a XLSX file with rows and columns

Xlsx File

4. Write the logic to write the data to the XLSX.


package total.qa.apache.poi.readxlsx;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * Write XLSX using Apache POI API
 * @author qa
 *
 */

public class WriteXLSX {
	public static void main(String args[]) throws IOException
	{
		File f = new File("TestCaseData.xlsx");
		FileInputStream fis = new FileInputStream(f);
		XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);
		XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);
		XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2
		cell.setCellType(CellType.STRING);
		cell.setCellValue("Pass");
		FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");
		excelWorkbook.write(fos);
		fos.close();
		fis.close();
		
		
		
	}

}

package total.qa.apache.poi.readxlsx;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**

* Write XLSX using Apache POI API

* @author qa

public class WriteXLSX {

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

{

File f = new File("TestCaseData.xlsx");

FileInputStream fis = new FileInputStream(f);

XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);

XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);

XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2

cell.setCellType(CellType.STRING);

cell.setCellValue("Pass");

FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");

excelWorkbook.write(fos);

fos.close();

fis.close();

}

Writing the XLSX in maven project
1. Create MAVEN Project
2. Add the following dependencies in the MAVEN pom.xml
https://mvnrepository.com/artifact/org.apache.poi/poi
https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml

Maven Dependency- Apache POI

3. Write the logic to write the data to the XLSX.


package total.qa.apache.poi.readxlsx;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * Write XLSX using Apache POI API
 * @author qa
 *
 */

public class WriteXLSX {
	public static void main(String args[]) throws IOException
	{
		File f = new File("TestCaseData.xlsx");
		FileInputStream fis = new FileInputStream(f);
		XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);
		XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);
		XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2
		cell.setCellType(CellType.STRING);
		cell.setCellValue("Pass");
		FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");
		excelWorkbook.write(fos);
		fos.close();
		fis.close();
		
		
		
	}

}

package total.qa.apache.poi.readxlsx;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import org.apache.poi.ss.usermodel.CellType;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**

* Write XLSX using Apache POI API

* @author qa

public class WriteXLSX {

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

{

File f = new File("TestCaseData.xlsx");

FileInputStream fis = new FileInputStream(f);

XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);

XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);

XSSFCell cell=excelSheet.getRow(0).createCell(2);//row index - 0,column index-2

cell.setCellType(CellType.STRING);

cell.setCellValue("Pass");

FileOutputStream fos = new FileOutputStream("TestCaseData.xlsx");

excelWorkbook.write(fos);

fos.close();

fis.close();

}

Conclusion:
Reading the XLSX is easy using the Apache POI and Java API.
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

Output

WriteExcel using Apache POI

Read XLSX using Apache POI – Maven Project

total-qa August 9, 2020 No Comments

Linux : poi-bin-xx.tar.gz
Windows : poi-bin-xx.zip

Reading the XLSX in JAVA project
1. Create JAVA Project
2. Add the dependencies of the Apache POI to the Build Path of the project.

Java Project – Build Path

3. Create a XLSX file with rows and columns

Xlsx File

4. Write the logic to read the data from XLSX.


package total.qa.apache.poi.readxlsx;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ReadXLSX {
	
	public static void main(String args[]) throws IOException
	{
		File f = new File("TestCaseData.xlsx");
		FileInputStream fis = new FileInputStream(f);
		XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);
		XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);
		int rows = excelSheet.getPhysicalNumberOfRows();//3
		int cols = excelSheet.getRow(0).getPhysicalNumberOfCells();//2
		String data[][]= new String[rows][cols];
		XSSFCell cell;
		for(int i =0 ; i< rows;i++)
		{
			for(int j=0;j<cols;j++)
			{
				cell = excelSheet.getRow(i).getCell(j);
				String cellContents=cell.getStringCellValue();
				data[i][j] = cellContents;
				System.out.println(data[i][j]);
			}
		}
		fis.close();	
	}
}

package total.qa.apache.poi.readxlsx;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadXLSX {

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

{

File f = new File("TestCaseData.xlsx");

FileInputStream fis = new FileInputStream(f);

XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);

XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);

int rows = excelSheet.getPhysicalNumberOfRows();//3

int cols = excelSheet.getRow(0).getPhysicalNumberOfCells();//2

String data[][]= new String[rows][cols];

XSSFCell cell;

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

{

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

{

cell = excelSheet.getRow(i).getCell(j);

String cellContents=cell.getStringCellValue();

data[i][j] = cellContents;

System.out.println(data[i][j]);

}

fis.close();

}

Reading the XLSX in maven project
1. Create MAVEN Project
2. Add the following dependencies in the MAVEN pom.xml
https://mvnrepository.com/artifact/org.apache.poi/poi
https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml

Maven Dependency- Apache POI

3. Write the logic to read the data from XLSX.


package total.qa.apache.poi.readxlsx;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ReadXLSX {
	
	public static void main(String args[]) throws IOException
	{
		File f = new File("TestCaseData.xlsx");
		FileInputStream fis = new FileInputStream(f);
		XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);
		XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);
		int rows = excelSheet.getPhysicalNumberOfRows();//3
		int cols = excelSheet.getRow(0).getPhysicalNumberOfCells();//2
		String data[][]= new String[rows][cols];
		XSSFCell cell;
		for(int i =0 ; i< rows;i++)
		{
			for(int j=0;j<cols;j++)
			{
				cell = excelSheet.getRow(i).getCell(j);
				String cellContents=cell.getStringCellValue();
				data[i][j] = cellContents;
				System.out.println(data[i][j]);
			}
		}
		fis.close();	
	}
}

package total.qa.apache.poi.readxlsx;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadXLSX {

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

{

File f = new File("TestCaseData.xlsx");

FileInputStream fis = new FileInputStream(f);

XSSFWorkbook excelWorkbook = new XSSFWorkbook(fis);

XSSFSheet excelSheet = excelWorkbook.getSheetAt(0);

int rows = excelSheet.getPhysicalNumberOfRows();//3

int cols = excelSheet.getRow(0).getPhysicalNumberOfCells();//2

String data[][]= new String[rows][cols];

XSSFCell cell;

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

{

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

{

cell = excelSheet.getRow(i).getCell(j);

String cellContents=cell.getStringCellValue();

data[i][j] = cellContents;

System.out.println(data[i][j]);

}

fis.close();

}

Conclusion:
Reading the XLSX is easy using the Apache POI and Java API.
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
Output

Output of the Program

Finding the Broken HyperLinks

total-qa July 4, 2020 No Comments

HyperLinks in HTML useful to navigate to another web-page.
HyperLinks are defined using the tag name-a using an attribute name href.
We need to define the Link text between the tag name to get the text displayed on the web-page.
Clicking on the link redirected to a new window or in the same window. This can be defined using an attribute target.

target=_self -> opens the web-page in the same window
target=_blank -> opens the web-page in a new window

Using Locators in Selenium WebDriver, we can automate the steps to click on the link to navigate to a page defined under the attribute href as defined below:
Link_Text

href =”http://total-qa.com” target=”_blank”
Scenario:
Is there any way to identify the broken links using Selenium WebDriver?

HTTP ERROR CODE : 404

The below logic helps in identifying the broken links.
Currently we are using WebDriverManager to instantiate the Driver Instance.


package org.totalqa;

import java.io.IOException;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.List;
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;
public class BrokenLinks {
	
	public static void main(String[] args) throws IOException {
		WebDriverManager.chromedriver().setup();
		WebDriver driver = new ChromeDriver();
		driver.get("http://www.total-qa.com/");
		List<WebElement> links = driver.findElements(By.tagName("a"));
		for(int i=0; i<links.size(); i++) {
			WebElement element = links.get(i);
			String url=element.getAttribute("href");
			URL link = new URL(url);
			HttpURLConnection con =(HttpURLConnection)link.openConnection();
			System.out.println(con.getResponseCode());
			if(con.getResponseCode()!= 200)
			{
				System.out.println("Response Code for Broken Link" +con.getResponseCode() );
				System.out.println("Broken Link  :: " + con.getURL());
			}
			else
			{
				System.out.println("Link is working fine :: " + con.getURL());
			 
			}
		}

	}

}

package org.totalqa;

import java.io.IOException;

import java.net.HttpURLConnection;

import java.net.URL;

import java.util.List;

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;

public class BrokenLinks {

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

WebDriverManager.chromedriver().setup();

WebDriver driver = new ChromeDriver();

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

List<WebElement> links = driver.findElements(By.tagName("a"));

for(int i=0; i<links.size(); i++) {

WebElement element = links.get(i);

String url=element.getAttribute("href");

URL link = new URL(url);

HttpURLConnection con =(HttpURLConnection)link.openConnection();

System.out.println(con.getResponseCode());

if(con.getResponseCode()!= 200)

{

System.out.println("Response Code for Broken Link" +con.getResponseCode() );

System.out.println("Broken Link :: " + con.getURL());

}

else

{

System.out.println("Link is working fine :: " + con.getURL());

}

Conclusion:
Broken links in a web-page are identified using Selenium and Java API.

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

Posts navigation

« Previous 1 2 3 4 … 10 Next »

Total-QA

Automation Tools

File upload in Selenium,Java,Robot Class

Loggers in Java,Selenium for Beginners

Write XLSX using Apache POI-Maven Project

Read XLSX using Apache POI – Maven Project

Finding the Broken HyperLinks

Prevent loading of stylesheets,images,subframes

Validate tabular data against Excel Data

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

Preconditions:

DataProvider Example using DataSource as MYSQL

Refer to the pom.xml details as mentioned below:

OUTPUT

@Test Attributes TimeOut,expectedExceptions,invocationCount Attributes in Testng

timeOut Attribute:

expectedExceptions Attribute:

invocationCount Attribute:

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

COPY Command:

XCOPY Command:

Xcopy Limitation:Insufficient Memory Error

ROBOCOPY Command:

Skipped Files:

RMDIR Command