001    /**
002     * Copyright (c) 2000-2011 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            @Override
029            protected void doVerify() throws Exception {
030                    long[] companyIds = PortalInstances.getCompanyIdsBySQL();
031    
032                    for (long companyId : companyIds) {
033                            RoleLocalServiceUtil.checkSystemRoles(companyId);
034    
035                            try {
036                                    Role organizationUserRole = RoleLocalServiceUtil.getRole(
037                                            companyId, RoleConstants.ORGANIZATION_USER);
038    
039                                    deleteImplicitAssociations(organizationUserRole);
040                            }
041                            catch (NoSuchRoleException nsre) {
042                            }
043    
044                            try {
045                                    Role siteMemberRole = RoleLocalServiceUtil.getRole(
046                                            companyId, RoleConstants.SITE_MEMBER);
047    
048                                    deleteImplicitAssociations(siteMemberRole);
049                            }
050                            catch (NoSuchRoleException nsre) {
051                            }
052                    }
053            }
054    
055            protected void deleteImplicitAssociations(Role role) throws Exception {
056                    runSQL(
057                            "delete from UserGroupGroupRole where roleId = " +
058                                    role.getRoleId());
059                    runSQL(
060                            "delete from UserGroupRole where roleId = " + role.getRoleId());
061            }
062    
063    }