From 7f535078ef80a7b7efa3e3325bfccb994fbd00e8 Mon Sep 17 00:00:00 2001 From: "Christopher Lott (cl778h)" Date: Thu, 31 Aug 2017 15:16:38 -0400 Subject: Rename packages to org.onap in 1.4.0-SNAPSHOT 19 - remove openecomp 72 - remediate Sonar scan issues 79 - removed unwanted left menu under Report 90 - apply approved license text Issue: PORTAL-19, PORTAL-72, PORTAL-79, PORTAL-90 Change-Id: I41a0ef5fba623d2242574bd15f2d9fb8029a496c Signed-off-by: Christopher Lott (cl778h) --- .../analytics/util/upgrade/SystemUpgrade.java | 127 --------------------- 1 file changed, 127 deletions(-) delete mode 100644 ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/util/upgrade/SystemUpgrade.java (limited to 'ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/util/upgrade/SystemUpgrade.java') diff --git a/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/util/upgrade/SystemUpgrade.java b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/util/upgrade/SystemUpgrade.java deleted file mode 100644 index 999c4f46..00000000 --- a/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/util/upgrade/SystemUpgrade.java +++ /dev/null @@ -1,127 +0,0 @@ -/*- - * ================================================================================ - * ECOMP Portal SDK - * ================================================================================ - * Copyright (C) 2017 AT&T Intellectual Property - * ================================================================================ - * Licensed under the Apache License, Version 2.0 (the "License"); - * you may not use this file 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. - * ================================================================================ - */ -package org.openecomp.portalsdk.analytics.util.upgrade; - -import java.io.*; -import java.sql.*; -import java.util.*; -import javax.servlet.http.*; - -import org.openecomp.portalsdk.analytics.controller.*; -import org.openecomp.portalsdk.analytics.error.*; -import org.openecomp.portalsdk.analytics.model.*; -import org.openecomp.portalsdk.analytics.model.base.*; -import org.openecomp.portalsdk.analytics.model.definition.*; -import org.openecomp.portalsdk.analytics.model.runtime.*; -import org.openecomp.portalsdk.analytics.system.*; -import org.openecomp.portalsdk.analytics.util.*; -import org.openecomp.portalsdk.analytics.view.*; -import org.openecomp.portalsdk.analytics.xmlobj.*; - -public class SystemUpgrade extends org.openecomp.portalsdk.analytics.RaptorObject { - private static final String upgradeFromVersion = "1.x"; - private static final String upgradeToVersion = "2.0"; - -/* This script upgrades the Raptor database to a newer version - Make sure you execute the "upgrade_v0_to_v1_0_before_java.sql" before running this - and "upgrade_v0_to_v1_0_after_java.sql" afterwards - - URL example: http://localhost:8082/databank/dispatcher?action=raptor&r_action=system_upgrade -*/ - public static String upgradeDB(HttpServletRequest request) { - request.setAttribute("system_message", "System upgrade disabled"); - return "raptor/blank.jsp"; - -/* try { - if(upgradeFromVersion.equals("1.x")&&upgradeToVersion.equals("2.0")) - upgrateFromV1ToV2_0(request); - else - throw new RuntimeException("Invalid version"); - - return "raptor/blank.jsp"; - } catch(Exception e) { - return (new ErrorHandler()).processFatalError(request, e); - }*/ - } // upgradeDB - - private static void upgrateFromV1ToV2_0(HttpServletRequest request) throws Exception { - StringBuffer log = new StringBuffer(); - log.append("Starting upgrade...
\n"); - - DataSet ds = DbUtils.executeQuery("SELECT cr.rep_id, cr.sched_mailto_user_ids FROM cr_report cr"); - for(int i=0; iProcessing report ["+repId+"]: "); - - Connection connection = DbUtils.startTransaction(); - String emailIds = nvls(ds.getString(i, 1)); - if(emailIds.length()>0) - try { - log.append("Converting emails "); - StringTokenizer st = new StringTokenizer(emailIds, ","); - while(st.hasMoreTokens()) { - String userId = nvls(st.nextToken()); - log.append(userId); - if(userId.length()>0) - DbUtils.executeUpdate(connection, "INSERT INTO cr_report_schedule_users (rep_id, user_id) VALUES ("+repId+", "+userId+")"); - log.append("-success, "); - } // while - log.append(" COMPLETED; "); - } catch(Exception e) { - log.append("-FAILED; "); - } - - String reportXML = ReportLoader.loadCustomReportXML(repId); - ReportDefinition rdef = ReportDefinition.unmarshal(reportXML, repId, request); - ReportWrapper rw = new ReportWrapper(rdef.cloneCustomReport(), repId, null, null, null, null, null, null, false); - - for(Iterator iter=rw.getAllColumns().iterator(); iter.hasNext(); ) { - DataColumnType col = (DataColumnType) iter.next(); - String drillDownURL = nvls(col.getDrillDownURL()); - if(drillDownURL.startsWith("dispatcher?action=custrep.run&c_master=")) { - drillDownURL = AppUtils.getReportExecuteActionURL()+drillDownURL.substring("dispatcher?action=custrep.run&c_master=".length()); - log.append("Drill-down processed; "); - col.setDrillDownURL(drillDownURL); - } - } // for - - reportXML = rw.marshal(); - - /*PrintWriter xmlOut = new PrintWriter(new BufferedWriter(new FileWriter(new File(AppUtils.getTempFolderPath()+AppUtils.getUserID(request))))); - xmlOut.println(reportXML); - xmlOut.close();*/ - - try { - ReportLoader.updateCustomReportRec(connection, rw, reportXML); - DbUtils.commitTransaction(connection); - log.append("REPORT UPDATED\n"); - } catch(Exception e) { - log.append("REPORT UPDATE FAILED\n"); - DbUtils.rollbackTransaction(connection); - } finally { - DbUtils.clearConnection(connection); - } - } // for - - log.append("
\nSystem upgrade successfully completed...
\n"); - request.setAttribute("system_message", log.toString()); - } // upgrateFromV1ToV2_0 - -} // SystemUpgrade -- cgit 1.2.3-korg