Enable junit test cases and fix defects.

Clean internal company domain names.
Repair defect for picking Role in Widget onboarding for assigned app.

Issue: PORTAL-50, PORTAL-82, PORTAL-86
Change-Id: I0826ddbfad1dc8a9bb6f3b8096b9748f887c1c65
Signed-off-by: Christopher Lott (cl778h) <clott@research.att.com>

1 files changed, 15 insertions, 0 deletions

diff --git a/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java b/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java
index 6a0da9ba..b51ea1a1 100644
--- a/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java
+++ b/ecomp-portal-BE-common/src/main/java/org/openecomp/portalapp/portal/service/EPAppCommonServiceImpl.java
@@ -770,6 +770,21 @@ public class EPAppCommonServiceImpl implements EPAppService {
 			logQuery(sql);
 			query = localSession.createSQLQuery(sql);
 			query.executeUpdate();
+			
+			
+			// Remove all roles, rolefunctions, appid records from ep_app_role_function
+			// that are associated with this app
+		    sql = "DELETE FROM ep_app_role_function WHERE app_id='" + appid + "'";
+			logger.debug(EELFLoggerDelegate.debugLogger, "Executing query: " + sql);
+			 query = localSession.createSQLQuery(sql);
+			query.executeUpdate();
+			
+			//Remove all rolefunctions, appid records from ep_app_function
+			// that are associated with this app
+			sql = "DELETE FROM ep_app_function WHERE app_id='" + appid + "'";
+			logger.debug(EELFLoggerDelegate.debugLogger, "Executing query: " + sql);
+			query = localSession.createSQLQuery(sql);
+			query.executeUpdate();
 
 			// Remove all records from fn_user_role associated with this app
 			sql = "delete from fn_user_role where app_id='" + appid + "'";