001    /**
002     * Copyright (c) 2000-2011 Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
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("delete from UserGroupRole where roleId = " + role.getRoleId());
060            }
061    
062    }