protected void convertResourcePermissions(String name, String tableName, String pkColumnName)
throws Exception {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
con = DataAccess.getConnection();
ps = con.prepareStatement("select " + pkColumnName + ", companyId from " + tableName);
rs = ps.executeQuery();
while (rs.next()) {
long primKey = rs.getLong(pkColumnName);
long companyId = rs.getLong("companyId");
ResourceBlock resourceBlock = convertResourcePermissions(companyId, name, primKey);
if (_log.isInfoEnabled() && ((resourceBlock.getResourceBlockId() % 100) == 0)) {
_log.info("Processed 100 resource blocks for " + name);
}
}
} finally {
DataAccess.cleanUp(con, ps, rs);
}
List<ResourcePermission> resourcePermissions =
ResourcePermissionLocalServiceUtil.getScopeResourcePermissions(_SCOPES);
for (ResourcePermission resourcePermission : resourcePermissions) {
int scope = resourcePermission.getScope();
if (!name.equals(resourcePermission.getName())) {
continue;
}
if ((scope == ResourceConstants.SCOPE_COMPANY)
|| (scope == ResourceConstants.SCOPE_GROUP_TEMPLATE)) {
ResourceBlockLocalServiceUtil.setCompanyScopePermissions(
resourcePermission.getCompanyId(),
name,
resourcePermission.getRoleId(),
resourcePermission.getActionIds());
} else if (scope == ResourceConstants.SCOPE_GROUP) {
ResourceBlockLocalServiceUtil.setGroupScopePermissions(
resourcePermission.getCompanyId(),
GetterUtil.getLong(resourcePermission.getPrimaryKey()),
name,
resourcePermission.getRoleId(),
resourcePermission.getActionIds());
}
}
}
