prerna.rdf.main.Printer Maven / Gradle / Ivy
The newest version!
/*******************************************************************************
* 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.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.util.List;
import org.apache.jena.ontology.OntModelSpec;
import org.apache.jena.query.QueryExecution;
import org.apache.jena.query.QueryExecutionFactory;
import org.apache.jena.query.QueryFactory;
import org.apache.jena.query.ResultSet;
import org.apache.jena.query.ResultSetFormatter;
import org.apache.jena.rdf.model.Model;
import org.apache.jena.rdf.model.ModelFactory;
import org.apache.jena.rdf.model.Resource;
import org.apache.jena.rdf.model.Statement;
import org.apache.jena.reasoner.ReasonerRegistry;
import org.apache.jena.vocabulary.RDF;
import org.apache.jena.vocabulary.RDFS;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;
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 prerna.util.Constants;
/**
*/
public class Printer {
protected static final Logger logger = LogManager.getLogger(Printer.class);
// /**
// * 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);
org.apache.jena.rdf.model.Resource beijing = baseModel.createResource("http://example.org/things/Beijing");
org.apache.jena.rdf.model.Resource city = baseModel.createResource("http://example.org/terms/city");
org.apache.jena.rdf.model.Resource place = baseModel.createResource("http://example.org/terms/place");
org.apache.jena.rdf.model.Resource doctor123 = baseModel.createResource("http://example.org/Doctor/123");
org.apache.jena.rdf.model.Resource doctor = baseModel.createResource("http://example.org/terms/Doctor");
org.apache.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();
FileOutputStream fox = null;
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);
org.apache.jena.query.Query q2 = QueryFactory.create(query);
QueryExecution qex = QueryExecutionFactory.create(q2, jenaModel);
ResultSet rs = qex.execSelect();
String [] var = getVariables(rs);
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)
{
logger.error(Constants.STACKTRACE, ex);
} finally {
try {
if(fox != null) {
fox.close();
}
} catch (IOException e) {
// TODO Auto-generated catch block
logger.error(Constants.STACKTRACE, e);
}
}
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
logger.error(Constants.STACKTRACE, ex);
}
}
/**
* 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) {
logger.error(Constants.STACKTRACE, e);
} catch (MalformedQueryException e) {
logger.error(Constants.STACKTRACE, e);
} catch (QueryEvaluationException e) {
logger.error(Constants.STACKTRACE, e);
}
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) {
logger.error(Constants.STACKTRACE, e);
} catch (MalformedQueryException e) {
logger.error(Constants.STACKTRACE, e);
} catch (QueryEvaluationException e) {
logger.error(Constants.STACKTRACE, e);
}
return res;
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy