public Element createNodeElement(Document dom, int i) {
Element data;
Collaborator col = collaborators.get(i);
Element node = dom.createElement("node");
node.setAttribute("id", col.getId());
for (int row = 0; row < nodeAttr.length; row++) {
data = dom.createElement("data");
data.setAttribute("key", nodeAttr[row][0]);
if (nodeAttr[row][0].equalsIgnoreCase("ContributorID")) data.setTextContent(col.getId());
else if (nodeAttr[row][0].equalsIgnoreCase("Label")) data.setTextContent(col.getName());
else if (nodeAttr[row][0].equalsIgnoreCase("ContributorName"))
data.setTextContent(col.getName());
else if (nodeAttr[row][0].equalsIgnoreCase("Roles")) data.setTextContent(col.getFunction());
else if (nodeAttr[row][0].equalsIgnoreCase("Gender")) data.setTextContent(col.getGender());
else if (nodeAttr[row][0].equalsIgnoreCase("Nationality"))
data.setTextContent(col.getNationality());
else if (nodeAttr[row][0].equalsIgnoreCase("ContributorURL"))
data.setTextContent(col.getUrl());
// data.setTextContent(conURLprefix + col.getId());
node.appendChild(data);
}
return node;
}
/**
* A method to build a collection of collaborator objects representing a network based on an
* organisation
*
* @param id the id of the central organisation
* @param radius the number of edges required from the central contributor
* @return the collection of collaborator objects
*/
@SuppressWarnings("rawtypes")
public TreeMap<Integer, Collaborator> getRawCollaboratorData_org(String id, int radius) {
// check the parameters
if (InputUtils.isValidInt(id) == false) {
throw new IllegalArgumentException("Error: the id parameter is required");
}
if (InputUtils.isValidInt(radius, ExportServlet.MIN_DEGREES, ExportServlet.MAX_DEGREES)
== false) {
throw new IllegalArgumentException(
"Error: the radius parameter must be between "
+ ExportServlet.MIN_DEGREES
+ " and "
+ ExportServlet.MAX_DEGREES);
}
// define helper variables
// collection of collaborators
java.util.TreeMap<Integer, Collaborator> cId_cObj_map =
new java.util.TreeMap<Integer, Collaborator>();
// set of collaborators that we've already processed
java.util.TreeSet<Integer> foundCollaboratorsSet = new java.util.TreeSet<Integer>();
// define other helper variables
String contributor_id = null;
QuerySolution row = null;
Collaborator collaborator = null;
String sql =
"SELECT DISTINCT b.eventid "
+ "FROM events a, orgevlink b "
+ "WHERE b.organisationid = ? " // +id
+ "AND a.eventid = b.eventid";
int[] param = {Integer.parseInt(id)};
java.sql.ResultSet resultSet = db.exePreparedStatement(sql, param);
ArrayList<String> eventResults = new ArrayList<String>();
try {
// check to see that data was returned
if (!resultSet.last()) {
db.tidyup();
return null;
} else resultSet.beforeFirst();
// loop through the resultset
while (resultSet.next() == true) {
eventResults.add(resultSet.getString(1));
}
} catch (java.sql.SQLException ex) {
System.out.println("Exception: " + ex.getMessage());
resultSet = null;
}
db.tidyup();
// helper
int first = 0;
// define the query
String sparqlQuery1 =
"PREFIX foaf: <"
+ FOAF.NS
+ "> "
+ "PREFIX ausestage: <"
+ AuseStage.NS
+ "> "
+ "PREFIX event: <http://purl.org/NET/c4dm/event.owl#> "
+ "PREFIX dcterms: <http://purl.org/dc/terms/> "
+ "SELECT DISTINCT ?agent ?givenName ?familyName "
+ "WHERE { ";
for (String event : eventResults) {
if (first > 0) {
sparqlQuery1 += "UNION ";
}
first++;
sparqlQuery1 +=
"{<ausstage:e:"
+ event
+ "> a event:Event; "
+ " event:agent ?agent. "
+ " ?agent a foaf:Person; "
+ " foaf:givenName ?givenName; "
+ " foaf:familyName ?familyName. "
+ " } ";
}
sparqlQuery1 += " } ";
// execute query
ResultSet results = rdf.executeSparqlQuery(sparqlQuery1);
// now we transfer the results to a TreeMap <Integer,
while (results.hasNext()) {
row = results.nextSolution();
contributor_id = AusStageURI.getId(row.get("agent").toString());
collaborator = new Collaborator(contributor_id);
cId_cObj_map.put(Integer.parseInt(contributor_id), collaborator);
foundCollaboratorsSet.add(Integer.parseInt(contributor_id));
}
rdf.tidyUp();
return cId_cObj_map;
} // end getRawCollaboratorData_org method
@SuppressWarnings("unchecked")
public Document toGraphMLDOM_org(Document egoDom, String id, int radius, String graphType) {
Collaborator collaborator = null;
if (db.connect() == false) {
throw new RuntimeException("Unable to connect to the database");
}
// add the graph element
Element rootElement = egoDom.getDocumentElement();
rootElement = createHeaderElements(egoDom, rootElement, graphType);
Element graph = egoDom.createElement("graph");
graph.setAttribute("id", "Contributor Network for organisation:" + " ( " + id + " )");
graph.setAttribute("edgedefault", graphType);
rootElement.appendChild(graph);
network = getRawCollaboratorData_org(id, radius);
if (network != null) {
// add some additional required information for contributors
collaborators = getCollaborators(network, "0");
// get collaboration List
collaborations = getCollaborations_org(id, network);
} else return egoDom;
// create node element in DOM
for (int i = 0; i < collaborators.size(); i++) {
Element node = createNodeElement(egoDom, i);
graph.appendChild(node);
}
// we have a list of collaborations.
// loop through the list, for each - create a collaboration
// - create edge.
// 1.iterate through the collaboration hashmap
Iterator contributorIter = collaborations.values().iterator();
int edgeIndex = 0;
// collabCheck used to ensure no doubling up of collaborations. (pretty quick hack, ideally this
// issue would be sorted before this point)
Vector collabCheck = new Vector();
while (contributorIter.hasNext()) {
CollaborationList list = (CollaborationList) contributorIter.next();
// get the actual collaborations
if (list != null) {
Iterator collaborationIter = list.getCollaborations().values().iterator();
// loop through the hashmap of collaborations
while (collaborationIter.hasNext()) {
Collaboration collaboration = (Collaboration) collaborationIter.next();
if (!collabCheck.contains(
collaboration.getPartner() + "-" + collaboration.getCollaborator())) {
// create an edge for each of them
Element edge =
createEdgeElement(
egoDom,
collaboration,
Integer.parseInt(collaboration.getCollaborator()),
Integer.parseInt(collaboration.getPartner()),
edgeIndex);
graph.appendChild(edge);
// add the collaboration to the list for checking.
collabCheck.add(collaboration.getCollaborator() + "-" + collaboration.getPartner());
edgeIndex++;
}
}
}
}
return egoDom;
}