summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java
diff options
context:
space:
mode:
Diffstat (limited to 'ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java')
-rw-r--r--ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java617
1 files changed, 596 insertions, 21 deletions
diff --git a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java
index ece90c8c..de3f4fff 100644
--- a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java
+++ b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/ReportWrapperTest.java
@@ -37,11 +37,12 @@
*/
package org.onap.portalsdk.analytics.xmlobj;
-import static org.junit.Assert.*;
+import static org.junit.Assert.assertEquals;
+import static org.junit.Assert.assertFalse;
+import static org.junit.Assert.assertTrue;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
-import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
@@ -54,12 +55,12 @@ import org.junit.Test;
import org.junit.runner.RunWith;
import org.mockito.Matchers;
import org.mockito.Mockito;
-import org.onap.portalsdk.analytics.error.RaptorException;
import org.onap.portalsdk.analytics.model.DataCache;
import org.onap.portalsdk.analytics.model.ReportLoader;
import org.onap.portalsdk.analytics.model.base.ReportWrapper;
import org.onap.portalsdk.analytics.model.definition.ReportDefinition;
import org.onap.portalsdk.analytics.model.definition.TableSource;
+import org.onap.portalsdk.analytics.model.runtime.FormField;
import org.onap.portalsdk.analytics.model.runtime.ReportParamValues;
import org.onap.portalsdk.analytics.model.runtime.ReportRuntime;
import org.onap.portalsdk.analytics.system.AppUtils;
@@ -68,6 +69,7 @@ import org.onap.portalsdk.analytics.system.DbUtils;
import org.onap.portalsdk.analytics.system.Globals;
import org.onap.portalsdk.analytics.util.AppConstants;
import org.onap.portalsdk.analytics.util.DataSet;
+import org.onap.portalsdk.analytics.util.RemDbInfo;
import org.onap.portalsdk.analytics.util.SQLCorrector;
import org.onap.portalsdk.analytics.util.Utils;
import org.onap.portalsdk.analytics.util.XSSFilter;
@@ -83,7 +85,7 @@ import org.powermock.modules.junit4.PowerMockRunner;
@RunWith(PowerMockRunner.class)
@PrepareForTest({ AppConstants.class, Globals.class, AppUtils.class, DataCache.class, DbUtils.class, DataSet.class,
ReportLoader.class, ReportRuntime.class, Utils.class, ESAPI.class, Codec.class, SecurityCodecUtil.class,
- ConnectionUtils.class, XSSFilter.class, ReportDefinition.class, UserUtils.class })
+ ConnectionUtils.class, XSSFilter.class, ReportDefinition.class, UserUtils.class, ReportWrapper.class })
public class ReportWrapperTest {
MockitoTestSuite mockitoTestSuite = new MockitoTestSuite();
@@ -93,7 +95,10 @@ public class ReportWrapperTest {
public ReportWrapper mockReportWrapper() throws Exception {
PowerMockito.mockStatic(Globals.class);
PowerMockito.mockStatic(DbUtils.class);
+ PowerMockito.when(Globals.getReportWrapperFormat()).thenReturn("test");
+ PowerMockito.when(Globals.getTimeFormat()).thenReturn("test");
Mockito.when(Globals.getReportUserAccess()).thenReturn("test");
+ Mockito.when(Globals.getReportSecurity()).thenReturn("test");
ResultSet rs = PowerMockito.mock(ResultSet.class);
ResultSetMetaData rsmd = PowerMockito.mock(ResultSetMetaData.class);
Mockito.when(rsmd.getColumnCount()).thenReturn(1);
@@ -132,16 +137,8 @@ public class ReportWrapperTest {
dataSourceType.setDataColumnList(dataColumnList);
list.add(dataSourceType);
dataSourceList.dataSource = list;
- customReportType.setReportType("test");
- customReportType.setReportTitle("test");
- customReportType.setChartMultiSeries("Y");
customReportType.setDataSourceList(dataSourceList);
- customReportType.setChartMultiSeries("Y");
- customReportType.setChartRightAxisLabel("test");
- customReportType.setChartLeftAxisLabel("test");
ChartAdditionalOptions chartAdditionalOptions = new ChartAdditionalOptions();
- chartAdditionalOptions.setLabelAngle("test");
- chartAdditionalOptions.setTimeSeriesRender("test");
chartAdditionalOptions.setMultiSeries(false);
customReportType.setChartAdditionalOptions(chartAdditionalOptions);
FormFieldList formFieldList = new FormFieldList();
@@ -159,16 +156,383 @@ public class ReportWrapperTest {
// FormFieldType formFieldType1 = new FormFieldType();
formFields.add(formFieldType);
// formFields.add(formFieldType1);
-
formFieldList.formField = formFields;
customReportType.setFormFieldList(formFieldList);
- ReportWrapper reportWrapper = new ReportWrapper(customReportType, "-1", "test", "testId", "test", "test", "1",
+ DashboardReports dr = new DashboardReports();
+ customReportType.setDashBoardReports(dr);
+ customReportType.setDrillURLInPoPUpPresent(true);
+ List<JavascriptItemType> javascriptItem = new ArrayList<>();
+ JavascriptItemType ji = new JavascriptItemType();
+ ji.setId("1");
+ ji.setCallText("test");
+ ji.setFieldId("2");
+ JavascriptList javascriptList = new JavascriptList();
+ javascriptList.setJavascriptItem(javascriptItem);
+ customReportType.setJavascriptList(javascriptList);
+ FormatType ft = new FormatType();
+ ft.setAlignment("left");
+ FormatList fl = new FormatList();
+ fl.getFormat().add(ft);
+ SemaphoreType st = new SemaphoreType();
+ st.setComment("test");
+ st.setFormatList(fl);
+ st.setSemaphoreId("1");
+ st.setSemaphoreName("test");
+ st.setTarget("test");
+ SemaphoreList smlist = new SemaphoreList();
+ smlist.getSemaphore().add(st);
+ customReportType.setSemaphoreList(smlist);
+ chartAdditionalOptions.setChartOrientation("test");
+ chartAdditionalOptions.setSecondaryChartRenderer("test");
+ chartAdditionalOptions.setHideToolTips("test");
+ chartAdditionalOptions.setHidechartLegend("test");
+ chartAdditionalOptions.setLegendPosition("test");
+ chartAdditionalOptions.setLabelAngle("test");
+ chartAdditionalOptions.setIntervalFromdate("test");
+ chartAdditionalOptions.setIntervalTodate("test");
+ chartAdditionalOptions.setIntervalLabel("test");
+ chartAdditionalOptions.setLastSeriesALineChart("test");
+ chartAdditionalOptions.setLastSeriesABarChart("test");
+ chartAdditionalOptions.setMaxLabelsInDomainAxis("test");
+ chartAdditionalOptions.setLinearRegression("test");
+ chartAdditionalOptions.setLinearRegressionColor("test");
+ chartAdditionalOptions.setExponentialRegressionColor("test");
+ chartAdditionalOptions.setMaxRegression("test");
+ chartAdditionalOptions.setRangeAxisUpperLimit("test");
+ chartAdditionalOptions.setRangeAxisLowerLimit("test");
+ chartAdditionalOptions.setOverlayItemValueOnStackBar("test");
+ chartAdditionalOptions.setAnimate(true);
+ chartAdditionalOptions.setKeepDomainAxisValueAsString("test");
+ chartAdditionalOptions.setAnimateAnimatedChart(true);
+ chartAdditionalOptions.setStacked(true);
+ chartAdditionalOptions.setBarControls(true);
+ chartAdditionalOptions.setXAxisDateType(true);
+ chartAdditionalOptions.setLessXaxisTickers(true);
+ chartAdditionalOptions.setTimeAxis(true);
+ chartAdditionalOptions.setTimeSeriesRender("test");
+ chartAdditionalOptions.setLeftMargin(10);
+ chartAdditionalOptions.setRightMargin(10);
+ chartAdditionalOptions.setTopMargin(10);
+ chartAdditionalOptions.setBottomMargin(10);
+ ReportMap rm = new ReportMap();
+ rm.setMarkerColor("test");
+ rm.setUseDefaultSize("10");
+ rm.setHeight("10cm");
+ rm.setWidth("10cm");
+ rm.setIsMapAllowedYN("Y");
+ rm.setAddAddressInDataYN("Y");
+ rm.setAddressColumn("test");
+ rm.setDataColumn("test");
+ rm.setDefaultMapType("test");
+ rm.setLatColumn("test");
+ rm.setLegendColumn("test");
+ rm.setLongColumn("test");
+ rm.setColorColumn("test");
+ Marker marker = new Marker();
+ marker.setAddressColumn("test");
+ marker.setDataColumn("test");
+ marker.setDataHeader("test");
+ marker.setMarkerColor("test");
+ rm.getMarkers().add(marker);
+ customReportType.setReportMap(rm);
+ ChartDrillOptions chartDrillOptions = new ChartDrillOptions();
+ ChartDrillFormfield cdff = new ChartDrillFormfield();
+ cdff.setFormfield("test");
+ chartDrillOptions.getTargetFormfield().add(cdff);
+ customReportType.setChartDrillOptions(chartDrillOptions);
+ customReportType.setReportSQL("test");
+ dataSourceType.setRefDefinition("test");
+ dataSourceType.setComment("test");
+ dataColumnType.setDisplayWidthInPxls("test");
+ dataColumnType.setDisplayAlignment("test");
+ dataColumnType.setDisplayHeaderAlignment("test");
+ dataColumnType.setColType(AppConstants.CT_HYPERLINK);
+ dataColumnType.setHyperlinkType("IMAGE");
+ dataColumnType.setIndentation(10);
+ dataColumnType.setColFormat("test");
+ dataColumnType.setOrderBySeq(10);
+ dataColumnType.setOrderByAscDesc("test");
+ dataColumnType.setDisplayTotal("test");
+ dataColumnType.setChartColor("test");
+ dataColumnType.setChartLineType("test");
+ dataColumnType.setIsRangeAxisFilled(true);
+ dataColumnType.setChartSeries(true);
+ dataColumnType.setCreateInNewChart(true);
+ dataColumnType.setDrillDownType("test");
+ dataColumnType.setDrillinPoPUp(true);
+ dataColumnType.setComment("test");
+ dataColumnType.setSemaphoreId("test");
+ dataColumnType.setDbColType("test");
+ dataColumnType.setNowrap("test");
+ dataColumnType.setEnhancedPagination(true);
+ dataColumnType.setDataMiningCol("test");
+ ColFilterList colFilterList = new ColFilterList();
+ ColFilterType colFilterType = new ColFilterType();
+ colFilterType.setArgValue("[test]");
+ colFilterType.setCloseBrackets("test");
+ colFilterType.setColId("test");
+ colFilterType.setComment("test");
+ colFilterType.setExpression("test");
+ colFilterType.setFilterSeq(10);
+ colFilterType.setJoinCondition("test");
+ colFilterType.setOpenBrackets("test");
+ colFilterType.setArgType("FORM");
+ colFilterList.getColFilter().add(colFilterType);
+ dataColumnType.setColFilterList(colFilterList);
+ formFieldType.setVisible("test");
+ formFieldType.setFieldSQL("test");
+ formFieldType.setFieldDefaultSQL("test");
+ //fft.setRangeStartDate();
+ formFieldType.setRangeEndDateSQL("test");
+ formFieldType.setRangeStartDateSQL("test");
+ //fft.setRangeEndDate(value);
+ formFieldType.setComment("test");
+ formFieldType.setDependsOn("test");
+ formFieldType.setGroupFormField(true);
+ formFieldType.setMultiSelectListSize("test");
+ PredefinedValueList predefinedValueList = new PredefinedValueList();
+ List<String> values = new ArrayList<>();
+ values.add("test");
+ predefinedValueList.predefinedValue= values;
+ formFieldType.setPredefinedValueList(predefinedValueList);
+ DataminingOptions dataminingOptions = new DataminingOptions();
+ customReportType.setDataminingOptions(dataminingOptions);
+ ReportWrapper reportWrapper = new ReportWrapper(customReportType, "1", null, "testId", "test", "test", "1",
"1", true);
- reportWrapper.setWholeSQL("test");
+ reportWrapper.setWholeSQL("test");
+ reportWrapper.setPdfImg("testLogo");
+ reportWrapper.setEmptyMessage("test");
+ reportWrapper.setDrillReportIdForChart("test");
+ reportWrapper.setDrillXAxisFormField("test");
+ reportWrapper.setDrillYAxisFormField("test");
+ reportWrapper.setDrillYAxisFormField("test");
+ reportWrapper.setDrillSeriesFormField("test");
+ reportWrapper.setDataGridAlign("test");
+ reportWrapper.setWidthNoColumn("test");
+ reportWrapper.setClassifier("test");
+ reportWrapper.setForecastingPeriod("10");
+ reportWrapper.setForecastingTimeFormat("test");
+ reportWrapper.setReportSQLOnlyFirstPart("test");
+ reportWrapper.setReportSQLWithRowNum("test");
+ reportWrapper.setIsWeeklyScheduleAllowed("true");
+ reportWrapper.setIsOneTimeScheduleAllowed("true");
+ reportWrapper.setIsMonthlyScheduleAllowed("true");
+ reportWrapper.setIsHourlyScheduleAllowed("true");
+ reportWrapper.setIsDailyScheduleAllowed("true");
+ reportWrapper.setIsDailyMFScheduleAllowed("true");
+ reportWrapper.setHideFormFieldAfterRun(true);
+ reportWrapper.setChartTypeFixed("test");
+ reportWrapper.setDrillDownURLInPopupPresent(true);
+ reportWrapper.setLinearRegression("test");
+ reportWrapper.setCustomizedRegressionPoint("test");
+ reportWrapper.setLinearRegressionColor("test");
+ reportWrapper.setExponentialRegressionColor("test");
+ reportWrapper.setTimeSeriesRender("test");
+ reportWrapper.setShowXAxisLabel(true);
+ reportWrapper.setAddXAxisTickers(true);
+ reportWrapper.setZoomIn(10);
+ reportWrapper.setTimeAxisType("test");
+ reportWrapper.setToggleLayout(true);
+ reportWrapper.setShowPageSize(true);
+ reportWrapper.setChartToolTips("test");
+ reportWrapper.setDomainAxisValuesAsString("test");
+ reportWrapper.setJumpTo(10);
+ reportWrapper.setSearchPageSize(10);
+ reportWrapper.setShowGotoOption(true);
+ reportWrapper.setShowNavPos(true);
+ reportWrapper.setPageNav(true);
+ reportWrapper.setNavPosition("test");
+ reportWrapper.setDashboardEditor("test");
+ DashboardEditorReport dashboardEditorReport =new DashboardEditorReport();
+ dashboardEditorReport.setDataType("test");
+ dashboardEditorReport.setPosition("test");
+ dashboardEditorReport.setReportId("test");
+ dashboardEditorReport.setReportName("test");
+ DashboardEditorList deList = new DashboardEditorList();
+ deList.getEditorList().add(dashboardEditorReport);
+ reportWrapper.setDashboardEditorList(deList);
+ reportWrapper.setPDFFont("test");
+ reportWrapper.setPDFFontSize(10);
+ reportWrapper.setPDFOrientation("test");
+ reportWrapper.setPDFLogo1("test");
+ reportWrapper.setPDFLogo1Size(10);
+ reportWrapper.setPDFLogo2("test");
+ reportWrapper.setPDFLogo2Size(10);
+ reportWrapper.setPDFCoverPage(true);
+ reportWrapper.setPDFFooter1("test");
+ reportWrapper.setPDFFooter2("test");
+ reportWrapper.setMultiGroupColumn("test");
+ reportWrapper.setTopDown("test");
+ reportWrapper.setSizedByContent("test");
+ reportWrapper.setPageSize(10);
+ reportWrapper.setAllowSchedule("test");
+ reportWrapper.setMaxRowsInExcelDownload (10);
+ reportWrapper.setReportInNewWindow(true);
+ reportWrapper.setDisplayFolderTree(true);
+ reportWrapper.setReportDescr("test");
+ reportWrapper.setChartMultiplePieOrder("test");
+ reportWrapper.setChartMultiplePieLabelDisplay("test");
+ reportWrapper.setSecondaryChartRenderer("test");
+ reportWrapper.setOverlayItemValueOnStackBar("test");
+ reportWrapper.setIntervalFromdate("test");
+ reportWrapper.setIntervalLabel("test");
+ reportWrapper.setIntervalTodate("test");
+ reportWrapper.setMaxLabelsInDomainAxis("test");
+ reportWrapper.setLastSeriesALineChart("test");
+ reportWrapper.setLastSeriesABarChart("test");
+ reportWrapper.setChartDisplay("test");
+ ObjectFactory objFactory = new ObjectFactory();
+ reportWrapper.addDashboardReportsNew(objFactory);
+ reportWrapper.addPDFAdditionalOptions(objFactory);
+ reportWrapper.setChartTypeFixed("test");
+ reportWrapper.setChartMultiSeries("test");
+ reportWrapper.setReportTitle("test");
+ reportWrapper.setReportSubTitle("test");
+ reportWrapper.setReportHeader("test");
+ reportWrapper.setReportFooter("test");
+ reportWrapper.setNumFormCols("test");
+ reportWrapper.setNumDashCols("test");
+ reportWrapper.setDisplayOptions("test");
+ reportWrapper.setDataContainerHeight("test");
+ reportWrapper.setDataContainerWidth("test");
+ reportWrapper.setDashboardOptions("test");
+ reportWrapper.setDashboardLayoutHTML("testHTML");
+ reportWrapper.setReportType("test");
+ reportWrapper.setChartRightAxisLabel("test");
+ reportWrapper.setChartLeftAxisLabel("test");
+ reportWrapper.setDBInfo("testDB");
+ reportWrapper.setChartWidth("100 cm");
+ reportWrapper.setChartHeight("100 cm");
+ reportWrapper.setFrozenColumns(10);
+ reportWrapper.setComment("test");
+ reportWrapper.setDashboardType(true);
+ reportWrapper.setJavascriptElement("test");
+ reportWrapper.setFolderId("1");
+ reportWrapper.setReportMap(rm);
+ reportWrapper.setReportChartDrillOptions(chartDrillOptions);
+ reportWrapper.setFormHelpText("test");
+ DataSet ds= Mockito.mock(DataSet.class);
+ PowerMockito.when(DbUtils.executeQuery(Mockito.any(String.class))).thenReturn(ds);
+ PowerMockito.when(ds.getString(Mockito.anyInt(),Mockito.anyInt())).thenReturn("test");
+ PowerMockito.when(ds.getRowCount()).thenReturn(1);
+
return reportWrapper;
}
@Test
+ public void testReportWrapperProperties() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ assertTrue(rw.isDisplayFolderTree());
+ assertTrue(rw.isHideFormFieldAfterRun());
+ assertTrue(rw.isReportInNewWindow());
+ assertTrue(rw.isDrillDownURLInPopupPresent());
+ assertFalse(rw.isChartTypeFixed());
+ assertFalse(rw.displayPieOrderinRunPage());
+ assertFalse(rw.isMultiplePieOrderByRow());
+ assertFalse(rw.isMultiplePieOrderByColumn());
+ assertFalse(rw.displayPieLabelDisplayinRunPage());
+ assertEquals("test", rw.getMultiplePieLabelDisplay());
+ assertFalse(rw.displayChartDisplayinRunPage());
+ assertFalse(rw.isChartDisplayIn3D());
+ assertTrue(rw.isChartAnimate());
+ assertTrue(rw.isXAxisDateType());
+ assertFalse(rw.displayChartOrientationInRunPage());
+ assertFalse(rw.isVerticalOrientation());
+ assertFalse(rw.displaySecondaryChartRendererInRunPage());
+ assertFalse(rw.displayIntervalInputInRunPage());
+ assertFalse(rw.showLegendDisplayOptionsInRunPage());
+ assertFalse(rw.isLastSeriesALineChart());
+ assertFalse(rw.hideChartToolTips());
+ assertFalse(rw.keepDomainAxisValueInChartAsString());
+ assertTrue(rw.isDashboardType());
+ assertTrue(rw.isToggleLayout());
+ assertTrue(rw.isShowPageSize());
+ assertTrue(rw.isShowNavPos());
+ assertTrue(rw.isShowGotoOption());
+ assertTrue(rw.isPageNav());
+ assertTrue(rw.isPDFCoverPage());
+ assertFalse(rw.isAllowSchedule());
+ assertFalse(rw.isMultiGroupColumn());
+ assertFalse(rw.isTopDown());
+ assertFalse(rw.isSizedByContent());
+ assertFalse(rw.isDashboardOptionHideChart());
+ assertFalse(rw.isDashboardOptionHideData());
+ assertFalse(rw.isDashboardOptionHideBtns());
+ assertFalse(rw.isDisplayOptionHideForm());
+ assertFalse(rw.isDisplayOptionHideData());
+ assertFalse(rw.isDisplayOptionHideBtns());
+ assertFalse(rw.isDisplayOptionHideMap());
+ assertFalse(rw.isDisplayOptionHideExcelIcons());
+ assertFalse(rw.isDisplayOptionHidePDFIcons());
+ assertEquals("test", rw.getChartTypeFixed());
+ assertEquals("test", rw.getLinearRegression());
+ assertEquals("test", rw.getCustomizedRegressionPoint());
+ assertEquals("test", rw.getLinearRegressionColor());
+ assertEquals(0, rw.getChartWidthAsInt());
+ assertEquals("test", rw.getExponentialRegressionColor());
+ assertEquals("test", rw.getSecondaryChartRenderer());
+ assertEquals("test", rw.getOverlayItemValueOnStackBar());
+ assertEquals("test", rw.getIntervalFromdate());
+ assertEquals("test", rw.getIntervalTodate());
+ assertEquals("test", rw.getIntervalLabel());
+ assertEquals("test", rw.getMaxLabelsInDomainAxis());
+ assertEquals(0, rw.getChartHeightAsInt());
+ assertEquals("test", rw.getReportHeader());
+ assertEquals("test", rw.getReportFooter());
+ assertEquals("test", rw.getNumDashCols());
+ assertEquals(1, rw.getNumDashColsAsInt());
+ assertEquals("test", rw.getNumFormCols());
+ assertEquals(5, rw.getNumFormColsAsInt());
+ assertEquals(10, rw.getJumpTo());
+ assertEquals("test", rw.getNavPosition());
+ assertEquals(null, rw.getDashboardEditorList());
+ assertEquals(PDFAdditionalOptions.class, rw.getPDFAdditionalOptions().getClass());
+ assertEquals(null, rw.getPDFFont());
+ assertEquals(9, rw.getPDFFontSize());
+ assertEquals("landscape", rw.getPDFOrientation());
+ assertEquals(null, rw.getPDFLogo1());
+ assertEquals(0, rw.getPDFLogo1Size());
+ assertEquals(null, rw.getPDFLogo2());
+ assertEquals(0, rw.getPDFLogo2Size());
+ assertEquals(null, rw.getPDFFooter1());
+ assertEquals(null, rw.getPDFFooter2());
+ assertEquals("test", rw.getDataContainerHeight());
+ assertEquals("test", rw.getDataContainerWidth());
+ assertEquals("test", rw.getAllowSchedule());
+ assertEquals("test", rw.getMultiGroupColumn());
+ assertEquals(0, rw.getMaxGroupLevel());
+ assertEquals(ChartAdditionalOptions.class, rw.getChartAdditionalOptions().getClass());
+ assertEquals(DataminingOptions.class, rw.getDataminingOptions().getClass());
+ assertEquals(DashboardReports.class, rw.getDashBoardReports().getClass());
+ assertEquals(DashboardReportsNew.class, rw.getDashBoardReportsNew().getClass());
+ assertEquals("test", rw.getClassifier());
+ assertEquals(10, rw.getForecastingPeriod());
+ assertEquals("test", rw.getForecastingTimeFormat());
+ assertEquals(10, rw.getFrozenColumns());
+ assertEquals("testLogo", rw.getPdfImg());
+ assertEquals("test", rw.getEmptyMessage());
+ assertEquals("test", rw.getDrillReportIdForChart());
+ assertEquals("test", rw.getDrillXAxisFormField());
+ assertEquals("test", rw.getDrillYAxisFormField());
+ assertEquals("test", rw.getDrillSeriesFormField());
+ assertEquals("test", rw.getDataGridAlign());
+ assertEquals("test", rw.getWidthNoColumn());
+ assertEquals(10, rw.getSearchPageSize());
+ assertEquals(null, rw.getDashboardEditor());
+ assertEquals(ReportMap.class, rw.getReportMap().getClass());
+ assertEquals(ChartDrillOptions.class, rw.getReportChartDrillOptions().getClass());
+ assertEquals("test", rw.getFormHelpText());
+ assertEquals("test", rw.getReportSQLWithRowNum());
+ assertEquals("true", rw.getIsWeeklyScheduleAllowed());
+ assertEquals("true", rw.getIsOneTimeScheduleAllowed());
+ assertEquals("true", rw.getIsMonthlyScheduleAllowed());
+ assertEquals("true", rw.getIsHourlyScheduleAllowed());
+ assertEquals("true", rw.getIsDailyScheduleAllowed());
+ assertEquals("true", rw.getIsDailyMFScheduleAllowed());
+ assertEquals("1", rw.getFolderId());
+ }
+
+ @Test
public void cloneCustomReportTest() throws Exception {
ReportWrapper rw = mockReportWrapper();
rw.cloneCustomReport();
@@ -237,16 +601,16 @@ public class ReportWrapperTest {
public void rwTest() throws Exception {
ReportWrapper rw = new ReportWrapper(mockReportWrapper());
assertEquals(rw.getCustomReport().getClass(), CustomReportType.class);
- assertEquals(rw.getReportID(), "-1");
- assertEquals(rw.getMenuID(), "1");
+ assertEquals(rw.getReportID(), "1");
+ assertEquals(rw.getMenuID(), "");
assertFalse(rw.checkMenuIDSelected("test"));
- assertTrue(rw.isMenuApproved());
- assertEquals(rw.getReportDefType(), "");
+ assertFalse(rw.isMenuApproved());
+ assertEquals(rw.getReportDefType(), "SQL-based");
rw.setMenuID("test");
rw.setMenuApproved(false);
rw.setReportDefType("test");
rw.updateReportDefType();
- assertEquals(rw.getJavascriptElement(), null);
+ assertEquals(rw.getJavascriptElement(), "test");
}
@Test
@@ -727,6 +1091,166 @@ public class ReportWrapperTest {
Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(true);
rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
}
+
+ @Test
+ public void generateSQLSQLBased2Test() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ReportParamValues paramValues = PowerMockito.mock(ReportParamValues.class);
+ PowerMockito.mockStatic(Globals.class);
+ Mockito.when(Globals.getRequestParams()).thenReturn("test,req");
+ Mockito.when(Globals.getSessionParams()).thenReturn("test,session");
+ Mockito.when(Globals.getSessionParamsForScheduling()).thenReturn("test,sessionSche");
+ rw.getCustomReport().setReportSQL("SELECT WHEN FROM TABLE WHERE [test] AND ORDER BY");
+ PowerMockito.mockStatic(ESAPI.class);
+ PowerMockito.mockStatic(SecurityCodecUtil.class);
+ Encoder encoder = PowerMockito.mock(Encoder.class);
+ Mockito.when(ESAPI.encoder()).thenReturn(encoder);
+ Codec codec = PowerMockito.mock(Codec.class);
+ Mockito.when(SecurityCodecUtil.getCodec()).thenReturn(codec);
+ Mockito.when(encoder.encodeForSQL(Matchers.any(Codec.class), Matchers.anyString())).thenReturn("select *");
+ rw.getFormFieldList().formField.get(0).setFieldType("BLANK1");
+ Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(true);
+ rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
+ }
+
+ @Test
+ public void generateSQLSQLBased3Test() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ReportParamValues paramValues = PowerMockito.mock(ReportParamValues.class);
+ PowerMockito.mockStatic(Globals.class);
+ Mockito.when(Globals.getRequestParams()).thenReturn("test,req");
+ Mockito.when(Globals.getSessionParams()).thenReturn("test,session");
+ Mockito.when(Globals.getSessionParamsForScheduling()).thenReturn("test,sessionSche");
+ rw.getCustomReport().setReportSQL("SELECT WHEN FROM TABLE WHERE [test] ORDER BY");
+ PowerMockito.mockStatic(ESAPI.class);
+ PowerMockito.mockStatic(SecurityCodecUtil.class);
+ Encoder encoder = PowerMockito.mock(Encoder.class);
+ Mockito.when(ESAPI.encoder()).thenReturn(encoder);
+ Codec codec = PowerMockito.mock(Codec.class);
+ Mockito.when(SecurityCodecUtil.getCodec()).thenReturn(codec);
+ Mockito.when(encoder.encodeForSQL(Matchers.any(Codec.class), Matchers.anyString())).thenReturn("select *");
+ rw.getFormFieldList().formField.get(0).setFieldType("BLANK1");
+ Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(true);
+ rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
+ }
+
+ @Test
+ public void generateSQLSQLBased4Test() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ReportParamValues paramValues = PowerMockito.mock(ReportParamValues.class);
+ PowerMockito.mockStatic(Globals.class);
+ PowerMockito.mockStatic(ConnectionUtils.class);
+ Mockito.when(Globals.getRequestParams()).thenReturn("test,req");
+ Mockito.when(Globals.getSessionParams()).thenReturn("test,session");
+ Mockito.when(Globals.getSessionParamsForScheduling()).thenReturn("test,sessionSche");
+ rw.getCustomReport().setReportSQL("SELECT WHEN FROM TABLE WHERE [test] ORDER BY");
+ PowerMockito.mockStatic(ESAPI.class);
+ PowerMockito.mockStatic(SecurityCodecUtil.class);
+ Encoder encoder = PowerMockito.mock(Encoder.class);
+ Mockito.when(ESAPI.encoder()).thenReturn(encoder);
+ Codec codec = PowerMockito.mock(Codec.class);
+ Mockito.when(SecurityCodecUtil.getCodec()).thenReturn(codec);
+ Mockito.when(encoder.encodeForSQL(Matchers.any(Codec.class), Matchers.anyString())).thenReturn("select *");
+ rw.getFormFieldList().formField.get(0).setFieldType("BLANK1");
+ Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(false);
+ Mockito.when(paramValues.isParameterTextAreaValueAndModified(Mockito.any(String.class))).thenReturn(true);
+ Mockito.when(paramValues.getParamValue(Mockito.any(String.class))).thenReturn("select test");
+ DataSet ds = Mockito.mock(DataSet.class);
+ Mockito.when(ConnectionUtils.getDataSet(Mockito.any(String.class), Mockito.any(String.class))).thenReturn(ds);
+ Mockito.when(ds.getRowCount()).thenReturn(1);
+ Mockito.when(ds.getString(Mockito.anyInt(), Mockito.anyInt())).thenReturn("test");
+ rw.getFormFieldList().formField.get(0).setValidationType(FormField.VT_TIMESTAMP_HR);
+ rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
+ }
+
+ @Test
+ public void generateSQLSQLBased5Test() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ReportParamValues paramValues = PowerMockito.mock(ReportParamValues.class);
+ PowerMockito.mockStatic(Globals.class);
+ PowerMockito.mockStatic(ConnectionUtils.class);
+ Mockito.when(Globals.getRequestParams()).thenReturn("test,req");
+ Mockito.when(Globals.getSessionParams()).thenReturn("test,session");
+ Mockito.when(Globals.getSessionParamsForScheduling()).thenReturn("test,sessionSche");
+ rw.getCustomReport().setReportSQL("SELECT WHEN FROM TABLE WHERE [test] ORDER BY");
+ PowerMockito.mockStatic(ESAPI.class);
+ PowerMockito.mockStatic(SecurityCodecUtil.class);
+ Encoder encoder = PowerMockito.mock(Encoder.class);
+ Mockito.when(ESAPI.encoder()).thenReturn(encoder);
+ Codec codec = PowerMockito.mock(Codec.class);
+ Mockito.when(SecurityCodecUtil.getCodec()).thenReturn(codec);
+ Mockito.when(encoder.encodeForSQL(Matchers.any(Codec.class), Matchers.anyString())).thenReturn("select *");
+ rw.getFormFieldList().formField.get(0).setFieldType("BLANK1");
+ Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(false);
+ Mockito.when(paramValues.isParameterTextAreaValueAndModified(Mockito.any(String.class))).thenReturn(true);
+ Mockito.when(paramValues.getParamValue(Mockito.any(String.class))).thenReturn("select test");
+ DataSet ds = Mockito.mock(DataSet.class);
+ Mockito.when(ConnectionUtils.getDataSet(Mockito.any(String.class), Mockito.any(String.class))).thenReturn(ds);
+ Mockito.when(ds.getRowCount()).thenReturn(1);
+ Mockito.when(ds.getString(Mockito.anyInt(), Mockito.anyInt())).thenReturn("test");
+ rw.getFormFieldList().formField.get(0).setValidationType(FormField.VT_TIMESTAMP_MIN);
+ rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
+ }
+
+ @Test
+ public void generateSQLSQLBased6Test() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ReportParamValues paramValues = PowerMockito.mock(ReportParamValues.class);
+ PowerMockito.mockStatic(Globals.class);
+ PowerMockito.mockStatic(ConnectionUtils.class);
+ Mockito.when(Globals.getRequestParams()).thenReturn("test,req");
+ Mockito.when(Globals.getSessionParams()).thenReturn("test,session");
+ Mockito.when(Globals.getSessionParamsForScheduling()).thenReturn("test,sessionSche");
+ rw.getCustomReport().setReportSQL("SELECT WHEN FROM TABLE WHERE [test] ORDER BY");
+ PowerMockito.mockStatic(ESAPI.class);
+ PowerMockito.mockStatic(SecurityCodecUtil.class);
+ Encoder encoder = PowerMockito.mock(Encoder.class);
+ Mockito.when(ESAPI.encoder()).thenReturn(encoder);
+ Codec codec = PowerMockito.mock(Codec.class);
+ Mockito.when(SecurityCodecUtil.getCodec()).thenReturn(codec);
+ Mockito.when(encoder.encodeForSQL(Matchers.any(Codec.class), Matchers.anyString())).thenReturn("select *");
+ rw.getFormFieldList().formField.get(0).setFieldType("BLANK1");
+ Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(false);
+ Mockito.when(paramValues.isParameterTextAreaValueAndModified(Mockito.any(String.class))).thenReturn(true);
+ Mockito.when(paramValues.getParamValue(Mockito.any(String.class))).thenReturn("select test");
+ DataSet ds = Mockito.mock(DataSet.class);
+ Mockito.when(ConnectionUtils.getDataSet(Mockito.any(String.class), Mockito.any(String.class))).thenReturn(ds);
+ Mockito.when(ds.getRowCount()).thenReturn(1);
+ Mockito.when(ds.getString(Mockito.anyInt(), Mockito.anyInt())).thenReturn("test");
+ rw.getFormFieldList().formField.get(0).setValidationType(FormField.VT_TIMESTAMP_SEC);
+ rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
+ }
+
+ @Test
+ public void generateSQLSQLBased7Test() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ReportParamValues paramValues = PowerMockito.mock(ReportParamValues.class);
+ PowerMockito.mockStatic(Globals.class);
+ PowerMockito.mockStatic(ConnectionUtils.class);
+ Mockito.when(Globals.getRequestParams()).thenReturn("test,req");
+ Mockito.when(Globals.getSessionParams()).thenReturn("test,session");
+ Mockito.when(Globals.getSessionParamsForScheduling()).thenReturn("test,sessionSche");
+ rw.getCustomReport().setReportSQL("SELECT WHEN FROM TABLE WHERE [test] ORDER BY");
+ PowerMockito.mockStatic(ESAPI.class);
+ PowerMockito.mockStatic(SecurityCodecUtil.class);
+ Encoder encoder = PowerMockito.mock(Encoder.class);
+ Mockito.when(ESAPI.encoder()).thenReturn(encoder);
+ Codec codec = PowerMockito.mock(Codec.class);
+ Mockito.when(SecurityCodecUtil.getCodec()).thenReturn(codec);
+ Mockito.when(encoder.encodeForSQL(Matchers.any(Codec.class), Matchers.anyString())).thenReturn("select *");
+ rw.getFormFieldList().formField.get(0).setFieldType("BLANK1");
+ Mockito.when(paramValues.isParameterMultiValue(Matchers.anyString())).thenReturn(false);
+ Mockito.when(paramValues.isParameterTextAreaValueAndModified(Mockito.any(String.class))).thenReturn(true);
+ //Mockito.when(paramValues.getParamValue(Mockito.any(String.class))).thenReturn("select test");
+ DataSet ds = Mockito.mock(DataSet.class);
+ Mockito.when(ConnectionUtils.getDataSet(Mockito.any(String.class), Mockito.any(String.class))).thenReturn(ds);
+ Mockito.when(ds.getRowCount()).thenReturn(1);
+ Mockito.when(ds.getString(Mockito.anyInt(), Mockito.anyInt())).thenReturn("");
+ RemDbInfo remDbInfo = Mockito.mock(RemDbInfo.class);
+ PowerMockito.whenNew(RemDbInfo.class).withNoArguments().thenReturn(remDbInfo);
+ Mockito.when(remDbInfo.getDBType(Mockito.any(String.class))).thenReturn("DAYTONA");
+ rw.generateSQLSQLBased(paramValues, "overrideSortByColId", "overrideSortByAscDesc", "userId", mockedRequest);
+ }
@Test
public void generateSQLVisualTest() throws Exception {
@@ -853,7 +1377,7 @@ public class ReportWrapperTest {
@Test
public void getFrozenColumnId1Test() throws Exception {
ReportWrapper rw = mockReportWrapper();
- rw.getCustomReport().setFrozenColumns(1);
+ rw.setFrozenColumns(1);
rw.getCustomReport().getDataSourceList().getDataSource().get(0).getDataColumnList().getDataColumn().get(0)
.setVisible(true);
rw.getFrozenColumnId();
@@ -1146,4 +1670,55 @@ public class ReportWrapperTest {
DataSourceType dataSourceType = new DataSourceType();
rw.formatListValue("[MAX_VALUE]", "[MAX_VALUE]", dataColumnType, false, false, dataSourceType, "listBaseSQL");
}
+
+ @Test
+ public void testIsChartDrillDownContainsName() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ rw.isChartDrillDownContainsName("test");
+ }
+
+ @Test
+ public void testCloneChartDrillFormfield() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ObjectFactory objFactory = new ObjectFactory();
+ ChartDrillFormfield cdff = new ChartDrillFormfield();
+ cdff.setFormfield("test");
+ rw.cloneChartDrillFormfield(objFactory, cdff);
+ }
+
+ @Test
+ public void testCloneMarkerType() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ObjectFactory objFactory = new ObjectFactory();
+ Marker marker = new Marker();
+ marker.setAddressColumn("test");
+ marker.setDataColumn("test");
+ marker.setDataHeader("test");
+ marker.setMarkerColor("test");
+ rw.cloneMarkerType(objFactory, marker);
+ }
+
+ @Test
+ public void testCloneDashboardType() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ ObjectFactory objFactory = new ObjectFactory();
+ Reports reports = new Reports();
+ reports.setBgcolor("test");
+ reports.setReportId("1");
+ rw.cloneDashboardType(objFactory, reports);
+ }
+
+ @Test
+ public void testIsEnhancedPaginationNeeded() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ rw.isEnhancedPaginationNeeded();
+ }
+
+ @Test
+ public void testGetColumnWhichNeedEnhancedPagination() throws Exception {
+ ReportWrapper rw = mockReportWrapper();
+ rw.getColumnWhichNeedEnhancedPagination();
+ }
+
+
} \ No newline at end of file