001
014
015 package com.liferay.portal.verify;
016
017 import com.liferay.portal.NoSuchRoleException;
018 import com.liferay.portal.model.Role;
019 import com.liferay.portal.model.RoleConstants;
020 import com.liferay.portal.service.RoleLocalServiceUtil;
021 import com.liferay.portal.util.PortalInstances;
022
023
026 public class VerifyRole extends VerifyProcess {
027
028 protected void deleteImplicitAssociations(Role role) throws Exception {
029 runSQL(
030 "delete from UserGroupGroupRole where roleId = " +
031 role.getRoleId());
032 runSQL("delete from UserGroupRole where roleId = " + role.getRoleId());
033 }
034
035 @Override
036 protected void doVerify() throws Exception {
037 long[] companyIds = PortalInstances.getCompanyIdsBySQL();
038
039 for (long companyId : companyIds) {
040 RoleLocalServiceUtil.checkSystemRoles(companyId);
041
042 try {
043 Role organizationUserRole = RoleLocalServiceUtil.getRole(
044 companyId, RoleConstants.ORGANIZATION_USER);
045
046 deleteImplicitAssociations(organizationUserRole);
047 }
048 catch (NoSuchRoleException nsre) {
049 }
050
051 try {
052 Role siteMemberRole = RoleLocalServiceUtil.getRole(
053 companyId, RoleConstants.SITE_MEMBER);
054
055 deleteImplicitAssociations(siteMemberRole);
056 }
057 catch (NoSuchRoleException nsre) {
058 }
059 }
060 }
061
062 }