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

Best Carina code snippet using com.qaprosoft.carina.core.foundation.exception.DataLoadingException

Source:XLSParser.java

...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));...

Source:DataLoadingException.java

...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}...

DataLoadingException

Using AI Code Generation

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):

DataLoadingException

Using AI Code Generation

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 {

DataLoadingException

Using AI Code Generation

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}

DataLoadingException

Using AI Code Generation

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}

DataLoadingException

Using AI Code Generation

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");

DataLoadingException

Using AI Code Generation

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}

DataLoadingException

Using AI Code Generation

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

DataLoadingException

Using AI Code Generation

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 (

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.