All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
prerna.rdf.main.Printer Maven / Gradle / Ivy
/*******************************************************************************
* Copyright 2015 Defense Health Agency (DHA)
*
* If your use of this software does not include any GPLv2 components:
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
* ----------------------------------------------------------------------------
* If your use of this software includes any GPLv2 components:
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*******************************************************************************/
package prerna.rdf.main;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.util.List;
import java.util.Properties;
import org.openrdf.model.impl.URIImpl;
import org.openrdf.query.BindingSet;
import org.openrdf.query.GraphQuery;
import org.openrdf.query.GraphQueryResult;
import org.openrdf.query.MalformedQueryException;
import org.openrdf.query.QueryEvaluationException;
import org.openrdf.query.QueryLanguage;
import org.openrdf.query.TupleQuery;
import org.openrdf.query.TupleQueryResult;
import org.openrdf.query.Update;
import org.openrdf.repository.Repository;
import org.openrdf.repository.RepositoryConnection;
import org.openrdf.repository.RepositoryException;
import org.openrdf.repository.sail.SailRepository;
import org.openrdf.rio.rdfxml.util.RDFXMLPrettyWriter;
import org.openrdf.sail.inferencer.fc.ForwardChainingRDFSInferencer;
import org.openrdf.sail.memory.MemoryStore;
import com.hp.hpl.jena.ontology.OntModelSpec;
import com.hp.hpl.jena.query.QueryExecution;
import com.hp.hpl.jena.query.QueryExecutionFactory;
import com.hp.hpl.jena.query.QueryFactory;
import com.hp.hpl.jena.query.ResultSet;
import com.hp.hpl.jena.query.ResultSetFormatter;
import com.hp.hpl.jena.rdf.model.Model;
import com.hp.hpl.jena.rdf.model.ModelFactory;
import com.hp.hpl.jena.rdf.model.Resource;
import com.hp.hpl.jena.rdf.model.Statement;
import com.hp.hpl.jena.reasoner.ReasonerRegistry;
import com.hp.hpl.jena.vocabulary.RDF;
import com.hp.hpl.jena.vocabulary.RDFS;
/**
*/
public class Printer {
/**
* Method main.
* @param args String[]
*/
public static void main(String [] args) throws Exception
{
String q2 = "SELECT ?Subject ?Predicate ?Object WHERE " +
"{" +
"{?Predicate ;} " +
"{?Subject ;}" +
"{?Object ;}" +
"{?Subject ?Predicate ?Object}" +
"} BINDINGS ?Subject {()} " +
""; // working query
String conceptHierarchyForSubject = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE " +
"{" +
"{?Subject ?Object}" +
//"{?Object ;}"+
"{?Subject ?Predicate ?Object}" +
"} BINDINGS ?Subject {()} " +
"";// working one
String relationHierarchy = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE " +
"{" +
"{?Subject ?Predicate ?Object}" +
"} BINDINGS ?Subject {()} " +
"";// relation hierarcy
String predicateSelectQuery = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE {" +
//"BIND ( AS ?Subject)" +
"{?Predicate " +" ;}" +
"{?Subject " + " ;}" +
//"{?Object " + " ;}" +
//"{?Object " + " " + " ;}" +
//"{?Subject ?Predicate }" +
//"{?Subject ?Object}" +
"{?Subject ?Predicate ?Object}"+
"}";
//String propertyHierarchy =
String q4 = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE " +
"{" +
"{?Subject ;}" +
//"{?Object ;}" +
//"{?Subject }" +
"{?Subject ?Predicate ?Object}" +
"} BINDINGS ?Subject {()} " +
"?Predicate {()}" +
"";
String findPropertyRelationQuery = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE " +
"{" +
"{?Subject ?Predicate ?Object}" +
"{?Object }" +
//"} BINDINGS ?Subject { " + predicates + " } " +
"}";// relation hierarcy
String q = findPropertyRelationQuery;
// +"{?Subject ?Predicate ?Object} } BINDINGS ?Predicate {()}";
System.out.println("Query");
System.out.println(q);
Printer printer = new Printer();
//printer.tryRDF();
printer.tryRDFSesame();
printer.tryPropTest();
}
/**
* Method tryPropTest.
*/
private void tryPropTest() throws Exception{
Properties prop = new Properties();
prop.load(new FileInputStream("Sample.prop"));
prop.put("Doh", "hello");
prop.store(new FileOutputStream("Sample.prop"), "Hello");
}
/**
* Method tryRDF.
*/
public void tryRDF()
{
System.out.println("Jena Start" + System.currentTimeMillis());
//jenaModel = ModelFactory.createDefaultModel(ReificationStyle.Standard);
Model baseModel = ModelFactory.createOntologyModel(OntModelSpec.OWL_MEM_MICRO_RULE_INF);
//ReasonerRegistry.
Model jenaModel = ModelFactory.createInfModel(ReasonerRegistry.getTransitiveReasoner(),baseModel);
com.hp.hpl.jena.rdf.model.Resource beijing = baseModel.createResource("http://example.org/things/Beijing");
com.hp.hpl.jena.rdf.model.Resource city = baseModel.createResource("http://example.org/terms/city");
com.hp.hpl.jena.rdf.model.Resource place = baseModel.createResource("http://example.org/terms/place");
com.hp.hpl.jena.rdf.model.Resource doctor123 = baseModel.createResource("http://example.org/Doctor/123");
com.hp.hpl.jena.rdf.model.Resource doctor = baseModel.createResource("http://example.org/terms/Doctor");
com.hp.hpl.jena.rdf.model.Resource concept = baseModel.createResource("http://example.org/terms/Concept");
Resource beijing2 = baseModel.createResource("http://example.org/things/Beijing");
// Sail reasoner = new ForwardChainingRDFSInferencer(new GraphSail(new TinkerGraph()));
// reasoner.initialize();
try {
// SailConnection c = reasoner.getConnection();
Statement stmt = jenaModel.createStatement(city, RDFS.subClassOf, place);
Statement stmt2 = jenaModel.createStatement(beijing, RDF.type, city);
jenaModel.add(stmt);
jenaModel.add(stmt2);
/*stmt2 = jenaModel.createStatement(doctor123, RDF.type, doctor);
stmt = jenaModel.createStatement(doctor, RDFS.subClassOf, concept);
jenaModel.add(stmt);
jenaModel.add(stmt2);
*/
//jenaModel.commit();
String query3 = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE {" +
//"{?Subject ?Predicate ?Object}" +
//"{?Subject ?Object}" +
//"{?Subject ?Object}" +
"{?Subject ?Predicate }" +
"}";
String query2 = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE {" +
"VALUES ?Object {}" +
"VALUES ?Subject { }" +
//"{?Subject ?Predicate ?Object}" +
//"{?Subject ?Object}" +
//"{?Subject ?Object}" +
"{?Subject ?Predicate ?Object.}" +
"}";
String query = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE {" +
//"{?Subject ?Predicate ?Object}" +
//"{?Subject ?Object}" +
//"{?Subject ?Object}" +
"{?Subject ?Predicate }" +
"{?Subject ?Predicate ?Object}" +
"}";
System.out.println("Query is " + query);
com.hp.hpl.jena.query.Query q2 = QueryFactory.create(query);
QueryExecution qex = QueryExecutionFactory.create(q2, jenaModel);
ResultSet rs = qex.execSelect();
String [] var = getVariables(rs);
FileOutputStream fox = new FileOutputStream("output.txt");
ResultSetFormatter.out(System.out, rs);
//ResultSetFormatter.out(fox, rs);
/*while(rs.hasNext())
{
QuerySolution row = rs.nextSolution();
System.out.println(row.get(var[0])+"");
System.out.println(row.get(var[1])+"");
System.out.println(row.get(var[2]));
}*/
}catch (Exception ex)
{
ex.printStackTrace();
}
System.out.println("Jena End" + System.currentTimeMillis());
}
/**
* Method getVariables.
* @param rs ResultSet
* @return String[] */
public String[] getVariables(ResultSet rs)
{
String [] var = new String[rs.getResultVars().size()];
var = new String[rs.getResultVars().size()];
List names = rs.getResultVars();
for(int colIndex = 0;colIndex < names.size();var[colIndex] = names.get(colIndex), colIndex++);
return var;
}
/**
* Method tryRDFSesame.
*/
public void tryRDFSesame() throws Exception
{
System.out.println("Sesame Start" + System.currentTimeMillis());
Repository myRepository = new SailRepository(
new ForwardChainingRDFSInferencer(
new MemoryStore()));
myRepository.initialize();
RepositoryConnection rc = myRepository.getConnection();
org.openrdf.model.Resource beijing = new URIImpl("http://example.org/things/Beijing");
org.openrdf.model.Resource city = new URIImpl("http://example.org/terms/city");
org.openrdf.model.Resource place = new URIImpl("http://example.org/terms/place");
org.openrdf.model.Resource beijing2 = new URIImpl("http://example.org/things/Beijing");
// Sail reasoner = new ForwardChainingRDFSInferencer(new GraphSail(new TinkerGraph()));
// reasoner.initialize();
try {
// SailConnection c = reasoner.getConnection();
rc.add(city, org.openrdf.model.vocabulary.RDFS.SUBCLASSOF, place);
rc.add(beijing, org.openrdf.model.vocabulary.RDF.TYPE, city);
//InferenceEngine ie = bdSail.getInferenceEngine();
//ie.computeClosure(null);
//rc.commit();
String query = "SELECT DISTINCT ?Subject ?Predicate ?Object WHERE {" +
//"{?Subject ?Predicate ?Object}" +
//"{?Subject ?Object}" +
//"{?Subject ?Object}" +
"{?Subject ?Predicate ;}" +
"{?Subject ?Predicate ?Object}" +
"}";
String deleteQuery2 = "DELETE WHERE {?Subject <" + RDF.type + "> }";
String deleteQuery3 = "DELETE {?Subject ?Predicate ?Object} WHERE {" +
"{ <" + org.openrdf.model.vocabulary.RDFS.SUBCLASSOF + "> ;}" +
"{ ?Predicate ;}" +
"{?Subject ?Predicate ?Object}" +
"}";
String deleteQuery4 = "DELETE {?Subject ?Predicate ?Object} WHERE {" +
"BIND ( AS ?Subject)" +
"{?Subject ?Predicate ?Object}" +
"}";
String deleteQuery5 = "DELETE {?Subject ?Predicate ?Object} WHERE {" +
"{?Subject ?Predicate ?Object}" +
"}BINDINGS ?Subject { }" ;
String deleteQuery = "DELETE WHERE {" +
//"BIND ( AS ?Predicate)" +
//"{ " + "<" + org.openrdf.model.vocabulary.RDFS.SUBCLASSOF + "> ;} " +
"" + " ?Object; " +
//"" + " ; " +
//"{?Subject ?Predicate ?Object;}" +
"}";
System.out.println("Deleting query " + deleteQuery);
TupleQueryResult tqr = execSelectQuery(query,rc);
while(tqr.hasNext())
{
BindingSet bs = tqr.next();
System.out.println(bs.getBinding("Subject") + "<>" + bs.getBinding("Predicate") + "<>" + bs.getBinding("Object"));
}
System.out.println("Deleting now " + deleteQuery + System.currentTimeMillis());
Update update = rc.prepareUpdate(QueryLanguage.SPARQL, deleteQuery);
update.execute();
//rc.commit();
System.out.println("Deleting now " + deleteQuery + System.currentTimeMillis());
tqr = execSelectQuery(query,rc);
while(tqr.hasNext())
{
BindingSet bs = tqr.next();
System.out.println(bs.getBinding("Subject") + "<>" + bs.getBinding("Predicate") + "<>" + bs.getBinding("Object"));
}
// re-adding...
rc.add(beijing, org.openrdf.model.vocabulary.RDF.TYPE, city);
rc.export(new RDFXMLPrettyWriter(new FileWriter("Sample.rdf")));
tqr = execSelectQuery(query,rc);
while(tqr.hasNext())
{
BindingSet bs = tqr.next();
System.out.println(bs.getBinding("Subject") + "<>" + bs.getBinding("Predicate") + "<>" + bs.getBinding("Object"));
}
System.out.println("Sesame end" + System.currentTimeMillis());
}catch(Exception ex)
{
// nothings
ex.printStackTrace();
}
}
/**
* Method execSelectQuery.
* @param query String
* @param rc RepositoryConnection
* @return TupleQueryResult */
public TupleQueryResult execSelectQuery(String query, RepositoryConnection rc) {
TupleQueryResult sparqlResults = null;
try {
TupleQuery tq = rc.prepareTupleQuery(QueryLanguage.SPARQL, query);
System.out.println("\nSPARQL: " + query);
tq.setIncludeInferred(true /* includeInferred */);
sparqlResults = tq.evaluate();
} catch (RepositoryException e) {
e.printStackTrace();
} catch (MalformedQueryException e) {
e.printStackTrace();
} catch (QueryEvaluationException e) {
e.printStackTrace();
}
return sparqlResults;
}
/**
* Method execGraphQuery.
* @param query String
* @param rc RepositoryConnection
* @return GraphQueryResult */
public GraphQueryResult execGraphQuery(String query, RepositoryConnection rc) {
GraphQueryResult res = null;
try {
GraphQuery sagq = rc.prepareGraphQuery(QueryLanguage.SPARQL,
query);
res = sagq.evaluate();
} catch (RepositoryException e) {
e.printStackTrace();
} catch (MalformedQueryException e) {
e.printStackTrace();
} catch (QueryEvaluationException e) {
e.printStackTrace();
}
return res;
}
}
