btac.sa.lib

Class FilesAndFolders

java.lang.Object

btac.sa.lib.FilesAndFolders

public class FilesAndFolders
extends Object

The Class FilesAndFolders.

Field Summary

Fields

Modifier and Type	Field and Description
static org.openqa.selenium.WebDriver	driver The driver.

Constructor Summary

Constructors

Constructor and Description
FilesAndFolders(org.openqa.selenium.WebDriver driver) Instantiates a new files and folders.

Method Summary

Modifier and Type	Method and Description
static void	copyFile(File sourceFile, File destFile) Copy file from source to destination.
static void	downloadFileInIE(org.openqa.selenium.WebElement webElementOfDownloadLink) Download file in IE via Java Robot Library.
static boolean	fileExists(String fileNameWithPath) File exists.
static File[]	getAllFilesAndFolderNamesFromDir(String dirPath) Gets the all files and folder names from the given directory.
static List	getAllFilesAndFolderNamesFromDir(String dirPath, String fileNameContains) Gets the all files and folder containing a 'String' in the name, from the given directory.
static File	getLastModifiedFileFromDir(String dirPath) Gets the last modified file from given directory.
static String	getProjectRootPath() Gets the project root path.
static String	getPropValue(String key) Gets the property value for the key(passed as parameter) from the config.properties file located at project root
static String	getPropValue(String key, String filePath) Gets the property value for the key(passed as parameter) from the .properties file path specified
static jxl.Cell[]	readExcel(String sheetName, String uniqueValue) Reads a default excel file(located at: ./testdata/webTestData.xls) and returns the entire record for the uniqueValue specified from the sheetName specified.
static jxl.Cell[]	readExcel(String filePath, String sheetName, String uniqueValue) Reads an excel file(located at filePath passed as parameter) and returns the entire record for the uniqueValue specified from the sheetName specified.
static ArrayList	readExcelColumnFromKeywordOnwards(String sheetName, String keyWord) Read excel(located at default location:"./testdata/webTestData.xls") column from keyword onwards until it finds the empty cell.
static ArrayList	readExcelColumnFromKeywordOnwards(String fileNameWithPath, String sheetName, String keyWord) Read excel(located at custom location - filePath passed as parameter) column from keyword onwards until it finds the empty cell.
static ArrayList	readExcelColumnFromStart(String sheetName, int coulumnNo) Read excel(located at default location:"./testdata/webTestData.xls") column from start, until it finds the empty cell.
static ArrayList	readExcelColumnFromStart(String fileNameWithPath, String sheetName, int coulumnNo) Read excel(located at custom location - fileNameWithPath passed as parameter) column from start, until it finds the empty cell.
static jxl.Cell[]	readExcelNextRowOfUniqueValue(String sheetName, String uniqueValue) Reads an excel file(located at: ./testdata/webTestData.xls) and returns 1 specific record which is just below the uniqueValue specified in the sheetName(specified as parameter).
static jxl.Cell[]	readExcelNextRowOfUniqueValue(String filePath, String sheetName, String uniqueValue) Reads an excel file(located at filePath passed as parameter) and returns 1 specific record which is just below the uniqueValue specified in the sheetName(specified as parameter).
static void	setPropValue(String key, String value) Sets the property value for the Key(passed as parameter) in config.properties located at project root
static void	uploadAttachmentForWindowsViaJavaRobotLib(String filePathInProject) Upload attachment via java robot library for windows operating system.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

driver

public static org.openqa.selenium.WebDriver driver

The driver.

Constructor Detail

FilesAndFolders

public FilesAndFolders(org.openqa.selenium.WebDriver driver)

Instantiates a new files and folders.

Parameters:

driver - the driver

Method Detail

getPropValue

public static String getPropValue(String key)
                           throws Exception

Gets the property value for the key(passed as parameter) from the config.properties file located at project root

Parameters:

key - the key which exists in config.properties file

Returns:

the property value for the Key passed as parameter

Throws:

IOException - Signals that an I/O exception has occurred.

BadPaddingException

IllegalBlockSizeException

InvalidAlgorithmParameterException

NoSuchPaddingException

NoSuchAlgorithmException

InvalidKeyException

NumberFormatException

Exception

getPropValue

public static String getPropValue(String key,
                                  String filePath)
                           throws Exception

