001    /**
002     * Copyright (c) 2000-2010 Liferay, Inc. All rights reserved.
003     *
004     * The contents of this file are subject to the terms of the Liferay Enterprise
005     * Subscription License ("License"). You may not use this file except in
006     * compliance with the License. You can obtain a copy of the License by
007     * contacting Liferay, Inc. See the License for the specific language governing
008     * permissions and limitations under the License, including but not limited to
009     * distribution rights of the Software.
010     *
011     *
012     *
013     */
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    /**
024     * @author Brian Wing Shun Chan
025     */
026    public class VerifyRole extends VerifyProcess {
027    
028            protected void doVerify() throws Exception {
029                    long[] companyIds = PortalInstances.getCompanyIdsBySQL();
030    
031                    for (long companyId : companyIds) {
032                            RoleLocalServiceUtil.checkSystemRoles(companyId);
033    
034                            try {
035                                    Role communityMemberRole = RoleLocalServiceUtil.getRole(
036                                            companyId, RoleConstants.COMMUNITY_MEMBER);
037    
038                                    deleteImplicitAssociations(communityMemberRole);
039                            }
040                            catch (NoSuchRoleException nsre) {
041                            }
042    
043                            try {
044                                    Role organizationMemberRole = RoleLocalServiceUtil.getRole(
045                                            companyId, RoleConstants.ORGANIZATION_MEMBER);
046    
047                                    deleteImplicitAssociations(organizationMemberRole);
048                            }
049                            catch (NoSuchRoleException nsre) {
050                            }
051                    }
052            }
053    
054            protected void deleteImplicitAssociations(Role role) throws Exception {
055                    runSQL(
056                            "delete from UserGroupGroupRole where roleId = " +
057                                    role.getRoleId());
058                    runSQL(
059                            "delete from UserGroupRole where roleId = " + role.getRoleId());
060            }
061    
062    }