public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Community community = new Community();
community.id = Long.valueOf(rs.getInt("community_id"));
community.copyright = rs.getString("copyright_text");
community.shortDescription = rs.getString("short_description");
community.name = rs.getString("name");
community.introductoryText = rs.getString("introductory_text");
community.sideBarText = rs.getString("side_bar_text");
community.logoId = rs.getLong("logo_bitstream_id");
return community;
}
/**
* Get all the community records.
*
* @param xmlFileName
* @return
* @throws IOException
*/
@SuppressWarnings("unchecked")
public List<Community> getCommunities() throws IOException {
List<Community> communities =
jdbcTemplate.query("select * from community", new CommunityMapper());
for (Community c : communities) {
if (c.logoId != null && c.logoId > 0) {
System.out.println(c.logoId);
BitstreamFileInfo info = bitstreamFileLoader.getBitstreamFileInfo(c.logoId);
File bitstreamFile = new File(info.dspaceFileName);
info.newFileName = "community_" + c.id + "." + info.extension;
System.out.println(bitstreamFile.getCanonicalPath());
System.out.println("file name = " + info.newFileName);
c.logoFileInfo = info;
}
c.links =
jdbcTemplate.query(
"select * from community_link where community_id = " + c.id,
new CollectionLinkMapper());
String groupPermissionsSelect =
"select * from resourcepolicy where resource_type_id = 4 and epersongroup_id is not null and resource_id = "
+ c.id;
String epersonPermissionsSelect =
"select * from resourcepolicy where resource_type_id = 4 and eperson_id is not null and resource_id = "
+ c.id;
c.groupPermissions = jdbcTemplate.query(groupPermissionsSelect, new GroupPermissionMapper());
c.epersonPermissions =
jdbcTemplate.query(epersonPermissionsSelect, new EpersonPermissionMapper());
}
return communities;
}