Gets the property value for the key(passed as parameter) from the .properties file path specified

Parameters:

key - the key which exists in .properties file specified

filePath - the file path for the .properties file. Ex: "./config.properties"

Returns:

the property value for the Key passed as parameter

Throws:

Exception - the exception

NumberFormatException - the number format exception

setPropValue

public static void setPropValue(String key,
                                String value)
                         throws IOException,
                                Exception

Sets the property value for the Key(passed as parameter) in config.properties located at project root

Parameters:

key - the key which exists in config.properties file

value - the value which you wish to assign to the key in config.properties file

Throws:

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcel

public static jxl.Cell[] readExcel(String sheetName,
                                   String uniqueValue)
                            throws jxl.read.biff.BiffException,
                                   IOException,
                                   Exception

Reads a default excel file(located at: ./testdata/webTestData.xls) and returns the entire record for the uniqueValue specified from the sheetName specified.

Parameters:

sheetName - the sheet name from which you wish to read and return a record

uniqueValue - the unique value for which the entire record(row) will be returned

Returns:

the cell[] array for the entire record(row)

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcel

public static jxl.Cell[] readExcel(String filePath,
                                   String sheetName,
                                   String uniqueValue)
                            throws jxl.read.biff.BiffException,
                                   IOException,
                                   Exception

Reads an excel file(located at filePath passed as parameter) and returns the entire record for the uniqueValue specified from the sheetName specified.

Parameters:

filePath - the file path Ex:"./testdata/webTestData.xls"

sheetName - the sheet name from which you wish to read and return a record

uniqueValue - the unique value for which the entire record(row) will be returned

Returns:

the cell[] array for the entire record(row)

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcelNextRowOfUniqueValue

public static jxl.Cell[] readExcelNextRowOfUniqueValue(String sheetName,
                                                       String uniqueValue)
                                                throws jxl.read.biff.BiffException,
                                                       IOException,
                                                       Exception

Reads an excel file(located at: ./testdata/webTestData.xls) and returns 1 specific record which is just below the uniqueValue specified in the sheetName(specified as parameter).

Parameters:

sheetName - the sheet name from which you wish to read and return a record

uniqueValue - the unique value for which the entire record(row) will be returned

Returns:

the cell[] array for the entire record(row) which is next to the uniqueValue

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcelNextRowOfUniqueValue

public static jxl.Cell[] readExcelNextRowOfUniqueValue(String filePath,
                                                       String sheetName,
                                                       String uniqueValue)
                                                throws jxl.read.biff.BiffException,
                                                       IOException,
                                                       Exception

Reads an excel file(located at filePath passed as parameter) and returns 1 specific record which is just below the uniqueValue specified in the sheetName(specified as parameter).

Parameters:

filePath - the file path Ex:"./testdata/webTestData.xls"

sheetName - the sheet name from which you wish to read and return a record

uniqueValue - the unique value for which the entire record(row) will be returned

Returns:

the cell[] array for the entire record(row) which is next to the uniqueValue

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcelColumnFromKeywordOnwards

public static ArrayList readExcelColumnFromKeywordOnwards(String sheetName,
                                                          String keyWord)
                                                   throws jxl.read.biff.BiffException,
                                                          IOException,
                                                          Exception

Read excel(located at default location:"./testdata/webTestData.xls") column from keyword onwards until it finds the empty cell.

Parameters:

sheetName - the sheet name

keyWord - the key word(next cell) from which you wish to get the data

Returns:

the array list

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcelColumnFromKeywordOnwards

public static ArrayList readExcelColumnFromKeywordOnwards(String fileNameWithPath,
                                                          String sheetName,
                                                          String keyWord)
                                                   throws jxl.read.biff.BiffException,
                                                          IOException,
                                                          Exception

Read excel(located at custom location - filePath passed as parameter) column from keyword onwards until it finds the empty cell.

Parameters:

fileNameWithPath - the file name with path. Ex:"./testdata/linkCheckerInputData.xls"

sheetName - the sheet name

keyWord - the key word(next cell) from which you wish to get the data

Returns:

the array list

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcelColumnFromStart

public static ArrayList readExcelColumnFromStart(String sheetName,
                                                 int coulumnNo)
                                          throws jxl.read.biff.BiffException,
                                                 IOException,
                                                 Exception

