From d4d98f9674093637589fe3780d22756f02e92e1b Mon Sep 17 00:00:00 2001 From: Eylon Malin Date: Mon, 2 Sep 2019 16:13:02 +0300 Subject: remove not used feature RoleGenerator Issue-ID: VID-378 Signed-off-by: Eylon Malin Change-Id: I0eea2c7305f6faabcb1e54a7f4dd9f51fe37586f --- .../vid/services/RoleGenaratorServiceImpl.java | 191 --------------------- 1 file changed, 191 deletions(-) delete mode 100644 vid-app-common/src/main/java/org/onap/vid/services/RoleGenaratorServiceImpl.java (limited to 'vid-app-common/src/main/java/org/onap/vid/services/RoleGenaratorServiceImpl.java') diff --git a/vid-app-common/src/main/java/org/onap/vid/services/RoleGenaratorServiceImpl.java b/vid-app-common/src/main/java/org/onap/vid/services/RoleGenaratorServiceImpl.java deleted file mode 100644 index 815c85d6f..000000000 --- a/vid-app-common/src/main/java/org/onap/vid/services/RoleGenaratorServiceImpl.java +++ /dev/null @@ -1,191 +0,0 @@ -/*- - * ============LICENSE_START======================================================= - * VID - * ================================================================================ - * Copyright (C) 2017 - 2019 AT&T Intellectual Property. All rights reserved. - * Modifications Copyright (C) 2018 - 2019 Nokia. All rights reserved. - * ================================================================================ - * 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. - * ============LICENSE_END========================================================= - */ - -package org.onap.vid.services; - -import io.joshworks.restclient.http.HttpResponse; -import jline.internal.Log; -import org.onap.vid.aai.*; -import org.onap.vid.model.ModelConstants; -import org.onap.vid.model.Subscriber; -import org.onap.vid.model.SubscriberList; -import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.stereotype.Service; - -import java.util.HashMap; - -@Service -public class RoleGenaratorServiceImpl implements RoleGeneratorService { - - public static final String ROLE_ID_COLUMN = "ROLE_ID"; - - @Autowired - AaiClientInterface client; - - @Autowired - AaiOverTLSClientInterface aaiOverTLSClient; - - public static final String DB_NAME = "vid_portal"; - public static final String TBL_NAME = "fn_role"; - public static final String TEMP_DELIMITER ="***"; - public static final String OLD_DELIMITER = "_"; - public static final String CrLf = ";\r\n"; - - @Override - public String generateRoleScript(Boolean firstRun) { - String query = "USE " + DB_NAME + CrLf + - "SET SQL_SAFE_UPDATES = 0;\r\n"; - try { - HttpResponse allSubscribers = aaiOverTLSClient.getAllSubscribers(); - if (firstRun) { - query += replaceRolesToTempDelimiter("subscriber",buildSubscribersValuesForMappingsTable(allSubscribers.getBody())); - } - query += addAvailableRolesCombination(firstRun, allSubscribers.getBody()); - - } - catch (Exception e) { - Log.error("There was an error in updating roles ", e); - } - return query; - } - - private String addAvailableRolesCombination(Boolean firstRun, SubscriberList subscribers) { - String query; - String availableRoles=""; - HashMap servicesNames = new HashMap<>(); - for (Subscriber subscriber: subscribers.customer) { - AaiResponse subscriberResponse = client.getSubscriberData(subscriber.globalCustomerId, true); - for(ServiceSubscription service: subscriberResponse.getT().serviceSubscriptions.serviceSubscription) { - servicesNames.put(service.serviceType,""); - String roleName = "'" + subscriber.subscriberName + ModelConstants.ROLE_DELIMITER + service.serviceType + "'"; - availableRoles += "("+roleName+"),"; - - - } - } - availableRoles = availableRoles.substring(0,availableRoles.length()-1); - query = createTemporaryTableAvailableRoles(availableRoles); - if (firstRun){ - query += replaceRolesToTempDelimiter("service",buildServicesValuesForMappingsTable(servicesNames)); - query += replaceToNewDelimiter(); - query += deleteWrongRecords(); - - } - query += insertAvailableRolesToFnRole(); - query += dropTemporaryTable("available_roles"); - return query; - } - - private String buildSubscribersValuesForMappingsTable(SubscriberList subscribers){ - String query=""; - for (Subscriber subscriber : subscribers.customer) { - String subscriberName = subscriber.subscriberName.contains(OLD_DELIMITER) ? subscriber.subscriberName.replace(OLD_DELIMITER, TEMP_DELIMITER) : subscriber.subscriberName; - query = query + "('" + subscriber.globalCustomerId + "','" + subscriberName + "') ,"; - } - if(query.length() > 0) - query = query.substring(0, query.length()-1) + CrLf; - return query; - } - - private String buildServicesValuesForMappingsTable(HashMap servicesNames){ - final String[] query = {""}; - servicesNames.forEach((k,v)->{ - if (k.contains(OLD_DELIMITER)) { - query[0] += "('" + k + "' ,'" + k.replace(OLD_DELIMITER, TEMP_DELIMITER) +"'),"; - } - }); - if(query[0].length() > 0) - query[0] = query[0].substring(0, query[0].length()-1) + CrLf; - return query[0]; - } - - private String replaceRolesToTempDelimiter(String entityName, String valuesForMappingsTable ) { - - AaiResponse services = client.getServices(); - String query = ""; - if (valuesForMappingsTable.length() > 0) { - query = "CREATE TEMPORARY TABLE IF NOT EXISTS " + entityName + "Mappings(mapKey VARCHAR(255),mapValue VARCHAR(255));\r\n" + - "INSERT INTO " + entityName + "Mappings VALUES "; - query += valuesForMappingsTable; - query += "UPDATE " + TBL_NAME + "\r\n" + - "INNER JOIN " + entityName + "Mappings ON role_name LIKE concat('%',mapKey, '%')\r\n" + - "SET ROLE_NAME = REPLACE(ROLE_NAME, mapKey, mapValue) ; \r\n" + - dropTemporaryTable(entityName + "Mappings"); - } - return query; - } - - private String replaceToNewDelimiter(){ - String query = "UPDATE " + TBL_NAME + "\r\n" + - "SET ROLE_NAME = REPLACE(ROLE_NAME, '" + OLD_DELIMITER + "', '" + ModelConstants.ROLE_DELIMITER + "');\r\n" ; - query += "UPDATE fn_role\r\n" + - "SET ROLE_NAME = REPLACE(ROLE_NAME, '" + TEMP_DELIMITER + "', '" + OLD_DELIMITER + "');\r\n" ; - return query; - } - - private String insertAvailableRolesToFnRole(){ - return "INSERT INTO fn_role (ROLE_NAME, ACTIVE_YN, PRIORITY)\r\n" + - "SELECT RNAME, 'Y', 5\r\n" + - "FROM available_roles\r\n" + - "WHERE NOT EXISTS (SELECT ROLE_NAME\r\n" + - "FROM fn_role \r\n" + - "where RNAME = ROLE_NAME);\r\n"; - } - - - - private String createTemporaryTableAvailableRoles(String availableRoles) { - String query = "CREATE TEMPORARY TABLE IF NOT EXISTS available_roles(rname VARCHAR(255));\r\n"; - query += "INSERT INTO available_roles VALUES "+availableRoles+CrLf; - return query; - } - - private String deleteWrongRecords(){ - String query ="CREATE TEMPORARY TABLE IF NOT EXISTS wrong_roles(roleID INT);\r\n" + - "INSERT INTO wrong_roles (roleID)\r\n" + - "SELECT ROLE_ID FROM fn_role LEFT JOIN available_roles ON role_name LIKE concat(rname, '%')\r\n" + - "WHERE available_roles.rname IS NULL AND ROLE_ID NOT IN (1,16);\r\n"; - query += deleteCascade(); - query += dropTemporaryTable("wrong_roles"); - return query; - } - - private String deleteCascade() { - String query = deleteFromTableByRoles("fn_role_composite", "PARENT_ROLE_ID"); - query = query.substring(0, query.length()-1); - query += " OR wrong_roles.ROLEID = fn_role_composite.CHILD_ROLE_ID;\r\n"; - query += deleteFromTableByRoles("fn_role_function", ROLE_ID_COLUMN)+ "\r\n"; - query += deleteFromTableByRoles("fn_user_role", ROLE_ID_COLUMN)+ "\r\n"; - query += deleteFromTableByRoles(TBL_NAME, ROLE_ID_COLUMN)+ "\r\n"; - return query; - } - - private String deleteFromTableByRoles(String table, String column) { - String query = "DELETE FROM " + table + "\r\n"; - query += "using " + table + " inner join wrong_roles\r\n" + - "where wrong_roles.ROLEID = " + table + "." + column + ";"; - return query; - } - - private String dropTemporaryTable(String table) { - return "DROP TEMPORARY TABLE IF EXISTS " + table + CrLf; - } -} -- cgit 1.2.3-korg