Skip to main content

Selenium Function Library + File Handler

Here is my first attempt towards building Selenium Function Library. Here is a class which deals with File handling. Hence test data can be externalized in to notepad, excel, word pad instead of hard coding it in Selenium Scripts. So you can fetch test data using excel, csv etc and supply it to Selenium, more over you can execute same Selenium script for different set of data.

Java jars which I used here are jxl and Apache HSSF

/**
 * Performs read/write operations on files
 * 
 */
public class FileHandler {

 /**
  * Retrieves the data from the properties file using variable name.
  * 
  * @param path
  *            to Property file.
  * @param variableName
  *            stored in the properties file.
  * 
  * @return value of property
  * @throws Exception
  */

 public static String getDataFromPropertiesFile(String path,
   String variableName) throws Exception {
 }

 /**
  * Retrieves the Excel cell value based on the row and column number.
  * 
  * @param path
  * @param sheetNumber
  * @param rowNumber
  * @param col
  * @return cell value
  * @throws Exception
  */
 public static String readExcelData(String path, int sheetNumber,
   int rowNumber, int col) throws Exception {
 }

 /**
  * Writes the provided value to the Excel cell based on the row and column
  * number.
  * 
  * @param path
  * @param rowNumber
  * @param col
  * @param addDataToCell
  * @throws Exception
  */
 @SuppressWarnings("deprecation")
 public static void writeToExcel(String path, String sheetName,
   int rowNumber, int col, String addDataToCell) throws Exception {
 }

 /**
  * Retrieves single row data based on the row number
  * 
  * @param path
  * @param sheetNumber
  * @param rowNumber
  * @return cell values of a single row
  * @throws Exception
  */

 public static ArrayList getRowDataFromExcel(String path,
   int sheetNumber, int rowNumber, int startColNumber)
   throws Exception {
 }

 /**
  * Retrieves column data based on the row number
  * 
  * @param path
  * @param sheetNumber
  * @param colNumber
  * @param startRowNumber
  * @return cell values of a single column
  * @throws Exception
  */
 public static ArrayList getColumnDataFromExcel(String path,
   int sheetNumber, int colNumber, int startRowNumber)
   throws Exception {
 }

 /**
  * Provides the cell type of a cell whether its a Numeric, string,
  * blank cell etc.
  * 
  * @param cell
  * @return cell type based on the cell
  * @throws Exception
  */

 public static String cellToString(HSSFCell cell) throws Exception {
 }

 /**
  * Gets the columns in csv file
  * 
  * @param filePath
  * @return
  */
 public static List getColumns(String filePath) {
 }

 /**
  * 
  * Reads CSV data in to HashMap
  * 
  * @param project
  * @param filePath
  * @return
  */
 public static HashMap readcsv(String filePath) {
 }

 /**
  * Returns Data from the Notepad
  * 
  * @param path
  * 
  * 
  * @return data or null
  * @throws IOException
  */

 public static String readFromNotepad(String path) throws IOException {
 }

 /**
  * Writes the contents into Notepad.
  * 
  * @param path
  * @param text
  * @throws Exception
  */

 public static void writeContentsToNotepad(String path, String text)
 }

 /**
  * Retrieves contents from Word document
  * 
  * @param path
  * 
  * @return content or null
  * @throws Exception
  */
 public static String readFromWordDoc(String path) throws Exception {
 }

 /**
  * Writes the content to Word document.
  * 
  * @param path
  * @param addText
  * @throws Exception
  */
 public static void writeToWordDoc(String path, String addText)
 }
} 

Comments

  1. How can we know about these jar files. Here you have used jxl for excel. Like that can u pls gimme more info on that.

    ReplyDelete
  2. I mentioned it - "Java jars which I used here are jxl and Apache HSSF"

    ReplyDelete

Post a Comment

No spam only genuine comments :)

Popular posts from this blog

Distributed Load Testing with JMeter

Distributed Testing with JMeter When one JMeter client is not able to offer amount of threads required for load testing then distributed testing is used. In distributed testing - One instance of JMeter client can control number of JMeter instances and collect data from them Test plan does not need to be copied to each server, the client sends it to all servers note - JMeter will run all the threads on all the servers, hence 100 threads on 5 JMeter server would pump 500 threads in total. If many server instances are used, the client JMeter can become overloaded and so the client network connection. This has been improved in latest versions of JMeter by switching to Stripped modes, but you should always check that your client is not overloaded When Client (master) and Server (slave) nodes are on same network (no SSH required) Configure Client Node Herein client is referred as the machine controlling test execution on other JMeter nodes. This is also referred

Using chrome console to test xPath and css selectors

Since the advent of selenium there have been many plugin to test xPath / css selectors but you don’t need any of them if you have chrome browser. Using Chrome console you can test both xPath and css selectors. Launch website to be tested in chrome browser and hit F-12 and you would see chrome console opened in lower pane of application - Hit escape key and console would open another pane to write element locators - And now you can start writing xPath or css selectors in chrome console and test them - The syntax for writing css id - $$(“ ”) And hit the enter key. If your expression is right then html snippet of the application element corresponding to the css selector would be displayed - If you mouse over the html snippet in chrome console then it would highlight the corresponding element in application - If you want to clean console of previously written element selectors then just hit ctrl+L keys and chrome console would be empty again. Pro

XPath and single quotes

I had tough time dealing with XPath and single quote. Though W3C recommends using ' to escape it but I never got it working, let me know if any of you get through. Came across this blog and found that “concat” could be used in this situation. So original XPath expression is – //meta[@name=’DESCRIPTION’][@content=’Tester’s Test’] This is some thing which certainly fails as single quote in “Tester’s” marks it at end of string and then XPath blows up, next trial was – //meta[@name=’DESCRIPTION’][@content=’Tester''s Test’] This does not work despite w3c recommendation! And then I used concat function and split the string as – concat(‘Tester’,”’”,’s Test’) NOTICE that single quote is kept in double quote while other characters are kept in single quotes. So XPath looks as – //meta[@name=’DESCRIPTION’][@content=concat(‘Tester’,”’”,’s Test’)] And this works charm.