ecomp-portal-BE-common/src/test/java/org/onap/portalapp/portal/service/UserRolesCommonServiceImplTest.java

   1 /*-
   2  * ============LICENSE_START==========================================
   3  * ONAP Portal
   4  * ===================================================================
   5  * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
   6  * ===================================================================
   7  *
   8  * Unless otherwise specified, all software contained herein is licensed
   9  * under the Apache License, Version 2.0 (the "License");
  10  * you may not use this software except in compliance with the License.
  11  * You may obtain a copy of the License at
  12  *
  13  *             http://www.apache.org/licenses/LICENSE-2.0
  14  *
  15  * Unless required by applicable law or agreed to in writing, software
  16  * distributed under the License is distributed on an "AS IS" BASIS,
  17  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  18  * See the License for the specific language governing permissions and
  19  * limitations under the License.
  20  *
  21  * Unless otherwise specified, all documentation contained herein is licensed
  22  * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
  23  * you may not use this documentation except in compliance with the License.
  24  * You may obtain a copy of the License at
  25  *
  26  *             https://creativecommons.org/licenses/by/4.0/
  27  *
  28  * Unless required by applicable law or agreed to in writing, documentation
  29  * distributed under the License is distributed on an "AS IS" BASIS,
  30  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  31  * See the License for the specific language governing permissions and
  32  * limitations under the License.
  33  *
  34  * ============LICENSE_END============================================
  35  *
  36  *
  37  */
  38 package org.onap.portalapp.portal.service;
  39
  40 import static org.junit.Assert.assertEquals;
  41 import static org.junit.Assert.assertFalse;
  42 import static org.junit.Assert.assertNotEquals;
  43 import static org.junit.Assert.assertNull;
  44 import static org.junit.Assert.assertTrue;
  45
  46 import java.util.ArrayList;
  47 import java.util.Date;
  48 import java.util.HashMap;
  49 import java.util.List;
  50 import java.util.Map;
  51 import java.util.Set;
  52 import java.util.SortedSet;
  53 import java.util.TreeSet;
  54
  55 import javax.servlet.http.HttpServletResponse;
  56
  57 import org.apache.cxf.transport.http.HTTPException;
  58 import org.hibernate.Query;
  59 import org.hibernate.SQLQuery;
  60 import org.hibernate.Session;
  61 import org.hibernate.SessionFactory;
  62 import org.hibernate.Transaction;
  63 import org.json.JSONObject;
  64 import org.junit.After;
  65 import org.junit.Before;
  66 import org.junit.Test;
  67 import org.junit.runner.RunWith;
  68 import org.mockito.InjectMocks;
  69 import org.mockito.Matchers;
  70 import org.mockito.Mock;
  71 import org.mockito.Mockito;
  72 import org.mockito.MockitoAnnotations;
  73 import org.onap.portalapp.externalsystemapproval.model.ExternalSystemRoleApproval;
  74 import org.onap.portalapp.externalsystemapproval.model.ExternalSystemUser;
  75 import org.onap.portalapp.portal.core.MockEPUser;
  76 import org.onap.portalapp.portal.domain.EPApp;
  77 import org.onap.portalapp.portal.domain.EPRole;
  78 import org.onap.portalapp.portal.domain.EPUser;
  79 import org.onap.portalapp.portal.domain.EPUserApp;
  80 import org.onap.portalapp.portal.domain.EPUserAppCatalogRoles;
  81 import org.onap.portalapp.portal.domain.EPUserAppRoles;
  82 import org.onap.portalapp.portal.domain.EPUserAppRolesRequest;
  83 import org.onap.portalapp.portal.domain.EPUserAppRolesRequestDetail;
  84 import org.onap.portalapp.portal.domain.ExternalSystemAccess;
  85 import org.onap.portalapp.portal.transport.AppWithRolesForUser;
  86 import org.onap.portalapp.portal.transport.CentralV2Role;
  87 import org.onap.portalapp.portal.transport.EPUserAppCurrentRoles;
  88 import org.onap.portalapp.portal.transport.EcompUserAppRoles;
  89 import org.onap.portalapp.portal.transport.ExternalRequestFieldsValidator;
  90 import org.onap.portalapp.portal.transport.FieldsValidator;
  91 import org.onap.portalapp.portal.transport.FunctionalMenuItem;
  92 import org.onap.portalapp.portal.transport.FunctionalMenuRole;
  93 import org.onap.portalapp.portal.transport.RemoteRole;
  94 import org.onap.portalapp.portal.transport.RemoteUserWithRoles;
  95 import org.onap.portalapp.portal.transport.RoleInAppForUser;
  96 import org.onap.portalapp.portal.transport.UserApplicationRoles;
  97 import org.onap.portalapp.portal.utils.EPCommonSystemProperties;
  98 import org.onap.portalapp.portal.utils.EcompPortalUtils;
  99 import org.onap.portalapp.portal.utils.PortalConstants;
 100 import org.onap.portalsdk.core.domain.Role;
 101 import org.onap.portalsdk.core.restful.domain.EcompRole;
 102 import org.onap.portalsdk.core.service.DataAccessService;
 103 import org.onap.portalsdk.core.service.DataAccessServiceImpl;
 104 import org.onap.portalsdk.core.service.RoleServiceImpl;
 105 import org.onap.portalsdk.core.util.SystemProperties;
 106 import org.powermock.api.mockito.PowerMockito;
 107 import org.powermock.core.classloader.annotations.PrepareForTest;
 108 import org.powermock.modules.junit4.PowerMockRunner;
 109 import org.springframework.http.HttpEntity;
 110 import org.springframework.http.HttpHeaders;
 111 import org.springframework.http.HttpMethod;
 112 import org.springframework.http.HttpStatus;
 113 import org.springframework.http.ResponseEntity;
 114 import org.springframework.web.client.RestTemplate;
 115
 116 import com.fasterxml.jackson.core.JsonProcessingException;
 117 import com.fasterxml.jackson.databind.ObjectMapper;
 118
 119 @RunWith(PowerMockRunner.class)
 120 @PrepareForTest({ EcompPortalUtils.class, SystemProperties.class, PortalConstants.class,
 121                 EPCommonSystemProperties.class })
 122 public class UserRolesCommonServiceImplTest {
 123
 124         @Mock
 125         DataAccessService dataAccessService = new DataAccessServiceImpl();
 126
 127         @Mock
 128         EPAppCommonServiceImpl epAppCommonServiceImpl = new EPAppCommonServiceImpl();
 129
 130         @Mock
 131         ExternalAccessRolesServiceImpl externalAccessRolesServiceImpl = new ExternalAccessRolesServiceImpl();
 132
 133         @Mock
 134         ApplicationsRestClientService applicationsRestClientService;
 135
 136         @Mock
 137         RoleServiceImpl roleServiceImpl = new RoleServiceImpl();
 138
 139         @Mock
 140         SearchServiceImpl searchServiceImpl = new SearchServiceImpl();
 141
 142         @Mock
 143         EPRoleServiceImpl epRoleServiceImpl = new EPRoleServiceImpl();
 144
 145         @Mock
 146         RestTemplate template = new RestTemplate();
 147
 148         @Mock
 149         SessionFactory sessionFactory;
 150
 151         @Mock
 152         Session session;
 153
 154         @Mock
 155         Transaction transaction;
 156
 157         @InjectMocks
 158         UserRolesCommonServiceImpl userRolesCommonServiceImpl = new UserRolesCommonServiceImpl();
 159
 160         @Before
 161         public void setup() {
 162                 MockitoAnnotations.initMocks(this);
 163                 Mockito.when(sessionFactory.openSession()).thenReturn(session);
 164                 Mockito.when(session.beginTransaction()).thenReturn(transaction);
 165         }
 166
 167         @After
 168         public void after() {
 169                 session.close();
 170         }
 171
 172         MockEPUser mockUser = new MockEPUser();
 173
 174         public EPApp mockApp() {
 175                 EPApp app = new EPApp();
 176                 app.setName("Test");
 177                 app.setImageUrl("test");
 178                 app.setDescription("test");
 179                 app.setNotes("test");
 180                 app.setUrl("test");
 181                 app.setId((long) 1);
 182                 app.setAppRestEndpoint("test");
 183                 app.setAlternateUrl("test");
 184                 app.setName("test");
 185                 app.setMlAppName("test");
 186                 app.setMlAppAdminId("test");
 187                 app.setUsername("test");
 188                 app.setAppPassword("test");
 189                 app.setOpen(false);
 190                 app.setEnabled(false);
 191                 app.setCentralAuth(true);
 192                 app.setUebKey("test");
 193                 app.setUebSecret("test");
 194                 app.setUebTopicName("test");
 195                 app.setAppType(1);
 196                 return app;
 197         }
 198
 199         @SuppressWarnings("unchecked")
 200         @Test
 201         public void getAppRolesForUserCentralizedForPortal() throws Exception {
 202                 EPUser user = mockUser.mockEPUser();
 203                 EPApp mockApp = mockApp();
 204                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
 205                 List<RoleInAppForUser> mockRoleInAppForUserList = getMockedRoleInAppUserList();
 206                 List<CentralV2Role> mockCenV2Role = new ArrayList<>();
 207                 CentralV2Role cenV2Role = new CentralV2Role(1l, null, null, null, null, null, "test1", true, null,
 208                                 new TreeSet<>(), new TreeSet<>(), new TreeSet<>());
 209                 CentralV2Role cenV2Role2 = new CentralV2Role(16l, null, null, null, null, null, "test2", true, null,
 210                                 new TreeSet<>(), new TreeSet<>(), new TreeSet<>());
 211                 mockCenV2Role.add(cenV2Role);
 212                 mockCenV2Role.add(cenV2Role2);
 213                 Mockito.when(externalAccessRolesServiceImpl.getRolesForApp(mockApp.getUebKey())).thenReturn(mockCenV2Role);
 214                 List<EPUser> mockUserList = new ArrayList<>();
 215                 mockUserList.add(user);
 216                 Mockito.when((List<EPUser>) dataAccessService
 217                                 .executeQuery("from EPUser where orgUserId='" + user.getOrgUserId() + "'", null))
 218                                 .thenReturn(mockUserList);
 219                 Mockito.when(userRolesCommonServiceImpl.getAppRolesForUser(1l, user.getOrgUserId(), true, user))
 220                                 .thenReturn(mockRoleInAppForUserList);
 221                 List<RoleInAppForUser> roleInAppForUser = userRolesCommonServiceImpl.getAppRolesForUser(1l, "test", true, user);
 222                 assertEquals(roleInAppForUser, mockRoleInAppForUserList);
 223         }
 224
 225         private List<RoleInAppForUser> getMockedRoleInAppUserList() {
 226                 List<RoleInAppForUser> mockRoleInAppForUserList = new ArrayList<>();
 227                 RoleInAppForUser mockRoleInAppForUser = new RoleInAppForUser();
 228                 mockRoleInAppForUser.setIsApplied(false);
 229                 mockRoleInAppForUser.setRoleId(1l);
 230                 mockRoleInAppForUser.setRoleName("test1");
 231                 RoleInAppForUser mockRoleInAppForUser2 = new RoleInAppForUser();
 232                 mockRoleInAppForUser2.setIsApplied(false);
 233                 mockRoleInAppForUser2.setRoleId(16l);
 234                 mockRoleInAppForUser2.setRoleName("test2");
 235                 mockRoleInAppForUserList.add(mockRoleInAppForUser);
 236                 mockRoleInAppForUserList.add(mockRoleInAppForUser2);
 237                 return mockRoleInAppForUserList;
 238         }
 239
 240         @SuppressWarnings("unchecked")
 241         @Test
 242         public void getAppRolesForUserNonCentralizedForPortal() throws Exception {
 243                 EPUser user = mockUser.mockEPUser();
 244                 user.setId(1l);
 245                 EPApp mockApp = mockApp();
 246                 mockApp.setCentralAuth(false);
 247                 EPRole mockEPRole = new EPRole();
 248                 mockEPRole.setId(1l);
 249                 mockEPRole.setName("test1");
 250                 mockEPRole.setActive(true);
 251                 SortedSet<EPUserApp> mockUserApps = new TreeSet<EPUserApp>();
 252                 EPUserApp mockEPUserApp = new EPUserApp();
 253                 mockEPUserApp.setApp(mockApp);
 254                 mockEPUserApp.setRole(mockEPRole);
 255                 mockEPUserApp.setUserId(1l);
 256                 mockUserApps.add(mockEPUserApp);
 257                 user.setEPUserApps(mockUserApps);
 258                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
 259                 List<RoleInAppForUser> mockRoleInAppForUserListNonCentralizedList = getMockedRoleInAppUserList();
 260                 List<Role> mockRole = new ArrayList<>();
 261                 Role role = new Role();
 262                 role.setId(1l);
 263                 role.setName("test1");
 264                 role.setActive(true);
 265                 Role role2 = new Role();
 266                 role.setId(16l);
 267                 role.setName("test2");
 268                 role.setActive(true);
 269                 mockRole.add(role);
 270                 mockRole.add(role2);
 271                 Mockito.when(roleServiceImpl.getAvailableRoles(user.getOrgUserId())).thenReturn(mockRole);
 272                 List<EPUser> mockUserList = new ArrayList<>();
 273                 mockUserList.add(user);
 274                 Mockito.when((List<EPUser>) dataAccessService
 275                                 .executeQuery("from EPUser where orgUserId='" + user.getOrgUserId() + "'", null))
 276                                 .thenReturn(mockUserList);
 277                 Mockito.when(userRolesCommonServiceImpl.getAppRolesForUser(1l, user.getOrgUserId(), true, user))
 278                                 .thenReturn(mockRoleInAppForUserListNonCentralizedList);
 279                 List<RoleInAppForUser> roleInAppForUserNonCentralized = userRolesCommonServiceImpl.getAppRolesForUser(1l,
 280                                 user.getOrgUserId(), true, user);
 281                 assertNull(roleInAppForUserNonCentralized);
 282         }
 283
 284         @Test
 285         public void getAppRolesForCentralizedPartnerAppTest() throws Exception {
 286                 EPUser user = mockUser.mockEPUser();
 287                 EPApp mockApp = mockApp();
 288                 mockApp.setId(2l);
 289                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
 290                 List<RoleInAppForUser> mockRoleInAppForUserList = getMockedRoleInAppUserList();
 291                 List<EPRole> mockEPRoleList = new ArrayList<>();
 292                 EPRole mockEpRole = new EPRole();
 293                 mockEpRole.setActive(true);
 294                 mockEpRole.setAppId(2l);
 295                 mockEpRole.setName("test1");
 296                 mockEpRole.setAppRoleId(333l);
 297                 mockEpRole.setId(1l);
 298                 EPRole mockEpRole2 = new EPRole();
 299                 mockEpRole2.setActive(true);
 300                 mockEpRole2.setAppId(2l);
 301                 mockEpRole2.setName("test2");
 302                 mockEpRole2.setAppRoleId(444l);
 303                 mockEpRole2.setId(16l);
 304                 mockEPRoleList.add(mockEpRole);
 305                 mockEPRoleList.add(mockEpRole2);
 306                 final Map<String, Long> appParams = new HashMap<>();
 307                 appParams.put("appId", 2l);
 308                 Mockito.when(dataAccessService.executeNamedQuery("getActiveRolesOfApplication", appParams, null))
 309                                 .thenReturn(mockEPRoleList);
 310                 final Map<String, String> params = new HashMap<>();
 311                 params.put("orgUserIdValue", "guestT");
 312                 List<EPUser> mockEPUserList = new ArrayList<>();
 313                 mockEPUserList.add(user);
 314                 Mockito.when(dataAccessService.executeNamedQuery("epUserAppId", params, null)).thenReturn(mockEPUserList);
 315                 final Map<String, Long> userParams = new HashMap<>();
 316                 userParams.put("appId", mockApp.getId());
 317                 userParams.put("userId", mockEPUserList.get(0).getId());
 318                 List<EPUserAppCurrentRoles> epUserAppCurrentRolesList = new ArrayList<>();
 319                 EPUserAppCurrentRoles epUserAppCurrentRoles = new EPUserAppCurrentRoles();
 320                 epUserAppCurrentRoles.setRoleId(444l);
 321                 epUserAppCurrentRoles.setRoleName("TestPartnerRole2");
 322                 epUserAppCurrentRoles.setUserId(mockEPUserList.get(0).getId());
 323                 epUserAppCurrentRolesList.add(epUserAppCurrentRoles);
 324                 Mockito.when(dataAccessService.executeNamedQuery("getUserAppCurrentRoles", userParams, null))
 325                                 .thenReturn(epUserAppCurrentRolesList);
 326                 Mockito.when(userRolesCommonServiceImpl.getAppRolesForUser(2l, user.getOrgUserId(), true, user))
 327                                 .thenReturn(mockRoleInAppForUserList);
 328                 List<RoleInAppForUser> roleInAppForUser = userRolesCommonServiceImpl.getAppRolesForUser(2l, user.getOrgUserId(),
 329                                 true, user);
 330                 assertNotEquals(roleInAppForUser, mockRoleInAppForUserList);
 331         }
 332
 333         @Test
 334         public void getAppRolesForNonCentralizedPartnerAppTest() throws Exception {
 335                 EPUser user = mockUser.mockEPUser();
 336                 user.setId(2l);
 337                 List<EPUser> mockEpUserList = new ArrayList<>();
 338                 mockEpUserList.add(user);
 339                 EPApp mockApp = mockApp();
 340                 mockApp.setId(2l);
 341                 mockApp.setCentralAuth(false);
 342                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
 343                 List<RoleInAppForUser> mockRoleInAppForUserList = new ArrayList<>();
 344                 RoleInAppForUser mockRoleInAppForUser = new RoleInAppForUser();
 345                 mockRoleInAppForUser.setIsApplied(true);
 346                 mockRoleInAppForUser.setRoleId(333l);
 347                 mockRoleInAppForUser.setRoleName("test1");
 348                 RoleInAppForUser mockRoleInAppForUser2 = new RoleInAppForUser();
 349                 mockRoleInAppForUser2.setIsApplied(true);
 350                 mockRoleInAppForUser2.setRoleId(777l);
 351                 mockRoleInAppForUser2.setRoleName("test2");
 352                 RoleInAppForUser mockRoleInAppForUser3 = new RoleInAppForUser();
 353                 mockRoleInAppForUser3.setIsApplied(false);
 354                 mockRoleInAppForUser3.setRoleId(888l);
 355                 mockRoleInAppForUser3.setRoleName("test5");
 356                 mockRoleInAppForUserList.add(mockRoleInAppForUser);
 357                 mockRoleInAppForUserList.add(mockRoleInAppForUser2);
 358                 mockRoleInAppForUserList.add(mockRoleInAppForUser3);
 359                 List<EcompRole> mockEcompRoleList = new ArrayList<>();
 360                 EcompRole mockEcompRole = new EcompRole();
 361                 mockEcompRole.setId(333l);
 362                 mockEcompRole.setName("test1");
 363                 EcompRole mockEcompRole2 = new EcompRole();
 364                 mockEcompRole2.setId(777l);
 365                 mockEcompRole2.setName("test2");
 366                 EcompRole mockEcompRole3 = new EcompRole();
 367                 mockEcompRole3.setId(888l);
 368                 mockEcompRole3.setName("test5");
 369                 mockEcompRoleList.add(mockEcompRole);
 370                 mockEcompRoleList.add(mockEcompRole2);
 371                 mockEcompRoleList.add(mockEcompRole3);
 372                 EcompRole[] mockEcompRoleArray = mockEcompRoleList.toArray(new EcompRole[mockEcompRoleList.size()]);
 373                 List<EPRole> mockEPRoleList = new ArrayList<>();
 374                 EPRole mockEpRole = new EPRole();
 375                 mockEpRole.setActive(true);
 376                 mockEpRole.setAppId(2l);
 377                 mockEpRole.setName("test1");
 378                 mockEpRole.setAppRoleId(333l);
 379                 mockEpRole.setId(16l);
 380                 EPRole mockEpRole2 = new EPRole();
 381                 mockEpRole2.setActive(true);
 382                 mockEpRole2.setAppId(2l);
 383                 mockEpRole2.setName("test3");
 384                 mockEpRole2.setAppRoleId(555l);
 385                 mockEpRole2.setId(15l);
 386                 EPRole mockEpRole3 = new EPRole();
 387                 mockEpRole3.setActive(true);
 388                 mockEpRole3.setAppId(2l);
 389                 mockEpRole3.setName("test4");
 390                 mockEpRole3.setAppRoleId(888l);
 391                 mockEpRole3.setId(17l);
 392                 mockEPRoleList.add(mockEpRole);
 393                 mockEPRoleList.add(mockEpRole2);
 394                 mockEPRoleList.add(mockEpRole3);
 395                 List<EPUserApp> mockUserRolesList = new ArrayList<>();
 396                 EPUserApp mockEpUserApp = new EPUserApp();
 397                 mockEpUserApp.setApp(mockApp);
 398                 mockEpUserApp.setRole(mockEpRole2);
 399                 mockEpUserApp.setUserId(user.getId());
 400                 mockUserRolesList.add(mockEpUserApp);
 401                 List<FunctionalMenuRole> mockFunctionalMenuRolesList = new ArrayList<>();
 402                 FunctionalMenuRole mockFunctionalMenuRole = new FunctionalMenuRole();
 403                 mockFunctionalMenuRole.setAppId((int) (long) mockApp.getId());
 404                 mockFunctionalMenuRole.setRoleId((int) (long) 15l);
 405                 mockFunctionalMenuRole.setMenuId(10l);
 406                 mockFunctionalMenuRole.setId(10);
 407                 mockFunctionalMenuRolesList.add(mockFunctionalMenuRole);
 408                 List<FunctionalMenuItem> mockFunctionalMenuItemList = new ArrayList<>();
 409                 FunctionalMenuItem mockFunctionalMenuItem = new FunctionalMenuItem();
 410                 List<Integer> mockRolesList = new ArrayList<>();
 411                 Integer role1 = 1;
 412                 mockRolesList.add(role1);
 413                 mockFunctionalMenuItem.setRestrictedApp(false);
 414                 mockFunctionalMenuItem.setRoles(mockRolesList);
 415                 mockFunctionalMenuItem.setUrl("http://test.com");
 416                 mockFunctionalMenuItemList.add(mockFunctionalMenuItem);
 417                 Query epRoleQuery = Mockito.mock(Query.class);
 418                 Query epUserAppsQuery = Mockito.mock(Query.class);
 419                 Query epFunctionalMenuQuery = Mockito.mock(Query.class);
 420                 Query epFunctionalMenuQuery2 = Mockito.mock(Query.class);
 421                 Query epFunctionalMenuItemQuery = Mockito.mock(Query.class);
 422                 Query epUserListQuery = Mockito.mock(Query.class);
 423                 Query epUserRolesListQuery = Mockito.mock(Query.class);
 424                 Mockito.when(applicationsRestClientService.get(EcompRole[].class, mockApp.getId(), "/roles"))
 425                                 .thenReturn(mockEcompRoleArray);
 426                 // syncAppRolesTest
 427                 Mockito.when(session.createQuery("from " + EPRole.class.getName() + " where appId=" + mockApp.getId()))
 428                                 .thenReturn(epRoleQuery);
 429                 Mockito.doReturn(mockEPRoleList).when(epRoleQuery).list();
 430                 Mockito.when(session.createQuery("from :name where app.id=:appId and role_id=:roleId"))
 431                                 .thenReturn(epUserAppsQuery);
 432                 Mockito.when(epUserAppsQuery.setParameter("name",EPUserApp.class.getName())).thenReturn(epUserAppsQuery);
 433                 Mockito.when(epUserAppsQuery.setParameter("appId",mockApp.getId())).thenReturn(epUserAppsQuery);
 434                 Mockito.when(epUserAppsQuery.setParameter("roleId",15l)).thenReturn(epUserAppsQuery);
 435                 Mockito.doReturn(mockUserRolesList).when(epUserAppsQuery).list();
 436
 437                 Mockito.when(session.createQuery("from " + FunctionalMenuRole.class.getName() + " where roleId=" + 15l))
 438                                 .thenReturn(epFunctionalMenuQuery);
 439                 Mockito.doReturn(mockFunctionalMenuRolesList).when(epFunctionalMenuQuery).list();
 440
 441                 Mockito.when(session.createQuery("from " + FunctionalMenuRole.class.getName() + " where menuId=" + 10l))
 442                                 .thenReturn(epFunctionalMenuQuery2);
 443                 Mockito.doReturn(mockFunctionalMenuRolesList).when(epFunctionalMenuQuery2).list();
 444
 445                 Mockito.when(session.createQuery("from " + FunctionalMenuItem.class.getName() + " where menuId=" + 10l))
 446                                 .thenReturn(epFunctionalMenuItemQuery);
 447                 Mockito.doReturn(mockFunctionalMenuItemList).when(epFunctionalMenuItemQuery).list();
 448                 List<EcompRole> mockEcompRoleList2 = new ArrayList<>();
 449                 EcompRole mockUserAppRoles = new EcompRole();
 450                 mockUserAppRoles.setId(333l);
 451                 mockUserAppRoles.setName("test1");
 452                 EcompRole mockUserAppRoles2 = new EcompRole();
 453                 mockUserAppRoles2.setId(777l);
 454                 mockUserAppRoles2.setName("test2");
 455                 mockEcompRoleList2.add(mockUserAppRoles);
 456                 mockEcompRoleList2.add(mockUserAppRoles2);
 457                 EcompRole[] mockEcompRoleArray2 = mockEcompRoleList2.toArray(new EcompRole[mockEcompRoleList2.size()]);
 458                 Mockito.when(applicationsRestClientService.get(EcompRole[].class, mockApp.getId(),
 459                                 String.format("/user/%s/roles", user.getOrgUserId()))).thenReturn(mockEcompRoleArray2);
 460                 // SyncUserRoleTest
 461                 Mockito.when(session
 462                                 .createQuery("from " + EPUser.class.getName() + " where orgUserId='" + user.getOrgUserId() + "'"))
 463                                 .thenReturn(epUserListQuery);
 464                 Mockito.doReturn(mockEpUserList).when(epUserListQuery).list();
 465
 466                 List<EPUserApp> mockUserRolesList2 = new ArrayList<>();
 467                 EPUserApp mockEpUserAppRoles = new EPUserApp();
 468                 mockEpUserAppRoles.setApp(mockApp);
 469                 mockEpUserAppRoles.setRole(mockEpRole3);
 470                 mockEpUserAppRoles.setUserId(user.getId());
 471                 mockUserRolesList2.add(mockEpUserAppRoles);
 472                 Mockito.when(session.createQuery(
 473                                 "from org.onap.portalapp.portal.domain.EPUserApp where app.id=2 and role.active = 'Y' and userId=2"))
 474                                 .thenReturn(epUserRolesListQuery);
 475                 Mockito.doReturn(mockUserRolesList2).when(epUserRolesListQuery).list();
 476                 List<RoleInAppForUser> roleInAppForUser = userRolesCommonServiceImpl.getAppRolesForUser(2l, user.getOrgUserId(),
 477                                 true, user);
 478                 assertEquals(roleInAppForUser, mockRoleInAppForUserList);
 479         }
 480
 481         @SuppressWarnings("unchecked")
 482         @Test
 483         public void setAppWithUserRoleStateForUserTestForCentralizedAppForPortal() throws Exception {
 484                 PowerMockito.mockStatic(SystemProperties.class);
 485                 PowerMockito.mockStatic(EcompPortalUtils.class);
 486                 PowerMockito.mockStatic(EPCommonSystemProperties.class);
 487                 PowerMockito.mockStatic(PortalConstants.class);
 488                 EPUser user = mockUser.mockEPUser();
 489                 user.setId(2l);
 490                 List<EPUser> mockEpUserList = new ArrayList<>();
 491                 mockEpUserList.add(user);
 492                 EPApp mockApp = mockApp();
 493                 mockApp.setNameSpace("com.test.com");
 494                 mockApp.setId(1l);
 495                 mockApp.setCentralAuth(true);
 496                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
 497                 Mockito.when(EcompPortalUtils.checkIfRemoteCentralAccessAllowed()).thenReturn(true);
 498                 AppWithRolesForUser mockWithRolesForUser = new AppWithRolesForUser();
 499                 List<RoleInAppForUser> mockRoleInAppForUserList = new ArrayList<>();
 500                 RoleInAppForUser mockRoleInAppForUser = new RoleInAppForUser();
 501                 mockRoleInAppForUser.setIsApplied(true);
 502                 mockRoleInAppForUser.setRoleId(1l);
 503                 mockRoleInAppForUser.setRoleName("test1");
 504                 RoleInAppForUser mockRoleInAppForUser2 = new RoleInAppForUser();
 505                 mockRoleInAppForUser2.setIsApplied(true);
 506                 mockRoleInAppForUser2.setRoleId(1000l);
 507                 mockRoleInAppForUser2.setRoleName("test3");
 508                 mockRoleInAppForUserList.add(mockRoleInAppForUser);
 509                 mockRoleInAppForUserList.add(mockRoleInAppForUser2);
 510                 mockWithRolesForUser.setAppId(mockApp.getId());
 511                 mockWithRolesForUser.setAppName(mockApp.getName());
 512                 mockWithRolesForUser.setOrgUserId(user.getOrgUserId());
 513                 mockWithRolesForUser.setAppRoles(mockRoleInAppForUserList);
 514                 List<EPUserAppRolesRequest> mockEpRequestIdValList = new ArrayList<EPUserAppRolesRequest>();
 515                 Set<EPUserAppRolesRequestDetail> mockEpUserAppRolesRequestDetailList = new TreeSet<>();
 516                 EPUserAppRolesRequestDetail mockEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
 517                 mockEpUserAppRolesRequestDetail.setId(2l);
 518                 mockEpUserAppRolesRequestDetail.setReqType("P");
 519                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
 520                 EPUserAppRolesRequest mockEPUserAppRolesRequest = new EPUserAppRolesRequest();
 521                 mockEPUserAppRolesRequest.setAppId(mockApp.getId());
 522                 mockEPUserAppRolesRequest.setId(1l);
 523                 mockEPUserAppRolesRequest.setRequestStatus("P");
 524                 mockEPUserAppRolesRequest.setUserId(user.getId());
 525                 mockEPUserAppRolesRequest.setEpRequestIdDetail(mockEpUserAppRolesRequestDetailList);
 526                 mockEpRequestIdValList.add(mockEPUserAppRolesRequest);
 527                 mockEpUserAppRolesRequestDetail.setEpRequestIdData(mockEPUserAppRolesRequest);
 528                 mockEpUserAppRolesRequestDetailList.add(mockEpUserAppRolesRequestDetail);
 529
 530                 // Update Requests if any requests are pending
 531                 final Map<String, Long> params = new HashMap<>();
 532                 params.put("appId", mockApp.getId());
 533                 params.put("userId", user.getId());
 534                 Mockito.when((List<EPUserAppRolesRequest>) dataAccessService.executeNamedQuery("userAppRolesRequestList",
 535                                 params, null)).thenReturn(mockEpRequestIdValList);
 536                 mockEPUserAppRolesRequest.setUpdatedDate(new Date());
 537                 mockEPUserAppRolesRequest.setRequestStatus("O");
 538                 HashMap<String, Long> additionalUpdateParam = new HashMap<String, Long>();
 539                 Mockito.doNothing().when(dataAccessService).saveDomainObject(mockEPUserAppRolesRequest, additionalUpdateParam);
 540                 List<EPUserAppRolesRequestDetail> mockGetEpUserAppRolesRequestDetailList = new ArrayList<EPUserAppRolesRequestDetail>();
 541                 EPUserAppRolesRequestDetail mockGetEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
 542                 mockEpUserAppRolesRequestDetail.setId(2l);
 543                 mockEpUserAppRolesRequestDetail.setReqType("P");
 544                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
 545                 mockGetEpUserAppRolesRequestDetailList.add(mockGetEpUserAppRolesRequestDetail);
 546                 // Updates in External Auth System
 547                 final Map<String, String> userParams = new HashMap<>();
 548                 userParams.put("orgUserIdValue", user.getOrgUserId());
 549                 Mockito.when((List<EPUser>) dataAccessService.executeNamedQuery("epUserAppId", userParams, null))
 550                                 .thenReturn(mockEpUserList);
 551                 PowerMockito
 552                                 .when(EPCommonSystemProperties
 553                                                 .containsProperty(EPCommonSystemProperties.EXTERNAL_CENTRAL_ACCESS_USER_DOMAIN))
 554                                 .thenReturn(true);
 555                 PowerMockito.when(SystemProperties.getProperty(EPCommonSystemProperties.EXTERNAL_CENTRAL_ACCESS_USER_DOMAIN))
 556                                 .thenReturn("@test.com");
 557                 HttpHeaders headers = new HttpHeaders();
 558                 Mockito.when(EcompPortalUtils.base64encodeKeyForAAFBasicAuth()).thenReturn(headers);
 559                 JSONObject mockJsonObject1 = new JSONObject();
 560                 JSONObject mockJsonObject2 = new JSONObject();
 561                 JSONObject mockJsonObject3 = new JSONObject();
 562                 mockJsonObject1.put("name", "com.test.com.test1");
 563                 mockJsonObject2.put("name", "com.test.com.test2");
 564                 List<JSONObject> mockJson = new ArrayList<>();
 565                 mockJson.add(mockJsonObject1);
 566                 mockJson.add(mockJsonObject2);
 567                 mockJsonObject3.put("role", mockJson);
 568                 ResponseEntity<String> getResponse = new ResponseEntity<>(mockJsonObject3.toString(), HttpStatus.OK);
 569                 Mockito.when(externalAccessRolesServiceImpl.getUserRolesFromExtAuthSystem(Matchers.anyString(), Matchers.any(HttpEntity.class))).thenReturn(getResponse);
 570                 EPRole mockEPRole = new EPRole();
 571                 mockEPRole.setActive(true);
 572                 mockEPRole.setAppId(null);
 573                 mockEPRole.setAppRoleId(null);
 574                 mockEPRole.setId(1l);
 575                 mockEPRole.setName("test1");
 576                 EPRole mockEPRole2 = new EPRole();
 577                 mockEPRole2.setActive(true);
 578                 mockEPRole2.setAppId(null);
 579                 mockEPRole2.setAppRoleId(null);
 580                 mockEPRole2.setId(16l);
 581                 mockEPRole2.setName("test2");
 582                 EPRole mockEPRole3 = new EPRole();
 583                 mockEPRole3.setActive(true);
 584                 mockEPRole3.setAppId(null);
 585                 mockEPRole3.setAppRoleId(null);
 586                 mockEPRole3.setId(1000l);
 587                 mockEPRole3.setName("test3");
 588                 Map<String, EPRole> mockEPRoleList = new HashMap<>();
 589                 mockEPRoleList.put("test1", mockEPRole);
 590                 mockEPRoleList.put("test2", mockEPRole2);
 591                 mockEPRoleList.put("test3", mockEPRole3);
 592                 Mockito.when(externalAccessRolesServiceImpl.getAppRoleNamesWithUnderscoreMap(mockApp)).thenReturn(mockEPRoleList);
 593                 final Map<String, Long> params2 = new HashMap<>();
 594                 params2.put("appId", mockApp.getId());
 595                 params2.put("userId", user.getId());
 596                 List<EcompUserAppRoles> mockEPuserAppList = getCurrentUserRoles(user, mockApp);
 597                 Mockito.when(dataAccessService.executeNamedQuery("getUserAppExistingRoles", params2, null))
 598                                 .thenReturn(mockEPuserAppList);
 599                 final Map<String, Long> epDetailParams = new HashMap<>();
 600                 epDetailParams.put("reqId", mockEPUserAppRolesRequest.getId());
 601                 Mockito.when(dataAccessService.executeNamedQuery("userAppRolesRequestDetailList", epDetailParams, null))
 602                                 .thenReturn(mockGetEpUserAppRolesRequestDetailList);
 603
 604                 ResponseEntity<String> addResponse = new ResponseEntity<>(HttpStatus.CREATED);
 605                 Mockito.when(template.exchange(Matchers.anyString(), Matchers.eq(HttpMethod.POST),
 606                                 Matchers.<HttpEntity<String>>any(), Matchers.eq(String.class))).thenReturn(addResponse);
 607
 608                 ResponseEntity<String> deleteResponse = new ResponseEntity<>(HttpStatus.OK);
 609                 Mockito.when(template.exchange(Matchers.anyString(), Matchers.eq(HttpMethod.DELETE),
 610                                 Matchers.<HttpEntity<String>>any(), Matchers.eq(String.class))).thenReturn(deleteResponse);
 611
 612                 // Updates in EP DB
 613                 Query epsetAppWithUserRoleGetUserQuery = Mockito.mock(Query.class);
 614                 Query epsetAppWithUserRoleGetUserAppsQuery = Mockito.mock(Query.class);
 615                 Query epsetAppWithUserRoleGetRolesQuery = Mockito.mock(Query.class);
 616                 SQLQuery epsetAppWithUserRoleUpdateEPRoleQuery = Mockito.mock(SQLQuery.class);
 617                 Mockito.when(session.get(EPApp.class, mockApp.getId())).thenReturn(mockApp);
 618                 Mockito.when(session
 619                                 .createQuery("from " + EPUser.class.getName() + " where orgUserId='" + user.getOrgUserId() + "'"))
 620                                 .thenReturn(epsetAppWithUserRoleGetUserQuery);
 621                 Mockito.doReturn(mockEpUserList).when(epsetAppWithUserRoleGetUserQuery).list();
 622                 List<EPUserApp> mockUserRolesList2 = new ArrayList<>();
 623                 EPUserApp mockEpUserAppRoles = new EPUserApp();
 624                 mockEpUserAppRoles.setApp(mockApp);
 625                 mockEpUserAppRoles.setRole(mockEPRole);
 626                 mockEpUserAppRoles.setUserId(user.getId());
 627                 mockUserRolesList2.add(mockEpUserAppRoles);
 628                 Mockito.when(session.createQuery(
 629                                 "from org.onap.portalapp.portal.domain.EPUserApp where app.id=1 and role.active = 'Y' and userId=2"))
 630                                 .thenReturn(epsetAppWithUserRoleGetUserAppsQuery);
 631                 Mockito.doReturn(mockUserRolesList2).when(epsetAppWithUserRoleGetUserAppsQuery).list();
 632                 List<EPRole> mockEPRoles = new ArrayList<>();
 633                 mockEPRoles.add(mockEPRole2);
 634                 mockEPRoles.add(mockEPRole3);
 635                 Mockito.when(session.createQuery("from " + EPRole.class.getName() + " where appId is null and id != 1"))
 636                                 .thenReturn(epsetAppWithUserRoleGetRolesQuery);
 637                 Mockito.doReturn(mockEPRoles).when(epsetAppWithUserRoleGetRolesQuery).list();
 638                 Mockito.when(session.createSQLQuery("update fn_role set app_id = null where app_id = 1 "))
 639                                 .thenReturn(epsetAppWithUserRoleUpdateEPRoleQuery);
 640                 ExternalRequestFieldsValidator actual = userRolesCommonServiceImpl.setAppWithUserRoleStateForUser(user, mockWithRolesForUser);
 641                 assertTrue(actual.isResult());
 642         }
 643
 644         private List<EcompUserAppRoles> getCurrentUserRoles(EPUser user, EPApp mockApp) {
 645                 List<EcompUserAppRoles> mockEPuserAppList = new ArrayList<>();
 646                 EcompUserAppRoles mockEcompUserAppRoles = new EcompUserAppRoles();
 647                 mockEcompUserAppRoles.setAppId(String.valueOf(mockApp.getId()));
 648                 mockEcompUserAppRoles.setRoleId(1l);
 649                 mockEcompUserAppRoles.setRoleName("test1");
 650                 mockEcompUserAppRoles.setUserId(user.getId());
 651                 mockEPuserAppList.add(mockEcompUserAppRoles);
 652                 return mockEPuserAppList;
 653         }
 654
 655         @SuppressWarnings("unchecked")
 656         @Test
 657         public void setAppWithUserRoleStateForUserTestForNonCentralizedApp() throws Exception {
 658                 PowerMockito.mockStatic(SystemProperties.class);
 659                 PowerMockito.mockStatic(EcompPortalUtils.class);
 660                 PowerMockito.mockStatic(EPCommonSystemProperties.class);
 661                 PowerMockito.mockStatic(PortalConstants.class);
 662                 EPUser user = mockUser.mockEPUser();
 663                 user.setId(2l);
 664                 List<EPUser> mockEpUserList = new ArrayList<>();
 665                 mockEpUserList.add(user);
 666                 EPApp mockApp = mockApp();
 667                 mockApp.setNameSpace("com.test.com");
 668                 mockApp.setId(2l);
 669                 mockApp.setCentralAuth(false);
 670                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
 671                 Mockito.when(EcompPortalUtils.checkIfRemoteCentralAccessAllowed()).thenReturn(true);
 672                 AppWithRolesForUser mockWithRolesForUser = new AppWithRolesForUser();
 673                 List<RoleInAppForUser> mockRoleInAppForUserList = new ArrayList<>();
 674                 RoleInAppForUser mockRoleInAppForUser = new RoleInAppForUser();
 675                 mockRoleInAppForUser.setIsApplied(true);
 676                 mockRoleInAppForUser.setRoleId(1l);
 677                 mockRoleInAppForUser.setRoleName("test1");
 678                 RoleInAppForUser mockRoleInAppForUser2 = new RoleInAppForUser();
 679                 mockRoleInAppForUser2.setIsApplied(true);
 680                 mockRoleInAppForUser2.setRoleId(1000l);
 681                 mockRoleInAppForUser2.setRoleName("test3");
 682                 mockRoleInAppForUserList.add(mockRoleInAppForUser);
 683                 mockRoleInAppForUserList.add(mockRoleInAppForUser2);
 684                 mockWithRolesForUser.setAppId(mockApp.getId());
 685                 mockWithRolesForUser.setAppName(mockApp.getName());
 686                 mockWithRolesForUser.setOrgUserId(user.getOrgUserId());
 687                 mockWithRolesForUser.setAppRoles(mockRoleInAppForUserList);
 688                 List<EPUserAppRolesRequest> mockEpRequestIdValList = new ArrayList<EPUserAppRolesRequest>();
 689                 Set<EPUserAppRolesRequestDetail> mockEpUserAppRolesRequestDetailList = new TreeSet<>();
 690                 EPUserAppRolesRequestDetail mockEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
 691                 mockEpUserAppRolesRequestDetail.setId(2l);
 692                 mockEpUserAppRolesRequestDetail.setReqType("P");
 693                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
 694                 EPUserAppRolesRequest mockEPUserAppRolesRequest = new EPUserAppRolesRequest();
 695                 mockEPUserAppRolesRequest.setAppId(mockApp.getId());
 696                 mockEPUserAppRolesRequest.setId(1l);
 697                 mockEPUserAppRolesRequest.setRequestStatus("P");
 698                 mockEPUserAppRolesRequest.setUserId(user.getId());
 699                 mockEPUserAppRolesRequest.setEpRequestIdDetail(mockEpUserAppRolesRequestDetailList);
 700                 mockEpRequestIdValList.add(mockEPUserAppRolesRequest);
 701                 mockEpUserAppRolesRequestDetail.setEpRequestIdData(mockEPUserAppRolesRequest);
 702                 mockEpUserAppRolesRequestDetailList.add(mockEpUserAppRolesRequestDetail);
 703
 704                 // Update Requests if any requests are pending
 705                 final Map<String, Long> params = new HashMap<>();
 706                 params.put("appId", mockApp.getId());
 707                 params.put("userId", user.getId());
 708                 Mockito.when((List<EPUserAppRolesRequest>) dataAccessService.executeNamedQuery("userAppRolesRequestList",
 709                                 params, null)).thenReturn(mockEpRequestIdValList);
 710                 mockEPUserAppRolesRequest.setUpdatedDate(new Date());
 711                 mockEPUserAppRolesRequest.setRequestStatus("O");
 712                 HashMap<String, Long> additionalUpdateParam = new HashMap<String, Long>();
 713                 Mockito.doNothing().when(dataAccessService).saveDomainObject(mockEPUserAppRolesRequest, additionalUpdateParam);
 714                 List<EPUserAppRolesRequestDetail> mockGetEpUserAppRolesRequestDetailList = new ArrayList<EPUserAppRolesRequestDetail>();
 715                 EPUserAppRolesRequestDetail mockGetEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
 716                 mockEpUserAppRolesRequestDetail.setId(2l);
 717                 mockEpUserAppRolesRequestDetail.setReqType("P");
 718                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
 719                 mockGetEpUserAppRolesRequestDetailList.add(mockGetEpUserAppRolesRequestDetail);
 720                 final Map<String, Long> epDetailParams = new HashMap<>();
 721                 epDetailParams.put("reqId", mockEPUserAppRolesRequest.getId());
 722
 723                 final Map<String, String> userParams = new HashMap<>();
 724                 userParams.put("orgUserIdValue", user.getOrgUserId());
 725                 Mockito.when((List<EPUser>) dataAccessService.executeNamedQuery("epUserAppId", userParams, null))
 726                                 .thenReturn(mockEpUserList);
 727
 728                 PowerMockito
 729                                 .when(EPCommonSystemProperties
 730                                                 .containsProperty(EPCommonSystemProperties.EXTERNAL_CENTRAL_ACCESS_USER_DOMAIN))
 731                                 .thenReturn(true);
 732                 PowerMockito.when(SystemProperties.getProperty(EPCommonSystemProperties.EXTERNAL_CENTRAL_ACCESS_USER_DOMAIN))
 733                                 .thenReturn("@test.com");
 734                 HttpHeaders headers = new HttpHeaders();
 735                 Mockito.when(EcompPortalUtils.base64encodeKeyForAAFBasicAuth()).thenReturn(headers);
 736                 EPRole mockEPRole = new EPRole();
 737                 mockEPRole.setActive(true);
 738                 mockEPRole.setAppId(2l);
 739                 mockEPRole.setAppRoleId(null);
 740                 mockEPRole.setId(10l);
 741                 mockEPRole.setAppRoleId(1l);
 742                 mockEPRole.setName("test1");
 743                 EPRole mockEPRole2 = new EPRole();
 744                 mockEPRole2.setActive(true);
 745                 mockEPRole2.setAppId(2l);
 746                 mockEPRole2.setAppRoleId(null);
 747                 mockEPRole2.setId(160l);
 748                 mockEPRole2.setName("test2");
 749                 mockEPRole2.setAppRoleId(16l);
 750                 EPRole mockEPRole3 = new EPRole();
 751                 mockEPRole3.setActive(true);
 752                 mockEPRole3.setAppId(2l);
 753                 mockEPRole3.setAppRoleId(null);
 754                 mockEPRole3.setId(1100l);
 755                 mockEPRole3.setAppRoleId(100l);
 756                 mockEPRole3.setName("test3");
 757                 Mockito.when(applicationsRestClientService.get(EPUser.class, mockApp.getId(),
 758                                 String.format("/user/%s", user.getOrgUserId()), true)).thenReturn(user);
 759                 // Updates in EP DB
 760                 Query epsetAppWithUserRoleNonCentralizedGetUserQuery = Mockito.mock(Query.class);
 761                 Query epsetAppWithUserRoleNonCentralizedGetUserAppsQuery = Mockito.mock(Query.class);
 762                 Query epsetAppWithUserRoleNonCentralizedGetRolesQuery = Mockito.mock(Query.class);
 763                 Mockito.when(session.get(EPApp.class, mockApp.getId())).thenReturn(mockApp);
 764                 Mockito.when(session
 765                                 .createQuery("from " + EPUser.class.getName() + " where orgUserId='" + user.getOrgUserId() + "'"))
 766                                 .thenReturn(epsetAppWithUserRoleNonCentralizedGetUserQuery);
 767                 Mockito.doReturn(mockEpUserList).when(epsetAppWithUserRoleNonCentralizedGetUserQuery).list();
 768                 List<EPUserApp> mockUserRolesList2 = new ArrayList<>();
 769                 EPUserApp mockEpUserAppRoles = new EPUserApp();
 770                 mockEpUserAppRoles.setApp(mockApp);
 771                 mockEpUserAppRoles.setRole(mockEPRole);
 772                 mockEpUserAppRoles.setUserId(user.getId());
 773                 mockUserRolesList2.add(mockEpUserAppRoles);
 774                 Mockito.when(session.createQuery(
 775                                 "from org.onap.portalapp.portal.domain.EPUserApp where app.id=2 and role.active = 'Y' and userId=2"))
 776                                 .thenReturn(epsetAppWithUserRoleNonCentralizedGetUserAppsQuery);
 777                 Mockito.doReturn(mockUserRolesList2).when(epsetAppWithUserRoleNonCentralizedGetUserAppsQuery).list();
 778                 List<EPRole> mockEPRoles = new ArrayList<>();
 779                 mockEPRoles.add(mockEPRole2);
 780                 mockEPRoles.add(mockEPRole3);
 781                 Mockito.when(session.createQuery("from " + EPRole.class.getName() + " where appId=2"))
 782                                 .thenReturn(epsetAppWithUserRoleNonCentralizedGetRolesQuery);
 783                 Mockito.doReturn(mockEPRoles).when(epsetAppWithUserRoleNonCentralizedGetRolesQuery).list();
 784                 ExternalRequestFieldsValidator expected = userRolesCommonServiceImpl.setAppWithUserRoleStateForUser(user, mockWithRolesForUser);
 785                 assertEquals(expected.isResult(), false);
 786         }
 787
 788         /*@SuppressWarnings("unchecked")
 789         @Test
 790         public void setExternalRequestUserAppRoleMerdianCentralizedAppTest() throws Exception {
 791                 PowerMockito.mockStatic(SystemProperties.class);
 792                 PowerMockito.mockStatic(EcompPortalUtils.class);
 793                 PowerMockito.mockStatic(EPCommonSystemProperties.class);
 794                 PowerMockito.mockStatic(PortalConstants.class);
 795                 EPUser user = mockUser.mockEPUser();
 796                 user.setId(2l);
 797                 List<EPUser> mockEpUserList = new ArrayList<>();
 798                 mockEpUserList.add(user);
 799                 EPApp mockApp = mockApp();
 800                 mockApp.setNameSpace("com.test.com");
 801                 mockApp.setId(1l);
 802                 mockApp.setCentralAuth(true);
 803                 Mockito.when(EcompPortalUtils.checkIfRemoteCentralAccessAllowed()).thenReturn(true);
 804                 ExternalSystemUser externalSystemUser = new ExternalSystemUser();
 805                 List<ExternalSystemRoleApproval> mockExternalSystemRoleApprovalList = new ArrayList<>();
 806                 ExternalSystemRoleApproval mockExternalSystemRoleApproval = new ExternalSystemRoleApproval();
 807                 mockExternalSystemRoleApproval.setRoleName("test1");
 808                 ExternalSystemRoleApproval mockExternalSystemRoleApproval2 = new ExternalSystemRoleApproval();
 809                 mockExternalSystemRoleApproval2.setRoleName("test2");
 810                 mockExternalSystemRoleApprovalList.add(mockExternalSystemRoleApproval);
 811                 mockExternalSystemRoleApprovalList.add(mockExternalSystemRoleApproval2);
 812                 externalSystemUser.setApplicationName(mockApp.getMlAppName());
 813                 externalSystemUser.setLoginId(user.getOrgUserId());
 814                 externalSystemUser.setRoles(mockExternalSystemRoleApprovalList);
 815                 EPRole mockEPRole = new EPRole();
 816                 mockEPRole.setActive(true);
 817                 mockEPRole.setAppId(null);
 818                 mockEPRole.setAppRoleId(null);
 819                 mockEPRole.setId(1l);
 820                 mockEPRole.setName("test1");
 821                 EPRole mockEPRole2 = new EPRole();
 822                 mockEPRole2.setActive(true);
 823                 mockEPRole2.setAppId(null);
 824                 mockEPRole2.setAppRoleId(null);
 825                 mockEPRole2.setId(16l);
 826                 mockEPRole2.setName("test2");
 827                 EPRole mockEPRole3 = new EPRole();
 828                 mockEPRole3.setActive(true);
 829                 mockEPRole3.setAppId(null);
 830                 mockEPRole3.setAppRoleId(null);
 831                 mockEPRole3.setId(1000l);
 832                 mockEPRole3.setName("test3");
 833
 834                 Mockito.when(epAppCommonServiceImpl.getAppDetail(mockApp.getMlAppName())).thenReturn(mockApp);
 835                 final Map<String, String> userParams = new HashMap<>();
 836                 userParams.put("orgUserIdValue", user.getOrgUserId());
 837                 Mockito.when((List<EPUser>) dataAccessService.executeNamedQuery("epUserAppId", userParams, null))
 838                                 .thenReturn(mockEpUserList);
 839
 840                 List<EPUserAppRolesRequest> mockMerdianEpRequestIdValList = new ArrayList<EPUserAppRolesRequest>();
 841                 Set<EPUserAppRolesRequestDetail> mockEpUserAppRolesRequestDetailList = new TreeSet<>();
 842                 EPUserAppRolesRequestDetail mockEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
 843                 mockEpUserAppRolesRequestDetail.setId(2l);
 844                 mockEpUserAppRolesRequestDetail.setReqType("P");
 845                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
 846                 EPUserAppRolesRequest mockEPUserAppRolesRequest = new EPUserAppRolesRequest();
 847                 mockEPUserAppRolesRequest.setAppId(mockApp.getId());
 848                 mockEPUserAppRolesRequest.setId(1l);
 849                 mockEPUserAppRolesRequest.setRequestStatus("P");
 850                 mockEPUserAppRolesRequest.setUserId(user.getId());
 851                 mockEPUserAppRolesRequest.setEpRequestIdDetail(mockEpUserAppRolesRequestDetailList);
 852                 mockMerdianEpRequestIdValList.add(mockEPUserAppRolesRequest);
 853                 mockEpUserAppRolesRequestDetail.setEpRequestIdData(mockEPUserAppRolesRequest);
 854                 mockEpUserAppRolesRequestDetailList.add(mockEpUserAppRolesRequestDetail);
 855
 856                 final Map<String, Long> params = new HashMap<>();
 857                 params.put("appId", mockApp.getId());
 858                 params.put("userId", user.getId());
 859                 Mockito.when((List<EPUserAppRolesRequest>) dataAccessService.executeNamedQuery("userAppRolesRequestList",
 860                                 params, null)).thenReturn(mockMerdianEpRequestIdValList);
 861                 RoleInAppForUser mockRoleInAppForUser1 = new RoleInAppForUser();
 862                 mockRoleInAppForUser1.setIsApplied(true);
 863                 mockRoleInAppForUser1.setRoleId(1l);
 864                 mockRoleInAppForUser1.setRoleName("test1");
 865                 RoleInAppForUser mockRoleInAppForUser2 = new RoleInAppForUser();
 866                 mockRoleInAppForUser2.setIsApplied(true);
 867                 mockRoleInAppForUser2.setRoleId(16l);
 868                 mockRoleInAppForUser2.setRoleName("test2");
 869                 Mockito.when(epRoleServiceImpl.getAppRole(mockExternalSystemRoleApproval.getRoleName(), mockApp.getId()))
 870                                 .thenReturn(mockEPRole);
 871                 Mockito.when(epRoleServiceImpl.getAppRole(mockExternalSystemRoleApproval2.getRoleName(), mockApp.getId()))
 872                                 .thenReturn(mockEPRole2);
 873                 List<EcompUserAppRoles> mockEPuserAppList = getCurrentUserRoles(user, mockApp);
 874                 final Map<String, Long> params2 = new HashMap<>();
 875                 params2.put("userId", user.getId());
 876                 params2.put("appId", mockApp.getId());
 877                 Mockito.when(dataAccessService.executeNamedQuery("getUserAppExistingRoles", params2, null))
 878                                 .thenReturn(mockEPuserAppList);
 879                 // Updates in External Auth System
 880                 List<EPUserAppRolesRequestDetail> mockGetEpUserAppRolesRequestDetailList = new ArrayList<EPUserAppRolesRequestDetail>();
 881                 EPUserAppRolesRequestDetail mockGetEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
 882                 mockEpUserAppRolesRequestDetail.setId(2l);
 883                 mockEpUserAppRolesRequestDetail.setReqType("P");
 884                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
 885                 mockGetEpUserAppRolesRequestDetailList.add(mockGetEpUserAppRolesRequestDetail);
 886                 final Map<String, String> userParams2 = new HashMap<>();
 887                 userParams2.put("orgUserIdValue", user.getOrgUserId());
 888                 Mockito.when((List<EPUser>) dataAccessService.executeNamedQuery("epUserAppId", userParams2, null))
 889                                 .thenReturn(mockEpUserList);
 890                 PowerMockito
 891                                 .when(EPCommonSystemProperties
 892                                                 .containsProperty(EPCommonSystemProperties.EXTERNAL_CENTRAL_ACCESS_USER_DOMAIN))
 893                                 .thenReturn(true);
 894                 PowerMockito.when(SystemProperties.getProperty(EPCommonSystemProperties.EXTERNAL_CENTRAL_ACCESS_USER_DOMAIN))
 895                                 .thenReturn("@test.com");
 896                 HttpHeaders headers = new HttpHeaders();
 897                 Mockito.when(EcompPortalUtils.base64encodeKeyForAAFBasicAuth()).thenReturn(headers);
 898                 JSONObject mockJsonObject1 = new JSONObject();
 899                 JSONObject mockJsonObject2 = new JSONObject();
 900                 JSONObject mockJsonObject3 = new JSONObject();
 901                 mockJsonObject1.put("name", "com.test.com.test1");
 902                 mockJsonObject2.put("name", "com.test.com.test2");
 903                 List<JSONObject> mockJson = new ArrayList<>();
 904                 mockJson.add(mockJsonObject1);
 905                 mockJson.add(mockJsonObject2);
 906                 mockJsonObject3.put("role", mockJson);
 907                 ResponseEntity<String> getResponse = new ResponseEntity<>(mockJsonObject3.toString(), HttpStatus.OK);
 908                 Mockito.when(externalAccessRolesServiceImpl.getUserRolesFromExtAuthSystem(Matchers.anyString(), Matchers.any(HttpEntity.class))).thenReturn(getResponse);
 909                 Map<String, EPRole> mockEPRoleList = new HashMap<>();
 910                 mockEPRoleList.put("test1", mockEPRole);
 911                 mockEPRoleList.put("test2", mockEPRole2);
 912                 mockEPRoleList.put("test3", mockEPRole3);
 913                 Mockito.when(externalAccessRolesServiceImpl.getAppRoleNamesWithUnderscoreMap(mockApp)).thenReturn(mockEPRoleList);
 914                 ResponseEntity<String> addResponse = new ResponseEntity<>(HttpStatus.CREATED);
 915                 Mockito.when(template.exchange(Matchers.anyString(), Matchers.eq(HttpMethod.POST),
 916                                 Matchers.<HttpEntity<String>>any(), Matchers.eq(String.class))).thenReturn(addResponse);
 917
 918                 ResponseEntity<String> deleteResponse = new ResponseEntity<>(HttpStatus.OK);
 919                 Mockito.when(template.exchange(Matchers.anyString(), Matchers.eq(HttpMethod.DELETE),
 920                                 Matchers.<HttpEntity<String>>any(), Matchers.eq(String.class))).thenReturn(deleteResponse);
 921                 // Updated in EP DB
 922                 Query epsetExternalRequestUserAppRoleGetUserQuery = Mockito.mock(Query.class);
 923                 Query epsetExternalRequestUserAppRoleGetUserAppsQuery = Mockito.mock(Query.class);
 924                 Query epsetExternalRequestUserAppRoleGetRolesQuery = Mockito.mock(Query.class);
 925                 SQLQuery epsetAppWithUserRoleUpdateEPRoleQuery = Mockito.mock(SQLQuery.class);
 926                 Mockito.when(session.get(EPApp.class, mockApp.getId())).thenReturn(mockApp);
 927                 Mockito.when(session
 928                                 .createQuery("from " + EPUser.class.getName() + " where orgUserId='" + user.getOrgUserId() + "'"))
 929                                 .thenReturn(epsetExternalRequestUserAppRoleGetUserQuery);
 930                 Mockito.doReturn(mockEpUserList).when(epsetExternalRequestUserAppRoleGetUserQuery).list();
 931                 List<EPUserApp> mockUserRolesList2 = new ArrayList<>();
 932                 EPUserApp mockEpUserAppRoles = new EPUserApp();
 933                 mockEpUserAppRoles.setApp(mockApp);
 934                 mockEpUserAppRoles.setRole(mockEPRole);
 935                 mockEpUserAppRoles.setUserId(user.getId());
 936                 mockUserRolesList2.add(mockEpUserAppRoles);
 937                 Mockito.when(session.createQuery(
 938                                 "from org.onap.portalapp.portal.domain.EPUserApp where app.id=1 and role.active = 'Y' and userId=2"))
 939                                 .thenReturn(epsetExternalRequestUserAppRoleGetUserAppsQuery);
 940                 Mockito.doReturn(mockUserRolesList2).when(epsetExternalRequestUserAppRoleGetUserAppsQuery).list();
 941                 List<EPRole> mockEPRoles = new ArrayList<>();
 942                 mockEPRoles.add(mockEPRole2);
 943                 mockEPRoles.add(mockEPRole3);
 944                 Mockito.when(session.createQuery("from org.onap.portalapp.portal.domain.EPRole where appId is null "))
 945                                 .thenReturn(epsetExternalRequestUserAppRoleGetRolesQuery);
 946                 Mockito.doReturn(mockEPRoles).when(epsetExternalRequestUserAppRoleGetRolesQuery).list();
 947                 Mockito.when(session.createSQLQuery("update fn_role set app_id = null where app_id = 1 "))
 948                                 .thenReturn(epsetAppWithUserRoleUpdateEPRoleQuery);
 949
 950                 ExternalRequestFieldsValidator mockExternalRequestFieldsValidator = new ExternalRequestFieldsValidator(true,
 951                                 "Updated Successfully");
 952                 ExternalRequestFieldsValidator externalRequestFieldsValidator = userRolesCommonServiceImpl
 953                                 .setExternalRequestUserAppRole(externalSystemUser, "POST");
 954                 assertTrue(mockExternalRequestFieldsValidator.equals(externalRequestFieldsValidator));
 955         }
 956 */
 957         @SuppressWarnings("unchecked")
 958         @Test
 959         public void setExternalRequestUserAppRoleMerdianNonCentralizedAppTest() throws Exception {
 960                 PowerMockito.mockStatic(SystemProperties.class);
 961                 PowerMockito.mockStatic(EPCommonSystemProperties.class);
 962                 PowerMockito.mockStatic(PortalConstants.class);
 963                 EPUser user = mockUser.mockEPUser();
 964                 user.setId(2l);
 965                 List<EPUser> mockEpUserList = new ArrayList<>();
 966                 mockEpUserList.add(user);
 967                 EPApp mockApp = mockApp();
 968                 mockApp.setId(2l);
 969                 mockApp.setEnabled(true);
 970                 mockApp.setCentralAuth(false);
 971                 ExternalSystemUser externalSystemUser = new ExternalSystemUser();
 972                 List<ExternalSystemRoleApproval> mockExternalSystemRoleApprovalList = new ArrayList<>();
 973                 ExternalSystemRoleApproval mockExternalSystemRoleApproval = new ExternalSystemRoleApproval();
 974                 mockExternalSystemRoleApproval.setRoleName("test1");
 975                 ExternalSystemRoleApproval mockExternalSystemRoleApproval2 = new ExternalSystemRoleApproval();
 976                 mockExternalSystemRoleApproval2.setRoleName("test2");
 977                 mockExternalSystemRoleApprovalList.add(mockExternalSystemRoleApproval);
 978                 mockExternalSystemRoleApprovalList.add(mockExternalSystemRoleApproval2);
 979                 externalSystemUser.setApplicationName(mockApp.getMlAppName());
 980                 externalSystemUser.setLoginId(user.getOrgUserId());
 981                 externalSystemUser.setRoles(mockExternalSystemRoleApprovalList);
 982
 983                 EPRole mockEPRole = new EPRole();
 984                 mockEPRole.setActive(true);
 985                 mockEPRole.setAppId(2l);
 986                 mockEPRole.setAppRoleId(1l);
 987                 mockEPRole.setId(1000l);
 988                 mockEPRole.setName("test1");
 989                 EPRole mockEPRole2 = new EPRole();
 990                 mockEPRole2.setActive(true);
 991                 mockEPRole2.setAppId(2l);
 992                 mockEPRole2.setAppRoleId(16l);
 993                 mockEPRole2.setId(160l);
 994                 mockEPRole2.setName("test2");
 995                 EPRole mockEPRole3 = new EPRole();
 996                 mockEPRole3.setActive(true);
 997                 mockEPRole3.setAppId(2l);
 998                 mockEPRole3.setAppRoleId(10l);
 999                 mockEPRole3.setId(100l);
1000                 mockEPRole3.setName("test3");
1001
1002                 Mockito.when(epAppCommonServiceImpl.getAppDetail(mockApp.getMlAppName())).thenReturn(mockApp);
1003                 final Map<String, String> userParams = new HashMap<>();
1004                 userParams.put("orgUserIdValue", user.getOrgUserId());
1005                 Mockito.when((List<EPUser>) dataAccessService.executeNamedQuery("epUserAppId", userParams, null))
1006                                 .thenReturn(mockEpUserList);
1007
1008                 List<EPUserAppRolesRequest> mockMerdianEpRequestIdValList = new ArrayList<EPUserAppRolesRequest>();
1009                 Set<EPUserAppRolesRequestDetail> mockEpUserAppRolesRequestDetailList = new TreeSet<>();
1010                 EPUserAppRolesRequestDetail mockEpUserAppRolesRequestDetail = new EPUserAppRolesRequestDetail();
1011                 mockEpUserAppRolesRequestDetail.setId(2l);
1012                 mockEpUserAppRolesRequestDetail.setReqType("P");
1013                 mockEpUserAppRolesRequestDetail.setReqRoleId(16l);
1014                 EPUserAppRolesRequest mockEPUserAppRolesRequest = new EPUserAppRolesRequest();
1015                 mockEPUserAppRolesRequest.setAppId(mockApp.getId());
1016                 mockEPUserAppRolesRequest.setId(1l);
1017                 mockEPUserAppRolesRequest.setRequestStatus("P");
1018                 mockEPUserAppRolesRequest.setUserId(user.getId());
1019                 mockEPUserAppRolesRequest.setEpRequestIdDetail(mockEpUserAppRolesRequestDetailList);
1020                 mockMerdianEpRequestIdValList.add(mockEPUserAppRolesRequest);
1021                 mockEpUserAppRolesRequestDetail.setEpRequestIdData(mockEPUserAppRolesRequest);
1022                 mockEpUserAppRolesRequestDetailList.add(mockEpUserAppRolesRequestDetail);
1023
1024                 final Map<String, Long> params = new HashMap<>();
1025                 params.put("appId", mockApp.getId());
1026                 params.put("userId", user.getId());
1027                 Mockito.when((List<EPUserAppRolesRequest>) dataAccessService.executeNamedQuery("userAppRolesRequestList",
1028                                 params, null)).thenReturn(mockMerdianEpRequestIdValList);
1029                 RoleInAppForUser mockRoleInAppForUser1 = new RoleInAppForUser();
1030                 mockRoleInAppForUser1.setIsApplied(true);
1031                 mockRoleInAppForUser1.setRoleId(1l);
1032                 mockRoleInAppForUser1.setRoleName("test1");
1033                 RoleInAppForUser mockRoleInAppForUser2 = new RoleInAppForUser();
1034                 mockRoleInAppForUser2.setIsApplied(true);
1035                 mockRoleInAppForUser2.setRoleId(16l);
1036                 mockRoleInAppForUser2.setRoleName("test2");
1037                 Mockito.when(epRoleServiceImpl.getAppRole(mockExternalSystemRoleApproval.getRoleName(), mockApp.getId()))
1038                                 .thenReturn(mockEPRole);
1039                 Mockito.when(epRoleServiceImpl.getAppRole(mockExternalSystemRoleApproval2.getRoleName(), mockApp.getId()))
1040                                 .thenReturn(mockEPRole2);
1041                 List<EcompUserAppRoles> mockEPuserAppList = new ArrayList<>();
1042                 EcompUserAppRoles mockEcompUserAppRoles = new EcompUserAppRoles();
1043                 mockEcompUserAppRoles.setAppId(String.valueOf(mockApp.getId()));
1044                 mockEcompUserAppRoles.setRoleId(100l);
1045                 mockEcompUserAppRoles.setRoleName("test1");
1046                 mockEcompUserAppRoles.setUserId(user.getId());
1047                 mockEPuserAppList.add(mockEcompUserAppRoles);
1048                 final Map<String, Long> params2 = new HashMap<>();
1049                 params2.put("userId", user.getId());
1050                 params2.put("appId", mockApp.getId());
1051                 Mockito.when(dataAccessService.executeNamedQuery("getUserAppExistingRoles", params2, null))
1052                                 .thenReturn(mockEPuserAppList);
1053                 List<EcompRole> mockEcompRoleList = new ArrayList<>();
1054                 EcompRole mockEcompRole = new EcompRole();
1055                 mockEcompRole.setId(1l);
1056                 mockEcompRole.setName("test1");
1057                 EcompRole mockEcompRole2 = new EcompRole();
1058                 mockEcompRole2.setId(16l);
1059                 mockEcompRole2.setName("test2");
1060                 mockEcompRoleList.add(mockEcompRole);
1061                 mockEcompRoleList.add(mockEcompRole2);
1062                 EcompRole[] mockEcompRoleArray = mockEcompRoleList.toArray(new EcompRole[mockEcompRoleList.size()]);
1063                 Mockito.when(applicationsRestClientService.get(EcompRole[].class, mockApp.getId(), "/roles"))
1064                                 .thenReturn(mockEcompRoleArray);
1065
1066                 // SyncAppRoles
1067                 List<EPUserApp> mockUserRolesList = new ArrayList<>();
1068                 EPUserApp mockEpUserApp = new EPUserApp();
1069                 mockEpUserApp.setApp(mockApp);
1070                 mockEpUserApp.setRole(mockEPRole2);
1071                 mockEpUserApp.setUserId(user.getId());
1072                 mockUserRolesList.add(mockEpUserApp);
1073                 List<FunctionalMenuRole> mockFunctionalMenuRolesList = new ArrayList<>();
1074                 FunctionalMenuRole mockFunctionalMenuRole = new FunctionalMenuRole();
1075                 mockFunctionalMenuRole.setAppId((int) (long) mockApp.getId());
1076                 mockFunctionalMenuRole.setRoleId((int) (long) 15l);
1077                 mockFunctionalMenuRole.setMenuId(10l);
1078                 mockFunctionalMenuRole.setId(10);
1079                 mockFunctionalMenuRolesList.add(mockFunctionalMenuRole);
1080                 List<FunctionalMenuItem> mockFunctionalMenuItemList = new ArrayList<>();
1081                 FunctionalMenuItem mockFunctionalMenuItem = new FunctionalMenuItem();
1082                 List<Integer> mockRolesList = new ArrayList<>();
1083                 Integer role1 = 1;
1084                 mockRolesList.add(role1);
1085                 mockFunctionalMenuItem.setRestrictedApp(false);
1086                 mockFunctionalMenuItem.setRoles(mockRolesList);
1087                 mockFunctionalMenuItem.setUrl("http://test.com");
1088                 mockFunctionalMenuItemList.add(mockFunctionalMenuItem);
1089                 Query epRoleQuery = Mockito.mock(Query.class);
1090                 Query epUserAppsQuery = Mockito.mock(Query.class);
1091                 Query epFunctionalMenuQuery = Mockito.mock(Query.class);
1092                 Query epFunctionalMenuQuery2 = Mockito.mock(Query.class);
1093                 Query epFunctionalMenuItemQuery = Mockito.mock(Query.class);
1094                 Mockito.when(applicationsRestClientService.get(EcompRole[].class, mockApp.getId(), "/roles"))
1095                                 .thenReturn(mockEcompRoleArray);
1096                 // syncAppRolesTest
1097                 Mockito.when(session.createQuery("from " + EPRole.class.getName() + " where appId=" + mockApp.getId()))
1098                                 .thenReturn(epRoleQuery);
1099                 Mockito.doReturn(mockEcompRoleList).when(epRoleQuery).list();
1100                 Mockito.when(session.createQuery(
1101                                 "from " + EPUserApp.class.getName() + " where app.id=" + mockApp.getId() + " and role_id=" + 100l))
1102                                 .thenReturn(epUserAppsQuery);
1103                 Mockito.doReturn(mockUserRolesList).when(epUserAppsQuery).list();
1104
1105                 Mockito.when(session.createQuery("from " + FunctionalMenuRole.class.getName() + " where roleId=" + 100l))
1106                                 .thenReturn(epFunctionalMenuQuery);
1107                 Mockito.doReturn(mockFunctionalMenuRolesList).when(epFunctionalMenuQuery).list();
1108
1109                 Mockito.when(session.createQuery("from " + FunctionalMenuRole.class.getName() + " where menuId=" + 10l))
1110                                 .thenReturn(epFunctionalMenuQuery2);
1111                 Mockito.doReturn(mockFunctionalMenuRolesList).when(epFunctionalMenuQuery2).list();
1112
1113                 Mockito.when(session.createQuery("from " + FunctionalMenuItem.class.getName() + " where menuId=" + 10l))
1114                                 .thenReturn(epFunctionalMenuItemQuery);
1115                 Mockito.doReturn(mockFunctionalMenuItemList).when(epFunctionalMenuItemQuery).list();
1116
1117                 Mockito.when(applicationsRestClientService.get(EPUser.class, mockApp.getId(),
1118                                 String.format("/user/%s", user.getOrgUserId()), true)).thenReturn(user);
1119                 // Updated in EP DB
1120                 Query epsetExternalRequestUserAppRoleGetUserQuery = Mockito.mock(Query.class);
1121                 Query epsetExternalRequestUserAppRoleGetUserAppsQuery = Mockito.mock(Query.class);
1122                 Query epsetExternalRequestUserAppRoleGetRolesQuery = Mockito.mock(Query.class);
1123                 Mockito.when(session.get(EPApp.class, mockApp.getId())).thenReturn(mockApp);
1124                 Mockito.when(session
1125                                 .createQuery("from " + EPUser.class.getName() + " where orgUserId='" + user.getOrgUserId() + "'"))
1126                                 .thenReturn(epsetExternalRequestUserAppRoleGetUserQuery);
1127                 Mockito.doReturn(mockEpUserList).when(epsetExternalRequestUserAppRoleGetUserQuery).list();
1128                 List<EPUserApp> mockUserRolesList2 = new ArrayList<>();
1129                 EPUserApp mockEpUserAppRoles = new EPUserApp();
1130                 mockEpUserAppRoles.setApp(mockApp);
1131                 mockEpUserAppRoles.setRole(mockEPRole);
1132                 mockEpUserAppRoles.setUserId(user.getId());
1133                 mockUserRolesList2.add(mockEpUserAppRoles);
1134                 Mockito.when(session.createQuery(
1135                                 "from org.onap.portalapp.portal.domain.EPUserApp where app.id=2 and role.active = 'Y' and userId=2"))
1136                                 .thenReturn(epsetExternalRequestUserAppRoleGetUserAppsQuery);
1137                 Mockito.doReturn(mockUserRolesList2).when(epsetExternalRequestUserAppRoleGetUserAppsQuery).list();
1138                 List<EPRole> mockEPRoles = new ArrayList<>();
1139                 mockEPRoles.add(mockEPRole2);
1140                 mockEPRoles.add(mockEPRole3);
1141                 Mockito.when(session.createQuery("from org.onap.portalapp.portal.domain.EPRole where appId=2"))
1142                                 .thenReturn(epsetExternalRequestUserAppRoleGetRolesQuery);
1143                 Mockito.doReturn(mockEPRoles).when(epsetExternalRequestUserAppRoleGetRolesQuery).list();
1144
1145                 ExternalRequestFieldsValidator mockExternalRequestFieldsValidator = new ExternalRequestFieldsValidator(true,
1146                                 "Updated Successfully");
1147                 ExternalRequestFieldsValidator externalRequestFieldsValidator = userRolesCommonServiceImpl
1148                                 .setExternalRequestUserAppRole(externalSystemUser, "POST");
1149                 assertFalse(mockExternalRequestFieldsValidator.equals(externalRequestFieldsValidator));
1150         }
1151
1152         @SuppressWarnings("unchecked")
1153         @Test
1154         public void getUsersFromAppEndpointCentralizedAppTest() throws HTTPException {
1155                 EPApp mockApp = mockApp();
1156                 mockApp.setId(1l);
1157                 mockApp.setEnabled(true);
1158                 mockApp.setCentralAuth(true);
1159                 EPUser user = mockUser.mockEPUser();
1160                 EPUser user2 = mockUser.mockEPUser();
1161                 user2.setActive(true);
1162                 user2.setOrgUserId("guestT2");
1163                 user2.setId(2l);
1164                 user2.setFirstName("Guest2");
1165                 user2.setLastName("Test2");
1166                 user.setId(1l);
1167                 user.setFirstName("Guest");
1168                 user.setLastName("Test");
1169                 EPRole mockEPRole1 = new EPRole();
1170                 mockEPRole1.setId(1l);
1171                 mockEPRole1.setName("test1");
1172                 mockEPRole1.setActive(true);
1173                 EPRole mockEPRole2 = new EPRole();
1174                 mockEPRole2.setId(16l);
1175                 mockEPRole2.setName("test2");
1176                 mockEPRole2.setActive(true);
1177                 SortedSet<EPUserApp> mockUserApps1 = new TreeSet<EPUserApp>();
1178                 EPUserApp mockEPUserApp1 = new EPUserApp();
1179                 mockEPUserApp1.setApp(mockApp);
1180                 mockEPUserApp1.setRole(mockEPRole1);
1181                 mockEPUserApp1.setUserId(1l);
1182                 mockUserApps1.add(mockEPUserApp1);
1183                 user.setEPUserApps(mockUserApps1);
1184                 SortedSet<EPUserApp> mockUserApps2 = new TreeSet<EPUserApp>();
1185                 EPUserApp mockEPUserApp2 = new EPUserApp();
1186                 mockEPUserApp2.setApp(mockApp);
1187                 mockEPUserApp2.setRole(mockEPRole2);
1188                 mockEPUserApp2.setUserId(2l);
1189                 mockUserApps2.add(mockEPUserApp2);
1190                 user2.setEPUserApps(mockUserApps2);
1191                 List<EPUser> mockEpUserList = new ArrayList<>();
1192                 mockEpUserList.add(user);
1193                 mockEpUserList.add(user2);
1194                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
1195                 List<UserApplicationRoles> mockUserApplicationRolesList = new ArrayList<>();
1196                 UserApplicationRoles mockUserApplicationRoles = new UserApplicationRoles();
1197                 List<RemoteRole> mockRemoteRoleList = new ArrayList<>();
1198                 RemoteRole mockRemoteRole = new RemoteRole();
1199                 mockRemoteRole.setId(1l);
1200                 mockRemoteRole.setName("test1");
1201                 mockRemoteRoleList.add(mockRemoteRole);
1202                 mockUserApplicationRoles.setAppId(mockApp.getId());
1203                 mockUserApplicationRoles.setFirstName("Guest");
1204                 mockUserApplicationRoles.setLastName("Test");
1205                 mockUserApplicationRoles.setOrgUserId("guestT");
1206                 mockUserApplicationRoles.setRoles(mockRemoteRoleList);
1207                 UserApplicationRoles mockUserApplicationRoles2 = new UserApplicationRoles();
1208                 List<RemoteRole> mockRemoteRoleList2 = new ArrayList<>();
1209                 RemoteRole mockRemoteRole2 = new RemoteRole();
1210                 mockRemoteRole2.setId(16l);
1211                 mockRemoteRole2.setName("test2");
1212                 mockRemoteRoleList2.add(mockRemoteRole2);
1213                 mockUserApplicationRoles2.setAppId(mockApp.getId());
1214                 mockUserApplicationRoles2.setFirstName("Guest2");
1215                 mockUserApplicationRoles2.setLastName("Test2");
1216                 mockUserApplicationRoles2.setOrgUserId("guestT2");
1217                 mockUserApplicationRoles2.setRoles(mockRemoteRoleList2);
1218                 mockUserApplicationRolesList.add(mockUserApplicationRoles);
1219                 mockUserApplicationRolesList.add(mockUserApplicationRoles2);
1220                 Mockito.when((List<EPUser>) dataAccessService.executeNamedQuery("getActiveUsers", null, null))
1221                                 .thenReturn(mockEpUserList);
1222                 assertEquals(userRolesCommonServiceImpl.getUsersFromAppEndpoint(1l).size(),
1223                                 mockUserApplicationRolesList.size());
1224         }
1225
1226         @Test
1227         public void getUsersFromAppEndpointNonCentralizedAppTest() throws HTTPException, JsonProcessingException {
1228                 EPApp mockApp = mockApp();
1229                 mockApp.setId(2l);
1230                 mockApp.setEnabled(true);
1231                 mockApp.setCentralAuth(false);
1232                 Mockito.when(epAppCommonServiceImpl.getApp(mockApp.getId())).thenReturn(mockApp);
1233                 List<UserApplicationRoles> mockUserApplicationRolesNonCentralizedList = new ArrayList<>();
1234                 UserApplicationRoles mockUserApplicationRoles = new UserApplicationRoles();
1235                 List<RemoteRole> mockRemoteRoleList = new ArrayList<>();
1236                 RemoteRole mockRemoteRole = new RemoteRole();
1237                 mockRemoteRole.setId(1l);
1238                 mockRemoteRole.setName("test1");
1239                 mockRemoteRoleList.add(mockRemoteRole);
1240                 mockUserApplicationRoles.setAppId(mockApp.getId());
1241                 mockUserApplicationRoles.setFirstName("Guest");
1242                 mockUserApplicationRoles.setLastName("Test");
1243                 mockUserApplicationRoles.setOrgUserId("guestT");
1244                 mockUserApplicationRoles.setRoles(mockRemoteRoleList);
1245                 UserApplicationRoles mockUserApplicationRoles2 = new UserApplicationRoles();
1246                 List<RemoteRole> mockRemoteRoleList2 = new ArrayList<>();
1247                 RemoteRole mockRemoteRole2 = new RemoteRole();
1248                 mockRemoteRole2.setId(16l);
1249                 mockRemoteRole2.setName("test2");
1250                 mockRemoteRoleList2.add(mockRemoteRole2);
1251                 mockUserApplicationRoles2.setAppId(mockApp.getId());
1252                 mockUserApplicationRoles2.setFirstName("Guest2");
1253                 mockUserApplicationRoles2.setLastName("Test2");
1254                 mockUserApplicationRoles2.setOrgUserId("guestT2");
1255                 mockUserApplicationRoles2.setRoles(mockRemoteRoleList2);
1256                 mockUserApplicationRolesNonCentralizedList.add(mockUserApplicationRoles);
1257                 mockUserApplicationRolesNonCentralizedList.add(mockUserApplicationRoles2);
1258                 RemoteUserWithRoles mockRemoteUserWithRoles1 = new RemoteUserWithRoles();
1259                 mockRemoteUserWithRoles1.setFirstName("Guest1");
1260                 mockRemoteUserWithRoles1.setLastName("Test1");
1261                 mockRemoteUserWithRoles1.setOrgUserId("guestT");
1262                 mockRemoteUserWithRoles1.setRoles(mockRemoteRoleList);
1263                 RemoteUserWithRoles mockRemoteUserWithRoles2 = new RemoteUserWithRoles();
1264                 mockRemoteUserWithRoles2.setFirstName("Guest2");
1265                 mockRemoteUserWithRoles2.setLastName("Test2");
1266                 mockRemoteUserWithRoles2.setOrgUserId("guestT");
1267                 mockRemoteUserWithRoles2.setRoles(mockRemoteRoleList2);
1268                 List<RemoteUserWithRoles> mockRemoteUserWithRolesList = new ArrayList<>();
1269                 mockRemoteUserWithRolesList.add(mockRemoteUserWithRoles1);
1270                 mockRemoteUserWithRolesList.add(mockRemoteUserWithRoles2);
1271                 ObjectMapper mapper = new ObjectMapper();
1272                 String mockGetRemoteUsersWithRoles = mapper.writeValueAsString(mockRemoteUserWithRolesList);
1273                 Mockito.when(applicationsRestClientService.getIncomingJsonString(mockApp.getId(), "/users"))
1274                                 .thenReturn(mockGetRemoteUsersWithRoles);
1275                 List<UserApplicationRoles> userApplicationRolesNonCentralizedList = userRolesCommonServiceImpl
1276                                 .getUsersFromAppEndpoint(2l);
1277                 assertEquals(mockUserApplicationRolesNonCentralizedList.size(), userApplicationRolesNonCentralizedList.size());
1278         }
1279
1280         @SuppressWarnings("unchecked")
1281         @Test
1282         public void putUserAppRolesRequestTest() {
1283                 EPApp mockApp = mockApp();
1284                 mockApp.setId(2l);
1285                 mockApp.setEnabled(true);
1286                 mockApp.setCentralAuth(false);
1287                 EPUser user = mockUser.mockEPUser();
1288                 AppWithRolesForUser appWithRolesForUser = new AppWithRolesForUser();
1289                 List<RoleInAppForUser> mockRoleInAppForUserList = new ArrayList<>();
1290                 RoleInAppForUser roleInAppForUser = new RoleInAppForUser();
1291                 roleInAppForUser.setIsApplied(true);
1292                 roleInAppForUser.setRoleId(1l);
1293                 roleInAppForUser.setRoleName("test1");
1294                 RoleInAppForUser roleInAppForUser2 = new RoleInAppForUser();
1295                 roleInAppForUser2.setIsApplied(true);
1296                 roleInAppForUser2.setRoleId(1000l);
1297                 roleInAppForUser2.setRoleName("test3");
1298                 mockRoleInAppForUserList.add(roleInAppForUser);
1299                 mockRoleInAppForUserList.add(roleInAppForUser2);
1300                 appWithRolesForUser.setAppId(mockApp.getId());
1301                 appWithRolesForUser.setAppName(mockApp.getName());
1302                 appWithRolesForUser.setOrgUserId(user.getOrgUserId());
1303                 appWithRolesForUser.setAppRoles(mockRoleInAppForUserList);
1304                 List<EPUserAppRoles> epUserAppRolesList = new ArrayList<>();
1305                 EPUserAppRoles appRole1 = new EPUserAppRoles();
1306                 appRole1.setAppId(mockApp.getId());
1307                 appRole1.setId(10l);
1308                 appRole1.setRoleId(roleInAppForUser.roleId);
1309                 epUserAppRolesList.add(appRole1);
1310                 List<EPUserAppRoles> epUserAppRolesList2 = new ArrayList<>();
1311                 EPUserAppRoles appRole2 = new EPUserAppRoles();
1312                 appRole2.setAppId(mockApp.getId());
1313                 appRole2.setId(11l);
1314                 appRole2.setRoleId(roleInAppForUser2.roleId);
1315                 epUserAppRolesList2.add(appRole2);
1316                 EPUserAppRolesRequest mockEpAppRolesRequestData = new EPUserAppRolesRequest();
1317                 Mockito.doNothing().when(dataAccessService).saveDomainObject(mockEpAppRolesRequestData, null);
1318                 final Map<String, Long> params = new HashMap<>();
1319                 params.put("appId", appWithRolesForUser.appId);
1320                 params.put("appRoleId", roleInAppForUser.roleId);
1321                 Mockito.when((List<EPUserAppRoles>) dataAccessService.executeNamedQuery("appRoles", params, null))
1322                                 .thenReturn(epUserAppRolesList);
1323                 params.put("appRoleId", roleInAppForUser2.roleId);
1324                 Mockito.when((List<EPUserAppRoles>) dataAccessService.executeNamedQuery("appRoles", params, null))
1325                                 .thenReturn(epUserAppRolesList2);
1326                 EPUserAppRolesRequestDetail mockEPAppRoleDetail = new EPUserAppRolesRequestDetail();
1327                 Mockito.doNothing().when(dataAccessService).saveDomainObject(mockEPAppRoleDetail, null);
1328                 FieldsValidator expected = new FieldsValidator();
1329                 expected.setHttpStatusCode(Long.valueOf(HttpServletResponse.SC_OK));
1330                 FieldsValidator actual = userRolesCommonServiceImpl.putUserAppRolesRequest(appWithRolesForUser, user);
1331                 assertEquals(expected, actual);
1332         }
1333
1334         @Test
1335         public void importRolesFromRemoteApplicationTest() throws HTTPException {
1336                 EPApp mockApp = mockApp();
1337                 mockApp.setId(2l);
1338                 mockApp.setEnabled(true);
1339                 mockApp.setCentralAuth(false);
1340                 List<EPRole> expected = new ArrayList<>();
1341                 EPRole epRole = new EPRole();
1342                 epRole.setAppId(mockApp.getId());
1343                 epRole.setActive(true);
1344                 epRole.setId(10l);
1345                 epRole.setName("test1");
1346                 EPRole epRole2 = new EPRole();
1347                 epRole2.setAppId(mockApp.getId());
1348                 epRole2.setActive(true);
1349                 epRole2.setId(11l);
1350                 epRole2.setName("test2");
1351                 expected.add(epRole);
1352                 expected.add(epRole2);
1353                 EPRole[] epRoleArray = expected.toArray(new EPRole[expected.size()]);
1354                 Mockito.when(applicationsRestClientService.get(EPRole[].class, mockApp.getId(), "/rolesFull"))
1355                                 .thenReturn(epRoleArray);
1356                 Mockito.when(epRoleServiceImpl.getRole(mockApp.getId(), epRole.getId())).thenReturn(epRole);
1357                 Mockito.when(epRoleServiceImpl.getRole(mockApp.getId(), epRole2.getId())).thenReturn(epRole2);
1358                 List<EPRole> actual = userRolesCommonServiceImpl.importRolesFromRemoteApplication(mockApp.getId());
1359                 assertEquals(expected.size(), actual.size());
1360         }
1361
1362         @SuppressWarnings("deprecation")
1363         @Test
1364         public void getCachedAppRolesForUserTest() {
1365                 EPApp mockApp = mockApp();
1366                 mockApp.setId(2l);
1367                 mockApp.setEnabled(true);
1368                 mockApp.setCentralAuth(false);
1369                 EPUser user = mockUser.mockEPUser();
1370                 List<EPUserApp> expected = new ArrayList<>();
1371                 EPUserApp epUserApp = new EPUserApp();
1372                 EPRole epRole = new EPRole();
1373                 epRole.setAppId(mockApp.getId());
1374                 epRole.setActive(true);
1375                 epRole.setId(10l);
1376                 epRole.setName("test1");
1377                 epUserApp.setApp(mockApp);
1378                 epUserApp.setRole(epRole);
1379                 epUserApp.setUserId(user.getId());
1380                 expected.add(epUserApp);
1381                 String filter = " where user_id = " + Long.toString(user.getId()) + " and app_id = "
1382                                 + Long.toString(mockApp.getId());
1383                 Mockito.when(dataAccessService.getList(EPUserApp.class, filter, null, null)).thenReturn(expected);
1384                 List<EPUserApp> actual = userRolesCommonServiceImpl.getCachedAppRolesForUser(mockApp.getId(), user.getId());
1385                 assertEquals(expected.size(), actual.size());
1386         }
1387
1388         @SuppressWarnings("unchecked")
1389         @Test
1390         public void getUserAppCatalogRolesTest() {
1391                 EPApp mockApp = mockApp();
1392                 mockApp.setId(2l);
1393                 mockApp.setEnabled(true);
1394                 mockApp.setCentralAuth(false);
1395                 EPUser user = mockUser.mockEPUser();
1396                 List<EPUserAppCatalogRoles> expected = new ArrayList<>();
1397                 EPUserAppCatalogRoles epUserAppCatalogRoles = new EPUserAppCatalogRoles();
1398                 epUserAppCatalogRoles.setAppId(mockApp.getId());
1399                 epUserAppCatalogRoles.setId(2l);
1400                 epUserAppCatalogRoles.setRequestedRoleId(10l);
1401                 epUserAppCatalogRoles.setRequestStatus("S");
1402                 epUserAppCatalogRoles.setRolename("test1");
1403                 expected.add(epUserAppCatalogRoles);
1404                 Map<String, String> params = new HashMap<>();
1405                 params.put("userid", user.getId().toString());
1406                 params.put("appName", mockApp.getName());
1407                 Mockito.when(
1408                                 (List<EPUserAppCatalogRoles>) dataAccessService.executeNamedQuery("userAppCatalogRoles", params, null))
1409                                 .thenReturn(expected);
1410                 List<EPUserAppCatalogRoles> actual = userRolesCommonServiceImpl.getUserAppCatalogRoles(user, mockApp.getName());
1411                 assertEquals(expected.size(), actual.size());
1412         }
1413
1414         @Test
1415         public void getExternalRequestAccessTest() {
1416                 ExternalSystemAccess expected = new ExternalSystemAccess("external_access_enable", false);
1417                 ExternalSystemAccess actual = userRolesCommonServiceImpl.getExternalRequestAccess();
1418                 assertEquals(expected, actual);
1419         }
1420
1421         @Test
1422         public void getEPUserAppListTest() {
1423                 EPApp mockApp = mockApp();
1424                 mockApp.setId(2l);
1425                 mockApp.setEnabled(true);
1426                 mockApp.setCentralAuth(false);
1427                 EPUser user = mockUser.mockEPUser();
1428                 List<EPUserApp> expected = new ArrayList<>();
1429                 EPUserApp epUserApp = new EPUserApp();
1430                 EPRole epRole = new EPRole();
1431                 epRole.setAppId(mockApp.getId());
1432                 epRole.setActive(true);
1433                 epRole.setId(10l);
1434                 epRole.setName("test1");
1435                 epUserApp.setApp(mockApp);
1436                 epUserApp.setRole(epRole);
1437                 epUserApp.setUserId(user.getId());
1438                 expected.add(epUserApp);
1439                 final Map<String, Long> params = new HashMap<>();
1440                 params.put("appId", mockApp.getId());
1441                 params.put("userId", user.getId());
1442                 params.put("roleId", epRole.getId());
1443                 Mockito.when(dataAccessService.executeNamedQuery("getUserRoleOnUserIdAndRoleIdAndAppId", params, null))
1444                                 .thenReturn(expected);
1445                 List<EPUserApp> actual = userRolesCommonServiceImpl.getEPUserAppList(mockApp.getId(), user.getId(),
1446                                 epRole.getId());
1447                 assertEquals(expected.size(), actual.size());
1448         }
1449
1450         @Test
1451         public void updateRemoteUserProfileTest() {
1452                 EPApp mockApp = mockApp();
1453                 EPApp mockApp2 = mockApp();
1454                 mockApp.setId(2l);
1455                 mockApp.setEnabled(true);
1456                 mockApp.setCentralAuth(false);
1457                 EPUser user = mockUser.mockEPUser();
1458                 List<EPApp> mockEpAppList = new ArrayList<>();
1459                 mockEpAppList.add(mockApp);
1460                 mockEpAppList.add(mockApp2);
1461                 Mockito.when(searchServiceImpl.searchUserByUserId(user.getOrgUserId())).thenReturn(user);
1462                 Mockito.when(epAppCommonServiceImpl.getUserRemoteApps(user.getId().toString())).thenReturn(mockEpAppList);
1463                 String expected = "success";
1464                 String actual = userRolesCommonServiceImpl.updateRemoteUserProfile(user.getOrgUserId(), mockApp.getId());
1465                 assertEquals(expected, actual);
1466         }
1467 }