How to use DataLoadingException class of com.qaprosoft.carina.core.foundation.exception package

...28import org.apache.poi.xssf.model.ExternalLinksTable;29import org.apache.poi.xssf.usermodel.XSSFSheet;30import org.apache.poi.xssf.usermodel.XSSFTable;31import org.apache.poi.xssf.usermodel.XSSFWorkbook;32import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;33import com.qaprosoft.carina.core.foundation.exception.InvalidArgsException;34public class XLSParser35{36	protected static final Logger LOGGER = Logger.getLogger(XLSParser.class);37	private static DataFormatter df;38	private static FormulaEvaluator evaluator;	39	40	static 41	{42		df = new DataFormatter();43	}44	45	public static String parseValue(String locatorKey, String xlsPath, Locale locale)46	{47		String value = null;48		Workbook wb = XLSCache.getWorkbook(xlsPath);49		Sheet sheet = wb.getSheetAt(0);50		List<String> locales = getLocales(sheet);51		if (!locales.contains(locale.getCountry()))52		{53			throw new RuntimeException("Can't find locale '" + locale.getCountry() + "' in xls '" + xlsPath + "'!");54		}55		int cellN = locales.indexOf(locale.getCountry()) + 1;56		List<String> locatorKeys = getLocatorKeys(sheet);57		if (!locatorKeys.contains(locatorKey))58		{59			throw new RuntimeException("Can't find locatorKey '" + locatorKey + "' in xls '" + xlsPath + "'!");60		}61		int rowN = locatorKeys.indexOf(locatorKey) + 1;62		try63		{64			value = getCellValue(sheet.getRow(rowN).getCell(cellN));65		} catch (Exception e)66		{67			throw new RuntimeException("Can't find value for locatorKey '" + locatorKey + "' with locale '" + locale.getCountry()68					+ "' in xls '" + xlsPath + "'!");69		}70		return value;71	}72	73	private static List<String> getLocales(Sheet sheet)74	{75		List<String> locales = new ArrayList<String>();76		int lastCell = sheet.getRow(0).getLastCellNum();77		for (int i = 1; i < lastCell; i++)78		{79			locales.add(getCellValue(sheet.getRow(0).getCell(i)));80		}81		return locales;82	}83	private static List<String> getLocatorKeys(Sheet sheet)84	{85		List<String> locatorKeys = new ArrayList<String>();86		int lastRow = sheet.getLastRowNum();87		for (int i = 1; i <= lastRow; i++)88		{89			locatorKeys.add(getCellValue(sheet.getRow(i).getCell(0)));90		}91		return locatorKeys;92	}93	94	public static String parseValue(String xls, String sheetName, String key)95	{96		String value = null;97		98		Workbook wb = XLSCache.getWorkbook(xls);99		100		Sheet sheet = wb.getSheet(sheetName);101		if(sheet == null)102		{103			throw new InvalidArgsException(String.format("No sheet: '%s' in excel file: '%s'!", sheetName, xls));104		}105		106		boolean isKeyFound = false;107		for(int i = 1; i <= sheet.getLastRowNum(); i++)108		{109			if(key.equals(getCellValue(sheet.getRow(i).getCell(0))))110			{111				value = getCellValue(sheet.getRow(i).getCell(1));112				isKeyFound = true;113				break;114			}115		}116		117		if(!isKeyFound)118		{119			throw new InvalidArgsException(String.format("No key: '%s' on sheet '%s' in excel file: '%s'!", key, sheetName, xls));120		}121		122		return value;123	}124	125	public static XLSTable parseSpreadSheet(String xls, String sheetName)126	{127		return parseSpreadSheet(xls, sheetName, null, null);128	}129	130	public static XLSTable parseSpreadSheet(String xls, String sheetName, String executeColumn, String executeValue)131	{132		XLSTable dataTable;133		if(executeColumn != null && executeValue != null)134		{135			dataTable = new XLSTable(executeColumn, executeValue);136		}137		else138		{139			dataTable = new XLSTable();140		}141		142		Workbook wb = XLSCache.getWorkbook(xls);143		evaluator = wb.getCreationHelper().createFormulaEvaluator();		144		145		Sheet sheet = wb.getSheet(sheetName);146		if(sheet == null)147		{148			throw new InvalidArgsException(String.format("No sheet: '%s' in excel file: '%s'!", sheetName, xls));149		}150		151		try{152			for(int i = 0; i <= sheet.getLastRowNum(); i++)153			{154				if(i == 0)155				{156					dataTable.setHeaders(sheet.getRow(i));157				}158				else159				{160					dataTable.addDataRow(sheet.getRow(i), wb, sheet);161				}162			}163		}164		catch (Exception e) {165			LOGGER.error(e.getMessage(), e);166		}167		return dataTable;168	}169	170	public static String getCellValue(Cell cell)171	{172		if(cell == null) return "";		173			174		switch (cell.getCellType())175		{176		case Cell.CELL_TYPE_STRING:177			return df.formatCellValue(cell).trim();178		case Cell.CELL_TYPE_NUMERIC:179			return df.formatCellValue(cell).trim();180		case Cell.CELL_TYPE_BOOLEAN:181			return df.formatCellValue(cell).trim();182		case Cell.CELL_TYPE_FORMULA:183			return (cell.getCellFormula().contains("[") && cell.getCellFormula().contains("]")) ? null : df.formatCellValue(cell, evaluator).trim();184		case Cell.CELL_TYPE_BLANK:185			return "";186		default:187			return null;188		}189	}190	191	public static XLSChildTable parseCellLinks(Cell cell, Workbook wb, Sheet sheet) 192	{193 		if(cell == null) return null; 		194 		195		if(cell.getCellType() == Cell.CELL_TYPE_FORMULA)196		{197			if(cell.getCellFormula().contains("#This Row"))198			{199				if(cell.getCellFormula().contains("!"))200				{201					// Parse link to the cell with table name in the external doc([2]!Table1[[#This Row],[Header6]])					202					List<String> paths = Arrays.asList(cell.getCellFormula().split("!"));203					int externalLinkNumber = Integer.valueOf(paths.get(0).replaceAll("\\D+", "")) - 1;204					String tableName = paths.get(1).split("\\[")[0];205					if(wb instanceof XSSFWorkbook)206					{							207						ExternalLinksTable link = ((XSSFWorkbook) wb).getExternalLinksTable().get(externalLinkNumber);208						File file = new File(XLSCache.getWorkbookPath(wb));209						XSSFWorkbook childWb = (XSSFWorkbook) XLSCache.getWorkbook(file.getParent() + "/" + link.getLinkedFileName());210						if (childWb == null)  throw new DataLoadingException(String.format("WorkBook '%s' doesn't exist!",  link.getLinkedFileName()));211						for(int i = 0; i < childWb.getNumberOfSheets(); i++)212						{213							XSSFSheet childSheet = childWb.getSheetAt(i);214							for (XSSFTable table : childSheet.getTables())215							{216								if(table.getName().equals(tableName))217								{218									return createChildTable(childSheet, cell.getRowIndex());219								}220							}221						}					222					}223					else224					{225						throw new DataLoadingException("Unsupported format. External links supports only for .xlsx documents.");226					}227				} else228				{229					// Parse link to the cell with table name in the same doc(=Table1[[#This Row],[Header6]])230					List<String> paths = Arrays.asList(cell.getCellFormula().replace("=", "").split("\\["));231					if(wb instanceof XSSFWorkbook)232					{233						for(int i = 0; i < wb.getNumberOfSheets(); i++)234						{235							XSSFSheet childSheet = (XSSFSheet) wb.getSheetAt(i);236							for (XSSFTable table : childSheet.getTables())237							{238								if(table.getName().equals(paths.get(0)))239								{240									return createChildTable(childSheet, cell.getRowIndex());241								}242							}243						}					244					}245					else246					{247						throw new DataLoadingException("Unsupported format. Links with table name supports only for .xlsx documents.");248					}249				}250			} 251			else 252			{								253				String cellValue = cell.getCellFormula().replace("=", "").replace("[", "").replace("]", "!").replace("'", "");254				List<String> paths = Arrays.asList(cellValue.split("!"));			255				int rowNumber = 0;		256				Sheet childSheet = null;								257				258				switch(paths.size())259				{260					// Parse link to the cell in the same sheet(=A4)261					case 1:262						rowNumber = Integer.valueOf(paths.get(0).replaceAll("\\D+", "")) - 1;263						return createChildTable(sheet, rowNumber);264					// Parse link to the cell in another sheet in the same doc(=SheetName!A4)				265					case 2:					266						childSheet = wb.getSheet(paths.get(0));267						if(childSheet == null) throw new DataLoadingException(String.format("Sheet '%s' doesn't exist!",  paths.get(0)));	268						rowNumber = Integer.valueOf(paths.get(1).replaceAll("\\D+", "")) - 1;269						return createChildTable(childSheet, rowNumber);270					// Parse link to the cell in another doc(=[2]SheetName!A4)271					case 3:272						if(wb instanceof XSSFWorkbook)273						{	274							ExternalLinksTable link = ((XSSFWorkbook) wb).getExternalLinksTable().get(Integer.valueOf(paths.get(0)) - 1);275							File file = new File(XLSCache.getWorkbookPath(wb));276							XSSFWorkbook childWb = (XSSFWorkbook) XLSCache.getWorkbook(file.getParent() + "/" +link.getLinkedFileName());						277							278							if (childWb == null)  throw new DataLoadingException(String.format("WorkBook '%s' doesn't exist!",  paths.get(0)));279							childSheet = childWb.getSheet(paths.get(1));280							if(childSheet == null) throw new DataLoadingException(String.format("Sheet '%s' doesn't exist!",  paths.get(0)));281							rowNumber = Integer.valueOf(paths.get(2).replaceAll("\\D+", "")) - 1;282							return createChildTable(childSheet, rowNumber);283						}284						else285						{286							throw new DataLoadingException("Unsupported format. External links supports only for .xlsx documents.");287						}288					default:289						return null;290				}291			}292		}		293		return null;294	}	295	296	private static XLSChildTable createChildTable(Sheet sheet, int rowNumber)297	{298 		XLSChildTable childTable = new XLSChildTable();299 		childTable.setHeaders(sheet.getRow(0));300		childTable.addDataRow(sheet.getRow(rowNumber));...

...3 * Exception may be thrown when exception in data loading occurred.4 * 5 * @author Alex Khursevich6 */7public class DataLoadingException extends RuntimeException8{9	private static final long serialVersionUID = -6264855148555485530L;10	public DataLoadingException()11	{12		super("Can't load data.");13	}14	public DataLoadingException(String msg)15	{16		super("Can't load data: " + msg);17	}18}...

1import com.qaprosoft.carina.core.foundation.utils.DataLoadingException;2public class DataLoadingExceptionDemo {3    public static void main(String[] args) throws DataLoadingException {4        throw new DataLoadingException("Data loading exception");5    }6}7	at DataLoadingExceptionDemo.main(1.java:13)8Your name to display (optional):9Your name to display (optional):

1public class DataLoadingException extends RuntimeException {2    private static final long serialVersionUID = 1L;3    public DataLoadingException(String message) {4        super(message);5    }6    public DataLoadingException(String message, Throwable cause) {7        super(message, cause);8    }9    public DataLoadingException(Throwable cause) {10        super(cause);11    }12}13public class DataLoadingException extends RuntimeException {14    private static final long serialVersionUID = 1L;15    public DataLoadingException(String message) {16        super(message);17    }18    public DataLoadingException(String message, Throwable cause) {19        super(message, cause);20    }21    public DataLoadingException(Throwable cause) {22        super(cause);23    }24}25public class DataLoadingException extends RuntimeException {26    private static final long serialVersionUID = 1L;27    public DataLoadingException(String message) {28        super(message);29    }30    public DataLoadingException(String message, Throwable cause) {31        super(message, cause);32    }33    public DataLoadingException(Throwable cause) {34        super(cause);35    }36}37public class DataLoadingException extends RuntimeException {38    private static final long serialVersionUID = 1L;39    public DataLoadingException(String message) {40        super(message);41    }42    public DataLoadingException(String message, Throwable cause) {43        super(message, cause);44    }45    public DataLoadingException(Throwable cause) {46        super(cause);47    }48}49public class DataLoadingException extends RuntimeException {50    private static final long serialVersionUID = 1L;51    public DataLoadingException(String message) {52        super(message);53    }54    public DataLoadingException(String message, Throwable cause) {55        super(message, cause);56    }57    public DataLoadingException(Throwable cause) {58        super(cause);59    }60}61public class DataLoadingException extends RuntimeException {

1public class DataLoadingException extends Exception {2    private static final long serialVersionUID = 1L;3    public DataLoadingException(String message) {4        super(message);5    }6    public DataLoadingException(String message, Throwable cause) {7        super(message, cause);8    }9}10public class DataLoadingException extends Exception {11    private static final long serialVersionUID = 1L;12    public DataLoadingException(String message) {13        super(message);14    }15    public DataLoadingException(String message, Throwable cause) {16        super(message, cause);17    }18}19public class DataLoadingException extends Exception {20    private static final long serialVersionUID = 1L;21    public DataLoadingException(String message) {22        super(message);23    }24    public DataLoadingException(String message, Throwable cause) {25        super(message, cause);26    }27}28public class DataLoadingException extends Exception {29    private static final long serialVersionUID = 1L;30    public DataLoadingException(String message) {31        super(message);32    }33    public DataLoadingException(String message, Throwable cause) {34        super(message, cause);35    }36}37public class DataLoadingException extends Exception {38    private static final long serialVersionUID = 1L;39    public DataLoadingException(String message) {40        super(message);41    }42    public DataLoadingException(String message, Throwable cause) {43        super(message, cause);44    }45}46public class DataLoadingException extends Exception {47    private static final long serialVersionUID = 1L;48    public DataLoadingException(String message) {49        super(message);50    }51    public DataLoadingException(String message, Throwable cause) {52        super(message, cause);53    }54}

1import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;2public class 1 {3    public static void main(String[] args) {4        try {5            throw new DataLoadingException("DataLoadingException");6        } catch (DataLoadingException e) {7            System.out.println(e);8        }9    }10}11	at 1.main(1.java:7)12import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;13public class 2 {14    public static void main(String[] args) {15        try {16            throw new DataLoadingException("DataLoadingException", new Throwable("Throwable"));17        } catch (DataLoadingException e) {18            System.out.println(e);19        }20    }21}22	at 2.main(2.java:7)23	at 2.main(2.java:7)24import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;25public class 3 {26    public static void main(String[] args) {27        try {28            throw new DataLoadingException("DataLoadingException", new Throwable("Throwable"), true, true);29        } catch (DataLoadingException e) {30            System.out.println(e);31        }32    }33}34	at 3.main(3.java:7)35	at 3.main(3.java:7)36import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;37public class 4 {38    public static void main(String[] args) {39        try {40            throw new DataLoadingException("DataLoadingException", new Throwable("Throwable"), true, false);41        } catch (DataLoadingException e) {42            System.out.println(e);43        }44    }45}

1package com.qaprosoft.carina.core.foundation.exception;2{3public DataLoadingException(String message)4{5super(message);6}7}8package com.qaprosoft.carina.core.foundation.dataprovider.core;9import java.io.File;10import java.io.FileInputStream;11import java.io.IOException;12import java.util.ArrayList;13import java.util.List;14import org.apache.commons.io.IOUtils;15import org.apache.commons.lang3.StringUtils;16import org.apache.log4j.Logger;17import org.testng.ITestContext;18import org.testng.annotations.DataProvider;19import com.qaprosoft.carina.core.foundation.dataprovider.parser.IParser;20import com.qaprosoft.carina.core.foundation.dataprovider.parser.JsonParser;21import com.qaprosoft.carina.core.foundation.dataprovider.parser.XmlParser;22import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;23import com.qaprosoft.carina.core.foundation.utils.Configuration;24import com.qaprosoft.carina.core.foundation.utils.Configuration.Parameter;25import com.qaprosoft.carina.core.foundation.utils.R;26import com.qaprosoft.carina.core.foundation.utils.ownership.MethodOwner;27{28private static final Logger LOGGER = Logger.getLogger(DataProvider.class);29@DataProvider(name = "DataProvider", parallel = true)30public static Object[][] dataProvider(ITestContext context) throws IOException31{32String dataProvider = context.getCurrentXmlTest().getParameter("dataProvider");33String dataProviderType = context.getCurrentXmlTest().getParameter("dataProviderType");34String dataProviderClass = context.getCurrentXmlTest().getParameter("dataProviderClass");35String dataProviderMethod = context.getCurrentXmlTest().getParameter("dataProviderMethod");36String dataProviderArgs = context.getCurrentXmlTest().getParameter("dataProviderArgs");37String dataProviderArgsDelimiter = context.getCurrentXmlTest().getParameter("dataProviderArgsDelimiter");38String dataProviderArgsReplacement = context.getCurrentXmlTest().getParameter("dataProviderArgsReplacement");39String dataProviderArgsReplacementDelimiter = context.getCurrentXmlTest().getParameter("dataProviderArgsReplacementDelimiter");40String dataProviderArgsReplacementDelimiterRegex = context.getCurrentXmlTest().getParameter("dataProviderArgsReplacementDelimiterRegex");41String dataProviderArgsReplacementDelimiterRegexReplacement = context.getCurrentXmlTest().getParameter("dataProviderArgsReplacementDelimiterRegexReplacement");42String dataProviderArgsReplacementDelimiterRegexReplacementDelimiter = context.getCurrentXmlTest().getParameter("dataProviderArgsReplacementDelimiterRegexReplacementDelimiter");

1import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;2public class DataLoadingExceptionDemo {3   public static void main(String args[]) {4      try {5         throw new DataLoadingException();6      } catch(DataLoadingException e) {7         System.out.println("Caught the DataLoadingException");8      }9   }10}11import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;12public class DataLoadingExceptionDemo {13   public static void main(String args[]) {14      try {15         throw new DataLoadingException("Data Loading Exception");16      } catch(DataLoadingException e) {17         System.out.println("Caught the DataLoadingException");18         System.out.println(e);19      }20   }21}22import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;23public class DataLoadingExceptionDemo {24   public static void main(String args[]) {25      try {26         throw new DataLoadingException("Data Loading Exception", new NullPointerException("Null Pointer Exception"));27      } catch(DataLoadingException e) {28         System.out.println("Caught the DataLoadingException");29         System.out.println(e);30      }31   }32}

1public class DataLoadingException extends Exception {2    public DataLoadingException(String message) {3        super(message);4    }5}6public class DataLoadingException extends Exception {7    public DataLoadingException(String message) {8        super(message);9    }10}11public class DataLoadingException extends Exception {12    public DataLoadingException(String message) {13        super(message);14    }15}16public class DataLoadingException extends Exception {17    public DataLoadingException(String message) {18        super(message);19    }20}21public class DataLoadingException extends Exception {22    public DataLoadingException(String message) {23        super(message);24    }25}26public class DataLoadingException extends Exception {27    public DataLoadingException(String message) {28        super(message);29    }30}31public class DataLoadingException extends Exception {32    public DataLoadingException(String message) {33        super(message);34    }35}36public class DataLoadingException extends Exception {37    public DataLoadingException(String message) {38        super(message);39    }40}41public class DataLoadingException extends Exception {42    public DataLoadingException(String message) {43        super(message);44    }45}46public class DataLoadingException extends Exception {47    public DataLoadingException(String message) {48        super(message);49    }50}51public class DataLoadingException extends Exception {52    public DataLoadingException(String message) {53        super(message);54    }55}56public class DataLoadingException extends Exception {57    public DataLoadingException(String

1package com.qaprosoft.carina.core.foundation.exception;2public class DataLoadingException extends RuntimeException {3    private static final long serialVersionUID = -8070336395013319465L;4    public DataLoadingException(String message) {5        super(message);6    }7    public DataLoadingException(String message, Throwable cause) {8        super(message, cause);9    }10}11package com.qaprosoft.carina.core.foundation.utils;12import java.io.IOException;13import java.util.Properties;14import com.qaprosoft.carina.core.foundation.exception.DataLoadingException;15public class R {16    private static final Logger LOGGER = Logger.getLogger(R.class);17    private static final String TESTDATA_FILE = "testdata.properties";18    private static final String CONFIG_FILE = "config.properties";19    private static final String TESTDATA_FOLDER = "testdata";20    private static final String CONFIG_FOLDER = "config";21    private static final String TESTDATA_PATH = String.format("%s/%s", TESTDATA_FOLDER, TESTDATA_FILE);22    private static final String CONFIG_PATH = String.format("%s/%s", CONFIG_FOLDER, CONFIG_FILE);23    private static Properties configProperties = null;24    private static Properties testdataProperties = null;25    private static final String DEFAULT_ENV = "default";26    private static final String ENV = System.getProperty("env", DEFAULT_ENV);27    private static final String CONFIG_ENV_PATH = String.format("%s/%s", CONFIG_FOLDER, ENV + ".properties");28    private static final String TESTDATA_ENV_PATH = String.format("%s/%s", TESTDATA_FOLDER, ENV + ".properties");29    private static final String CONFIG_ENV_OVERRIDE_PATH = String.format("%s/%s", CONFIG_FOLDER, ENV + "_override.properties");30    private static final String TESTDATA_ENV_OVERRIDE_PATH = String.format("%s/%s", TESTDATA_FOLDER, ENV + "_override.properties");31    static {32        configProperties = new Properties();33        testdataProperties = new Properties();34        try {35            configProperties.load(new FileInputStream(CONFIG_PATH));36            testdataProperties.load(new FileInputStream(TESTDATA_PATH));37            if (new File(CONFIG_ENV_PATH).exists()) {38                configProperties.load(new FileInputStream(CONFIG_ENV_PATH));39            }40            if (new File(CONFIG_ENV_OVERRIDE_PATH).exists()) {41                configProperties.load(new FileInputStream(CONFIG_ENV_OVERRIDE_PATH));42            }43            if (new File(TESTDATA_ENV_PATH).exists()) {44                testdataProperties.load(new FileInputStream(TESTDATA_ENV_PATH));45            }46            if (