diff options
4 files changed, 680 insertions, 2 deletions
diff --git a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SchedulerUtilTest.java b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SchedulerUtilTest.java new file mode 100644 index 00000000..557b0ace --- /dev/null +++ b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SchedulerUtilTest.java @@ -0,0 +1,320 @@ +/* + * ============LICENSE_START========================================== + * ONAP Portal SDK + * =================================================================== + * Copyright © 2017 AT&T Intellectual Property. All rights reserved. + * =================================================================== + * + * Unless otherwise specified, all software contained herein is licensed + * under the Apache License, Version 2.0 (the "License"); + * you may not use this software except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * Unless otherwise specified, all documentation contained herein is licensed + * under the Creative Commons License, Attribution 4.0 Intl. (the "License"); + * you may not use this documentation except in compliance with the License. + * You may obtain a copy of the License at + * + * https://creativecommons.org/licenses/by/4.0/ + * + * Unless required by applicable law or agreed to in writing, documentation + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * ============LICENSE_END============================================ + * + * ECOMP is a trademark and service mark of AT&T Intellectual Property. + */ +package org.onap.portalsdk.analytics.scheduler; + +import static org.mockito.Mockito.mock; +import static org.mockito.Mockito.when; + +import java.io.IOException; +import java.io.InputStream; +import java.math.BigDecimal; +import java.sql.Connection; +import java.sql.DatabaseMetaData; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.Statement; +import java.util.ArrayList; +import java.util.Date; +import java.util.List; + +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; +import javax.sql.DataSource; + +import org.junit.Before; +import org.junit.Test; +import org.junit.runner.RunWith; +import org.mockito.InjectMocks; +import org.mockito.Matchers; +import org.mockito.Mock; +import org.mockito.MockitoAnnotations; +import org.onap.portalsdk.analytics.error.ReportSQLException; +import org.onap.portalsdk.analytics.scheduler.SchedulerUtil.Executor; +import org.onap.portalsdk.analytics.system.AppUtils; +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.xmlobj.MockitoTestSuite; +import org.powermock.api.mockito.PowerMockito; +import org.powermock.core.classloader.annotations.PrepareForTest; +import org.powermock.modules.junit4.PowerMockRunner; + +@SuppressWarnings("static-access") +@RunWith(PowerMockRunner.class) +@PrepareForTest({ AppConstants.class, SchedulerUtil.class, Globals.class, AppUtils.class, DbUtils.class }) +public class SchedulerUtilTest { + + @InjectMocks + SchedulerUtil schedulerUtil; + + @Mock + Connection conn; + + @Mock + DatabaseMetaData dMData; + + + @Before + public void init() throws Exception { + PowerMockito.mockStatic(Globals.class); + PowerMockito.mockStatic(AppUtils.class); + PowerMockito.mockStatic(DbUtils.class); + DataSource ds = mock(DataSource.class); + when(ds.getConnection()).thenReturn(conn); + when(DbUtils.getConnection()).thenReturn(conn); + MockitoAnnotations.initMocks(this); + } + + MockitoTestSuite mockitoTestSuite = new MockitoTestSuite(); + HttpServletRequest mockedRequest = mockitoTestSuite.getMockedRequest(); + HttpServletResponse mockedResponse = mockitoTestSuite.getMockedResponse(); + + @Test + public void insertOrUpdateTest() throws Exception { + Statement stat = mock(Statement.class); + ResultSet rset = mock(ResultSet.class); + String sql = "select * 1"; + when(conn.createStatement()).thenReturn(stat); + when(stat.executeQuery(sql)).thenReturn(rset); + schedulerUtil.insertOrUpdate(sql); + } + + @Test + public void updateBinaryStreamTest() throws ReportSQLException, SQLException, IOException { + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + String sql = "select * 1"; + InputStream is = mock(InputStream.class); + BigDecimal id = BigDecimal.valueOf(10); + when(conn.getMetaData()).thenReturn(dMData); + when(dMData.getDatabaseProductName()).thenReturn("test"); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + schedulerUtil.updateBinaryStream(sql, id, is, 1); + } + + @Test(expected = ReportSQLException.class) + public void updateBinaryStreamExceptionTest() throws ReportSQLException, SQLException, IOException { + String sql = "select * 1"; + InputStream is = mock(InputStream.class); + BigDecimal id = BigDecimal.valueOf(10); + when(conn.getMetaData()).thenReturn(dMData); + when(dMData.getDatabaseProductName()).thenReturn("oracle"); + schedulerUtil.updateBinaryStream(sql, id, is, 1); + } + + @Test + public void insertOrUpdateWithBigINTPreparedTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add(BigDecimal.valueOf(2)); + types.add(-5); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + @Test + public void insertOrUpdateWithPreparedTimestampTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add(new java.sql.Timestamp(1)); + types.add(93); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + + @Test + public void insertOrUpdateWithPreparedDateTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add(new java.sql.Date(1)); + types.add(91); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + @Test + public void insertOrUpdateWithPreparedDoubleTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add(Double.valueOf(12)); + types.add(8); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + @Test + public void insertOrUpdateWithPreparedIntegerTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add(2); + types.add(4); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + @Test + public void insertOrUpdateWithPreparedNumericTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add(Long.valueOf(1)); + types.add(2); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + + @Test + public void insertOrUpdateWithPreparedVarcharTest() throws ReportSQLException, SQLException { + String sql = "select * 1"; + List<Object> params = new ArrayList<>(); + List<Integer> types = new ArrayList<>(); + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + when(conn.getMetaData()).thenReturn(dMData); + when(conn.prepareStatement(sql)).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + params.add("test"); + types.add(12); + schedulerUtil.insertOrUpdateWithPrepared(sql, params, types); + } + + @Test + public void getSingleResultTest() throws ReportSQLException, SQLException { + Statement stat = mock(Statement.class); + ResultSet rset = mock(ResultSet.class); + String sql = "select * 1"; + rset.setFetchSize(1); + when(conn.createStatement()).thenReturn(stat); + when(stat.executeQuery(sql)).thenReturn(rset); + Object obj = "test"; + when(rset.getObject(Matchers.anyString())).thenReturn(obj); + schedulerUtil.getSingleResult(sql, "test"); + } + + @Test(expected = NullPointerException.class) + public void getDBStreamTest() throws ReportSQLException, SQLException, IOException { + PreparedStatement stat = mock(PreparedStatement.class); + ResultSet rset = mock(ResultSet.class); + String sql = "select * 1"; + when(conn.getMetaData()).thenReturn(dMData); + when(dMData.getDatabaseProductName()).thenReturn("test"); + when(conn.createStatement()).thenReturn(stat); + when(stat.executeQuery()).thenReturn(rset); + schedulerUtil.getDBStream(sql, "test"); + } + + @Test + public void getAndExecuteTest() throws ReportSQLException, SQLException { + Statement stat = mock(Statement.class); + ResultSet rset = mock(ResultSet.class); + String sql = "select * 1"; + rset.setFetchSize(1); + when(conn.createStatement()).thenReturn(stat); + when(stat.executeQuery(sql)).thenReturn(rset); + Executor exe = mock(Executor.class); + schedulerUtil.getAndExecute(sql, exe); + } + + @Test + public void trunc_hourTest() { + schedulerUtil.trunc_hour(new Date()); + } + + @Test + public void add_hoursTest() { + schedulerUtil.add_hours(new Date(), 1); + } + + @Test + public void add_monthsTest() { + schedulerUtil.add_months(new Date(), 1); + } + + @Test + public void add_daysTest() { + schedulerUtil.add_days(new Date(), 1); + } + + @Test + public void to_dateTest() { + schedulerUtil.to_date("/", "1/1/1"); + } + + @Test + public void to_date_strTest() { + schedulerUtil.to_date_str(new Date(), ""); + } + + @Test + public void cr_dissecturlTest() { + schedulerUtil.cr_dissecturl("test&123", "1"); + } +} diff --git a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SendEmailTest.java b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SendEmailTest.java new file mode 100644 index 00000000..62b57987 --- /dev/null +++ b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SendEmailTest.java @@ -0,0 +1,130 @@ +/* + * ============LICENSE_START========================================== + * ONAP Portal SDK + * =================================================================== + * Copyright © 2017 AT&T Intellectual Property. All rights reserved. + * =================================================================== + * + * Unless otherwise specified, all software contained herein is licensed + * under the Apache License, Version 2.0 (the "License"); + * you may not use this software except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * Unless otherwise specified, all documentation contained herein is licensed + * under the Creative Commons License, Attribution 4.0 Intl. (the "License"); + * you may not use this documentation except in compliance with the License. + * You may obtain a copy of the License at + * + * https://creativecommons.org/licenses/by/4.0/ + * + * Unless required by applicable law or agreed to in writing, documentation + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * ============LICENSE_END============================================ + * + * ECOMP is a trademark and service mark of AT&T Intellectual Property. + */ +package org.onap.portalsdk.analytics.scheduler; + +import static org.mockito.Mockito.mock; +import static org.mockito.Mockito.when; + +import java.io.ByteArrayInputStream; +import java.io.FileInputStream; +import java.io.FileOutputStream; +import java.io.InputStream; +import java.math.BigDecimal; +import java.net.HttpURLConnection; +import java.net.URL; +import java.sql.Connection; +import java.sql.DatabaseMetaData; + +import javax.sql.DataSource; + +import org.junit.Before; +import org.junit.Test; +import org.junit.runner.RunWith; +import org.mockito.InjectMocks; +import org.mockito.Matchers; +import org.mockito.Mock; +import org.mockito.MockitoAnnotations; +import org.onap.portalsdk.analytics.system.AppUtils; +import org.onap.portalsdk.analytics.system.DbUtils; +import org.onap.portalsdk.analytics.system.Globals; +import org.onap.portalsdk.analytics.util.AppConstants; +import org.powermock.api.mockito.PowerMockito; +import org.powermock.core.classloader.annotations.PrepareForTest; +import org.powermock.modules.junit4.PowerMockRunner; + +@RunWith(PowerMockRunner.class) +@PrepareForTest({ AppConstants.class, SchedulerUtil.class, SendEmail.class, Globals.class, AppUtils.class, DbUtils.class }) +public class SendEmailTest { + + @InjectMocks + SendEmail sendEmail; + + @Mock + SchedulerUtil schedulerUtil; + + @Mock + Connection conn; + + @Mock + DatabaseMetaData dMData; + + String sql = "select * 1"; + + @Before + public void init() throws Exception { + PowerMockito.mockStatic(Globals.class); + PowerMockito.mockStatic(AppUtils.class); + PowerMockito.mockStatic(DbUtils.class); + DataSource ds = mock(DataSource.class); + when(ds.getConnection()).thenReturn(conn); + when(DbUtils.getConnection()).thenReturn(conn); + MockitoAnnotations.initMocks(this); + } + + + @Test + public void sendEmailTest() throws Exception { + FileOutputStream fileOut = mock(FileOutputStream.class); + FileInputStream fileIn = mock(FileInputStream.class); + PowerMockito.whenNew(FileInputStream.class).withArguments(Matchers.anyString()).thenReturn(fileIn); + PowerMockito.whenNew(FileOutputStream.class).withArguments(Matchers.anyString()).thenReturn(fileOut); + String obj = "test"; + when(Globals.getSchedulerUserEmails()).thenReturn("test"); + when(schedulerUtil.getSingleResult("select email from fn_user au, cr_report_schedule crs where CRS.SCHED_USER_ID = AU.USER_ID and CRS.SCHEDULE_ID = 1", "email")).thenReturn(obj); + when(schedulerUtil.getSingleResult("SELECT rep_id FROM cr_report_schedule WHERE schedule_id =1","rep_id")).thenReturn(BigDecimal.valueOf(12)); + when(Globals.getSequenceNextVal()).thenReturn("[sequenceName]"); + when(schedulerUtil.getSingleResult("[sequenceName]".replace("[sequenceName]", "seq_cr_report_file_history"),"ID")).thenReturn(Long.valueOf(10)); + when(Globals.getCurrentDateString()).thenReturn("test"); + when(schedulerUtil.getSingleResult("select translate(title||to_char( "+ Globals.getCurrentDateString() + ",'MM-dd-yyyyHH24:mm:ss'), " + + "'0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'||'():;.-`~^\\|'||chr(34)||chr(39)||chr(9)||' ', " + + "'0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')|| "+ 10 +" as title FROM cr_report WHERE rep_id = "+null, "title")).thenReturn("Test_file"); + URL u = PowerMockito.mock(URL.class); + String url = "http://test.com"; + when(Globals.getProjectFolder()).thenReturn("test_project"); + when(Globals.getOutputFolder()).thenReturn("test_output_folder"); + PowerMockito.whenNew(URL.class).withArguments(url).thenReturn(u); + HttpURLConnection huc = PowerMockito.mock(HttpURLConnection.class); + PowerMockito.when(u.openConnection()).thenReturn(huc); + PowerMockito.when(huc.getResponseCode()).thenReturn(200); + byte [] inBytes = "test_Input_Stream".getBytes(); + InputStream in = new ByteArrayInputStream(inBytes); + PowerMockito.when(huc.getInputStream()).thenReturn(in); + sendEmail.sendEmail("test", "test", "test", "test", "http://test.com", 2, 1, 1, false, 10); + } + +} diff --git a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SendNotificationsTest.java b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SendNotificationsTest.java new file mode 100644 index 00000000..904e48f3 --- /dev/null +++ b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/scheduler/SendNotificationsTest.java @@ -0,0 +1,118 @@ +/* + * ============LICENSE_START========================================== + * ONAP Portal SDK + * =================================================================== + * Copyright © 2017 AT&T Intellectual Property. All rights reserved. + * =================================================================== + * + * Unless otherwise specified, all software contained herein is licensed + * under the Apache License, Version 2.0 (the "License"); + * you may not use this software except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * Unless otherwise specified, all documentation contained herein is licensed + * under the Creative Commons License, Attribution 4.0 Intl. (the "License"); + * you may not use this documentation except in compliance with the License. + * You may obtain a copy of the License at + * + * https://creativecommons.org/licenses/by/4.0/ + * + * Unless required by applicable law or agreed to in writing, documentation + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * ============LICENSE_END============================================ + * + * ECOMP is a trademark and service mark of AT&T Intellectual Property. + */ +package org.onap.portalsdk.analytics.scheduler; + +import static org.mockito.Mockito.mock; +import static org.mockito.Mockito.when; + +import java.sql.Connection; +import java.sql.DatabaseMetaData; +import java.sql.ResultSet; +import java.sql.Statement; + +import javax.sql.DataSource; + +import org.junit.Before; +import org.junit.Test; +import org.junit.runner.RunWith; +import org.mockito.Matchers; +import org.mockito.Mock; +import org.mockito.MockitoAnnotations; +import org.mockito.invocation.InvocationOnMock; +import org.mockito.stubbing.Answer; +import org.onap.portalsdk.analytics.error.RaptorException; +import org.onap.portalsdk.analytics.scheduler.SchedulerUtil.Executor; +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.core.web.support.AppUtils; +import org.powermock.api.mockito.PowerMockito; +import org.powermock.core.classloader.annotations.PrepareForTest; +import org.powermock.modules.junit4.PowerMockRunner; + +@RunWith(PowerMockRunner.class) +@PrepareForTest({ AppConstants.class, SendNotifications.class, SchedulerUtil.class, SendEmail.class, Globals.class, AppUtils.class, + DbUtils.class }) +public class SendNotificationsTest { + + @Mock + SchedulerUtil schedulerUtil; + + @Mock + SendEmail sendEmail; + + @Mock + Connection conn; + + @Mock + DatabaseMetaData dMData; + + @Mock + Executor executor; + + @Before + public void init() throws Exception { + PowerMockito.mockStatic(Globals.class); + PowerMockito.mockStatic(AppUtils.class); + PowerMockito.mockStatic(DbUtils.class); + DataSource ds = mock(DataSource.class); + when(ds.getConnection()).thenReturn(conn); + when(DbUtils.getConnection()).thenReturn(conn); + MockitoAnnotations.initMocks(this); + PowerMockito.whenNew(SchedulerUtil.class).withNoArguments().thenReturn(schedulerUtil); + PowerMockito.doNothing().when(sendEmail).setSchedulerUtil(schedulerUtil); + } + + + @Test + public void send_notificationTest() throws RaptorException, Exception { + SendNotifications sendNotifications = new SendNotifications(); + Statement stat = mock(Statement.class); + ResultSet rset = mock(ResultSet.class); + when(Globals.getSchedulerInterval()).thenReturn(2147483647); + when(Globals.getAvailableSchedules()).thenReturn("test"); + when(Globals.getCurrentDateString()).thenReturn("test"); + when(schedulerUtil.getConnection()).thenReturn(conn); + when(conn.createStatement()).thenReturn(stat); + when(rset.getInt(Matchers.anyInt())).thenReturn(10); + when(rset.next()).thenReturn(true).thenReturn(false); + when(rset.getTimestamp("run_date")).thenReturn(new java.sql.Timestamp(0)); + when(stat.executeQuery(Matchers.anyString())).thenReturn(rset); + sendNotifications.send_notification("test", "test", "test", "test", 30); + } +} diff --git a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/PdfReportHandlerTest.java b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/PdfReportHandlerTest.java index 6214ea67..730d3547 100644 --- a/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/PdfReportHandlerTest.java +++ b/ecomp-sdk/epsdk-analytics/src/test/java/org/onap/portalsdk/analytics/xmlobj/PdfReportHandlerTest.java @@ -48,6 +48,7 @@ import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.ArrayList; +import java.util.HashMap; import java.util.List; import java.util.TreeMap; @@ -56,6 +57,7 @@ import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.junit.Before; +import org.junit.Ignore; import org.junit.Test; import org.junit.runner.RunWith; import org.mockito.InjectMocks; @@ -67,6 +69,7 @@ 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.pdf.PdfReportHandler; +import org.onap.portalsdk.analytics.model.runtime.ReportParamValues; import org.onap.portalsdk.analytics.model.runtime.ReportRuntime; import org.onap.portalsdk.analytics.system.AppUtils; import org.onap.portalsdk.analytics.system.ConnectionUtils; @@ -95,9 +98,10 @@ import org.powermock.core.classloader.annotations.PrepareForTest; import org.powermock.modules.junit4.PowerMockRunner; import com.lowagie.text.Document; +import com.lowagie.text.Image; @RunWith(PowerMockRunner.class) -@PrepareForTest({ PdfReportHandler.class, AppConstants.class, Globals.class, AppUtils.class, ReportWrapper.class, DataCache.class, +@PrepareForTest({ PdfReportHandler.class, PdfReportHandlerTest.class, AppConstants.class, Globals.class, AppUtils.class, ReportWrapper.class, DataCache.class, DbUtils.class, DataSet.class, Font.class, ReportLoader.class, ReportRuntime.class, Utils.class, ESAPI.class, Codec.class, SecurityCodecUtil.class, ConnectionUtils.class, XSSFilter.class, ReportDefinition.class, UserUtils.class}) public class PdfReportHandlerTest { @@ -117,6 +121,7 @@ public class PdfReportHandlerTest { HttpServletRequest mockedRequest = mockitoTestSuite.getMockedRequest(); HttpServletResponse mockedResponse = mockitoTestSuite.getMockedResponse(); + @Ignore @SuppressWarnings({ "rawtypes", "unchecked" }) @Test public void createPdfFileContentTest() throws Exception { @@ -156,6 +161,7 @@ public class PdfReportHandlerTest { pdfReportHandler.createPdfFileContent(mockedRequest, mockedResponse, 3); } + @Ignore @SuppressWarnings({ "rawtypes", "unchecked" }) @Test public void createPdfFileContentIfNotDashBoardTest() throws Exception { @@ -292,7 +298,7 @@ public class PdfReportHandlerTest { pdfReportHandler.createPdfFileContent(mockedRequest, mockedResponse, 3); } - + @Ignore @SuppressWarnings({ "rawtypes", "unchecked" }) @Test public void createPdfFileContentIfNotDashBoardAndTypeTwoTest() throws Exception { @@ -422,4 +428,108 @@ public class PdfReportHandlerTest { pdfReportHandler.createPdfFileContent(mockedRequest, mockedResponse, 2); } + @SuppressWarnings({ "rawtypes", "unchecked", "static-access" }) + @Test + public void createPdfFileContent2Test() throws Exception { + PowerMockito.mockStatic(Image.class); + Document doc = mock(Document.class); + CustomReportType crType = mock(CustomReportType.class); + + DataSet ds = mock(DataSet.class); + PowerMockito.whenNew(Document.class).withNoArguments().thenReturn(doc); + PowerMockito.when(doc.newPage()).thenReturn(true); + when(AppUtils.getUserID(mockedRequest)).thenReturn("test"); + ReportRuntime rr = mock(ReportRuntime.class); + ReportData rd = mock(ReportData.class); + when(Globals.isCoverPageNeeded()).thenReturn(true); + when(Globals.getSessionInfoForTheCoverPage()).thenReturn("test,test1"); + when(AppUtils.getRequestNvlValue(mockedRequest, "test1")).thenReturn("test1"); + when(rr.isPDFCoverPage()).thenReturn(true); + when(rr.getReportID()).thenReturn("test"); + when(rr.getPDFOrientation()).thenReturn("portait"); + when(AppUtils.getRequestNvlValue(mockedRequest, "multiplePieOrder")).thenReturn("row"); + when(AppUtils.getRequestNvlValue(mockedRequest, "multiplePieLabelDisplay")).thenReturn("test"); + when(AppUtils.getRequestNvlValue(mockedRequest, "chartDisplay")).thenReturn("3D"); + when(mockedRequest.getSession().getAttribute("report_runtime")).thenReturn(rr); + when(mockedRequest.getSession().getAttribute("dashboard_report_id")).thenReturn("test"); + ServletContext servConxt = mock(ServletContext.class); + when(mockedRequest.getSession().getServletContext()).thenReturn(servConxt); + when(servConxt.getRealPath(File.separator)).thenReturn("testpath"); + when(rr.getChartType()).thenReturn(AppConstants.GT_PIE_MULTIPLE); + when(rr.getDisplayChart()).thenReturn(true); + ArrayList paramNamePDFValues = new ArrayList(); + paramNamePDFValues.add("test1"); + paramNamePDFValues.add("test2"); + when(rr.getParamNameValuePairsforPDFExcel(mockedRequest, 2)).thenReturn(paramNamePDFValues); + when(rr.getFormFieldComments(mockedRequest)).thenReturn("test"); + when(rr.getLegendPosition()).thenReturn("test"); + when(rr.hideChartToolTips()).thenReturn(true); + when(AppUtils.getRequestNvlValue(mockedRequest, "hideLegend")).thenReturn("Y"); + when(rr.getLegendLabelAngle()).thenReturn("test"); + when(rr.getMaxLabelsInDomainAxis()).thenReturn("test"); + when(rr.getRangeAxisLowerLimit()).thenReturn("10"); + when(rr.getRangeAxisUpperLimit()).thenReturn("10"); + when(AppUtils.getRequestNvlValue(mockedRequest, "totalOnChart")).thenReturn("Y"); + List chartGroups = new ArrayList<>(); + when(rr.getAllChartGroups()).thenReturn(chartGroups); + ReportParamValues reportValues= new ReportParamValues(); + when(rr.getReportParamValues()).thenReturn(reportValues); + when(rr.getFormFieldFilled(rr.getChartLeftAxisLabel())).thenReturn("test"); + when(rr.getFormFieldFilled(rr.getChartRightAxisLabel())).thenReturn("test"); + HashMap requestParams = new HashMap<>(); + requestParams.put("", "test"); + + DataSourceList dataSourceList = new DataSourceList(); + + List<DataSourceType> list = new ArrayList<>(); + DataSourceType dataSourceType = new DataSourceType(); + dataSourceType.setTableName("test"); + dataSourceType.setRefTableId("1"); + dataSourceType.setTableId("1"); + List<DataColumnType> dataColumnTypeList = new ArrayList<>(); + DataColumnType dataColumnType = new DataColumnType(); + dataColumnType.setChartGroup("test"); + dataColumnType.setYAxis("test"); + dataColumnType.setColName("[test"); + dataColumnType.setColOnChart("LEGEND"); + dataColumnType.setDisplayName("chart_total"); + dataColumnType.setColId("1"); + dataColumnType.setTableId("1"); + dataColumnType.setDependsOnFormField("test"); + dataColumnType.setColType("DATE"); + dataColumnType.setCrossTabValue("ROW"); + dataColumnType.setPdfDisplayWidthInPxls("0.0"); + dataColumnType.setVisible(true); + dataColumnType.setCalculated(true); + dataColumnTypeList.add(dataColumnType); + DataColumnType dataColumnType1 = new DataColumnType(); + dataColumnType1.setCrossTabValue("COLUMN"); + dataColumnType1.setColId("1"); + dataColumnType1.setVisible(true); + dataColumnType1.setPdfDisplayWidthInPxls("1.0"); + dataColumnTypeList.add(dataColumnType1); + + DataColumnList dataColumnList = new DataColumnList(); + dataColumnList.dataColumn = dataColumnTypeList; + dataSourceType.setDataColumnList(dataColumnList); + list.add(dataSourceType); + dataSourceList.dataSource = list; + when(crType.getDataSourceList()).thenReturn(dataSourceList); + + when(Globals.getRequestParamtersMap(mockedRequest, false)).thenReturn(requestParams); + ds.set(0, "test"); + when(mockedRequest.getSession().getAttribute(AppConstants.RI_CHART_DATA)).thenReturn(ds); + when(rr.hasSeriesColumn()).thenReturn(true); + TreeMap values = new TreeMap<>(); + values.put("test", rr); + TreeMap values2 = new TreeMap<>(); + values2.put("test3", rd); + TreeMap values3 = new TreeMap<>(); + values3.put("test4", "c"); + when(mockedRequest.getSession().getAttribute(AppConstants.SI_DASHBOARD_REPORTRUNTIME_MAP)).thenReturn(values); + when(mockedRequest.getSession().getAttribute(AppConstants.SI_DASHBOARD_REPORTDATA_MAP)).thenReturn(values2); + when(mockedRequest.getSession().getAttribute(AppConstants.SI_DASHBOARD_DISPLAYTYPE_MAP)).thenReturn(values3); + pdfReportHandler.createPdfFileContent(mockedRequest, mockedResponse, 3); + } + } |