001
014
015 package com.liferay.portal.upgrade.v6_1_0;
016
017 import com.liferay.portal.kernel.upgrade.UpgradeProcess;
018 import com.liferay.portal.kernel.util.StringBundler;
019 import com.liferay.portal.kernel.util.StringPool;
020 import com.liferay.portal.model.GroupConstants;
021 import com.liferay.portal.model.ResourceConstants;
022 import com.liferay.portal.model.RoleConstants;
023
024
027 public class UpgradeResourcePermission extends UpgradeProcess {
028
029 @Override
030 protected void doUpgrade() throws Exception {
031 StringBundler sb = new StringBundler(11);
032
033 sb.append("update ResourcePermission set scope = ");
034 sb.append(ResourceConstants.SCOPE_GROUP_TEMPLATE);
035 sb.append(", primKey = '");
036 sb.append(GroupConstants.DEFAULT_PARENT_GROUP_ID);
037 sb.append("' where scope = ");
038 sb.append(ResourceConstants.SCOPE_COMPANY);
039 sb.append(" and primKey = CAST_TEXT(companyId) and exists (select ");
040 sb.append("roleId from Role_ where Role_.roleId = ");
041 sb.append("ResourcePermission.roleId and Role_.type_ = ");
042 sb.append(RoleConstants.TYPE_PROVIDER);
043 sb.append(StringPool.CLOSE_PARENTHESIS);
044
045 runSQL(sb.toString());
046 }
047
048 }