Read excel(located at default location:"./testdata/webTestData.xls") column from start, until it finds the empty cell.

Parameters:

sheetName - the sheet name from which column data is to be extracted

coulumnNo - the coulumn no. Index starts from 0 for Column A.

Returns:

the array list which contains data of entire column until empty cell is found

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

readExcelColumnFromStart

public static ArrayList readExcelColumnFromStart(String fileNameWithPath,
                                                 String sheetName,
                                                 int coulumnNo)
                                          throws jxl.read.biff.BiffException,
                                                 IOException,
                                                 Exception

Read excel(located at custom location - fileNameWithPath passed as parameter) column from start, until it finds the empty cell.

Parameters:

fileNameWithPath - the file name with path. Ex:"./testdata/linkCheckerInputData.xls"

sheetName - the sheet name from which column data is to be extracted

coulumnNo - the coulumn no. Index starts from 0 for Column A.

Returns:

the array list which contains data of entire column until empty cell is found

Throws:

jxl.read.biff.BiffException - the biff exception

IOException - Signals that an I/O exception has occurred.

Exception - the exception

copyFile

public static void copyFile(File sourceFile,
                            File destFile)
                     throws Exception

Copy file from source to destination.

Parameters:

sourceFile - the source file with path. Ex:"D:\\workspace\\BTAC_SeleniumAppiumLibrary\\testdata\\sample.docx"

destFile - the destination file with path. Ex:"D:\\workspace\\BTAC_SeleniumAppiumLibrary\\testdata\\sampleCopy.docx"

Throws:

Exception - the exception

getProjectRootPath

public static String getProjectRootPath()
                                 throws Exception

Gets the project root path.

Returns:

the project root path as a String. Ex:"D:\Softwares\workspacePersonal\BTAC_SeleniumAppiumLibrary"

Throws:

Exception

uploadAttachmentForWindowsViaJavaRobotLib

public static void uploadAttachmentForWindowsViaJavaRobotLib(String filePathInProject)
                                                      throws Exception

Upload attachment via java robot library for windows operating system. Sometimes Selenium API ".sendKeys("path")" doesn't work to upload a file. Hence we can use this API to paste the file path in a text box and then upload the file.

Parameters:

filePathInProject - the file path in project. Ex: "\\testdata\\webTestData.xls"

Throws:

Exception

downloadFileInIE

public static void downloadFileInIE(org.openqa.selenium.WebElement webElementOfDownloadLink)
                             throws Exception

Download file in IE via Java Robot Library.

Parameters:

webElementOfDownloadLink - the web element of download link

Throws:

Exception - the exception

getLastModifiedFileFromDir

public static File getLastModifiedFileFromDir(String dirPath)
                                       throws Exception

Gets the last modified file from given directory.

Parameters:

dirPath - the directory path. Ex:"D:\\Softwares\\workspacePersonal\\BTAC_SeleniumAppiumLibrary"

Returns:

the last modified file from given directory

Throws:

Exception

getAllFilesAndFolderNamesFromDir

public static File[] getAllFilesAndFolderNamesFromDir(String dirPath)
                                               throws Exception

Gets the all files and folder names from the given directory.

Parameters:

dirPath - the directory path. Ex:"D:\\Softwares\\workspacePersonal\\BTAC_SeleniumAppiumLibrary"

Returns:

all files and folder names from the given directory

Throws:

Exception - the exception

getAllFilesAndFolderNamesFromDir

public static List getAllFilesAndFolderNamesFromDir(String dirPath,
                                                    String fileNameContains)
                                             throws Exception

Gets the all files and folder containing a 'String' in the name, from the given directory.

Parameters:

dirPath - the directory path. Ex:"D:\\Softwares\\workspacePersonal\\BTAC_SeleniumAppiumLibrary"

fileNameContains - the string value which should be contained in all file names

Returns:

all files and folder names containing given 'string value' from the given directory

Throws:

Exception - the exception

fileExists

public static boolean fileExists(String fileNameWithPath)
                          throws Exception

File exists.

Parameters:

fileNameWithPath - the file name with path. Ex: System.getProperty("user.dir")+ "\\downloads\\abc.xls"

Returns:

true, if successful

Throws:

Exception