http://git-wip-us.apache.org/repos/asf/marmotta/blob/b93cdc78/libraries/kiwi/kiwi-geosparql/src/test/java/org/apache/marmotta/kiwi/sparql/geosparql/GeoSPARQLFunctionsTest.java ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-geosparql/src/test/java/org/apache/marmotta/kiwi/sparql/geosparql/GeoSPARQLFunctionsTest.java b/libraries/kiwi/kiwi-geosparql/src/test/java/org/apache/marmotta/kiwi/sparql/geosparql/GeoSPARQLFunctionsTest.java new file mode 100644 index 0000000..45a04ac --- /dev/null +++ b/libraries/kiwi/kiwi-geosparql/src/test/java/org/apache/marmotta/kiwi/sparql/geosparql/GeoSPARQLFunctionsTest.java @@ -0,0 +1,342 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed with + * this work for additional information regarding copyright ownership. + * The ASF licenses this file to You 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. + */ +package org.apache.marmotta.kiwi.sparql.geosparql; + +import info.aduna.iteration.Iterations; +import org.apache.commons.io.IOUtils; +import org.apache.marmotta.kiwi.config.KiWiConfiguration; +import org.apache.marmotta.kiwi.sail.KiWiStore; +import org.apache.marmotta.kiwi.sparql.sail.KiWiSparqlSail; +import org.junit.*; +import org.junit.rules.TestWatcher; +import org.junit.runner.Description; +import org.openrdf.query.*; +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.RDFFormat; +import org.openrdf.rio.RDFParseException; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; +import java.io.IOException; +import java.sql.SQLException; +import java.util.List; +import org.apache.marmotta.kiwi.persistence.pgsql.PostgreSQLDialect; +import org.apache.marmotta.kiwi.test.helper.DBConnectionChecker; +import org.apache.marmotta.kiwi.test.junit.KiWiDatabaseRunner; + +/** + * Test suite for all the functions of GeoSPARQL implemented. + * + * There is 35 test cases for each function: + * Simple Features Topological Relations (8) + * Egenhofer Topological Relations (8) + * RCC8 Topological Relations (8) + * Non-Topological Functions (11) + * + * @author Xavier Sumba ([email protected]) + * @author Sergio Fernández ([email protected]) + */ +public class GeoSPARQLFunctionsTest { + + private KiWiStore store; + private KiWiSparqlSail sail; + private Repository repository; + + private final KiWiConfiguration dbConfig; + + public GeoSPARQLFunctionsTest() { + logger.info("creating test setup..."); + dbConfig = KiWiDatabaseRunner.createKiWiConfig("PostgreSQL", new PostgreSQLDialect()); + DBConnectionChecker.checkDatabaseAvailability(dbConfig); + + dbConfig.setFulltextEnabled(true); + dbConfig.setFulltextLanguages(new String[]{"en"}); + } + + @Before + public void initDatabase() throws RepositoryException, IOException, RDFParseException { + store = new KiWiStore(dbConfig); + store.setDropTablesOnShutdown(true); + sail = new KiWiSparqlSail(store); + repository = new SailRepository(sail); + repository.initialize(); + + logger.info("loading data to test..."); + + // load demo data spain provinces + RepositoryConnection con = repository.getConnection(); + try { + con.begin(); + con.add(this.getClass().getResourceAsStream("demo_data_spain_provinces.rdf"), "http://localhost/test/";, RDFFormat.RDFXML); + con.add(this.getClass().getResourceAsStream("demo_data_spain_towns.rdf"), "http://localhost/test/";, RDFFormat.RDFXML); + con.add(this.getClass().getResourceAsStream("demo_data_spain_rivers.rdf"), "http://localhost/test/";, RDFFormat.RDFXML); + con.commit(); + } finally { + con.close(); + } + } + + @After + public void dropDatabase() throws RepositoryException, SQLException { + logger.info("cleaning up test setup..."); + if (store != null && store.isInitialized()) { + store.getPersistence().dropDatabase(); + repository.shutDown(); + } + } + + final Logger logger + = LoggerFactory.getLogger(this.getClass()); + + @Rule + public TestWatcher watchman = new TestWatcher() { + /** + * Invoked when a test is about to start + */ + @Override + protected void starting(Description description) { + logger.info("{} being run...", description.getMethodName()); + } + }; + + @Test + public void testSfContains() throws Exception { + testQueryBoolean("sfContains.sparql", "contains"); + } + + @Test + public void testSfCrosses() throws Exception { + testQueryBoolean("sfCrosses.sparql", "crosses"); + } + + @Test + public void testSfDisjoint() throws Exception { + testQueryBoolean("sfDisjoint.sparql", "disjoint"); + } + + @Test + public void testSfEquals() throws Exception { + testQueryBoolean("sfEquals.sparql", "equals"); + } + + @Test + public void testSfIntersects() throws Exception { + testQueryBoolean("sfIntersects.sparql", "intersects"); + } + + @Test + public void testSfOverlaps() throws Exception { + testQueryBoolean("sfOverlaps.sparql", "overlaps"); + } + + @Test + public void testSfTouches() throws Exception { + testQueryBoolean("sfTouches.sparql", "touches"); + } + + @Test + public void testSfWithin() throws Exception { + testQueryBoolean("sfWithin.sparql", "within"); + } + + @Test + public void testBoundary() throws Exception { + testQueryGeometry("boundary.sparql"); + } + + @Test + public void testBuffer() throws Exception { + testQueryGeometry("buffer.sparql"); + } + + @Test + public void testConvexHull() throws Exception { + testQueryGeometry("convexHull.sparql"); + } + + @Test + public void testDifference() throws Exception { + testQueryGeometry("difference.sparql"); + } + + @Test + public void testDistance() throws Exception { + testQueryGeometry("distance.sparql"); + } + + @Test + public void testEnvelope() throws Exception { + testQueryGeometry("envelope.sparql"); + } + + @Test + public void testGetSRID() throws Exception { + testQueryGeometry("getSRID.sparql"); + } + + @Test + public void testIntersection() throws Exception { + testQueryGeometry("intersection.sparql"); + } + + @Test + public void testRelate() throws Exception { + testQueryBoolean("relate.sparql", "relate"); + } + + @Test + public void testSymDifference() throws Exception { + testQueryGeometry("symDifference.sparql"); + } + + @Test + public void testUnion() throws Exception { + testQueryGeometry("union.sparql"); + } + + @Test + public void testEhEquals() throws Exception { + testQueryBoolean("ehEquals.sparql", "equals"); + } + + @Test + public void testEhDisjoint() throws Exception { + testQueryBoolean("ehDisjoint.sparql", "disjoint"); + } + + @Test + public void testEhMeet() throws Exception { + testQueryBoolean("ehMeet.sparql", "ehMeet"); + } + + @Test + public void testEhOverlap() throws Exception { + testQueryBoolean("ehOverlap.sparql", "overlap"); + } + + @Test + public void testEhCovers() throws Exception { + testQueryBoolean("ehCovers.sparql", "covers"); + } + + @Test + public void testEhCoveredBy() throws Exception { + testQueryBoolean("ehCoveredBy.sparql", "coveredBy"); + } + + @Test + public void testEhInside() throws Exception { + testQueryBoolean("ehInside.sparql", "inside"); + } + + @Test + public void testEhContains() throws Exception { + testQueryBoolean("ehContains.sparql", "contains"); + } + + @Test + public void testRcc8eq() throws Exception { + testQueryBoolean("rcc8eq.sparql", "rcc8eq"); + } + + @Test + public void testRcc8dc() throws Exception { + testQueryBoolean("rcc8dc.sparql", "rcc8dc"); + } + + @Test + public void testRcc8ec() throws Exception { + testQueryBoolean("rcc8ec.sparql", "rcc8ec"); + } + + @Test + public void testRcc8po() throws Exception { + testQueryBoolean("rcc8po.sparql", "rcc8po"); + } + + @Test + public void testRcc8tppi() throws Exception { + testQueryBoolean("rcc8tppi.sparql", "rcc8tppi"); + } + + @Test + public void testRcc8tpp() throws Exception { + testQueryBoolean("rcc8tpp.sparql", "rcc8tpp"); + } + + @Test + public void testRcc8ntpp() throws Exception { + testQueryBoolean("rcc8ntpp.sparql", "rcc8ntpp"); + } + + @Test + public void testRcc8ntppi() throws Exception { + testQueryBoolean("rcc8ntppi.sparql", "rcc8ntppi"); + } + + private void testQueryBoolean(String filename, String function) throws Exception { + String queryString = IOUtils.toString(this.getClass().getResourceAsStream(filename), "UTF-8"); + + RepositoryConnection conn = repository.getConnection(); + try { + + conn.begin(); + + TupleQuery query1 = conn.prepareTupleQuery(QueryLanguage.SPARQL, queryString); + TupleQueryResult result1 = query1.evaluate(); + + conn.commit(); + + Assert.assertTrue(result1.hasNext()); + + List<BindingSet> results = Iterations.asList(result1); + + Assert.assertTrue(Boolean.parseBoolean(results.get(0).getValue(function).stringValue())); + } catch (RepositoryException ex) { + conn.rollback(); + } finally { + conn.close(); + } + } + + private void testQueryGeometry(String filename) throws Exception { + String queryString = IOUtils.toString(this.getClass().getResourceAsStream(filename), "UTF-8"); + + RepositoryConnection conn = repository.getConnection(); + try { + + conn.begin(); + + TupleQuery query1 = conn.prepareTupleQuery(QueryLanguage.SPARQL, queryString); + TupleQueryResult result1 = query1.evaluate(); + + conn.commit(); + + Assert.assertTrue(result1.hasNext()); + + List<BindingSet> results = Iterations.asList(result1); + + Assert.assertEquals(1, results.size()); + } catch (RepositoryException ex) { + conn.rollback(); + } finally { + conn.close(); + } + } +}
http://git-wip-us.apache.org/repos/asf/marmotta/blob/b93cdc78/libraries/kiwi/kiwi-geosparql/src/test/resources/boundary.sparql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-geosparql/src/test/resources/boundary.sparql b/libraries/kiwi/kiwi-geosparql/src/test/resources/boundary.sparql new file mode 100644 index 0000000..1e0827f --- /dev/null +++ b/libraries/kiwi/kiwi-geosparql/src/test/resources/boundary.sparql @@ -0,0 +1,28 @@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you 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. +# +PREFIX geoes: <http://geo.marmotta.es/ontology#> +PREFIX geo: <http://www.opengis.net/ont/geosparql#> +PREFIX geof: <http://www.opengis.net/def/function/geosparql/> + +SELECT DISTINCT ?wktA (geof:boundary(?wktA) as ?boundary) +WHERE { + ?subject a <http://geo.marmotta.es/ontology#provincia>. + ?subject rdfs:label "Madrid"@es. + ?subject geoes:hasExactGeometry ?geo. + ?geo geo:asWKT ?wktA. +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/marmotta/blob/b93cdc78/libraries/kiwi/kiwi-geosparql/src/test/resources/buffer.sparql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-geosparql/src/test/resources/buffer.sparql b/libraries/kiwi/kiwi-geosparql/src/test/resources/buffer.sparql new file mode 100644 index 0000000..d2eadb7 --- /dev/null +++ b/libraries/kiwi/kiwi-geosparql/src/test/resources/buffer.sparql @@ -0,0 +1,30 @@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you 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. +# +PREFIX geoes: <http://geo.marmotta.es/ontology#> +PREFIX geo: <http://www.opengis.net/ont/geosparql#> +PREFIX geof: <http://www.opengis.net/def/function/geosparql/> +PREFIX units: <http://www.opengis.net/def/uom/OGC/1.0/> + +SELECT DISTINCT ?municipio ?wkt (geof:buffer(?wkt, 100, units:metre) as ?buffer) +WHERE { + ?subject a <http://geo.marmotta.es/ontology#municipio>. + ?subject rdfs:label ?municipio. + ?subject rdfs:label "Ajalvir" @es. + ?subject geoes:hasExactGeometry ?geo. + ?geo geo:asWKT ?wkt. +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/marmotta/blob/b93cdc78/libraries/kiwi/kiwi-geosparql/src/test/resources/convexHull.sparql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-geosparql/src/test/resources/convexHull.sparql b/libraries/kiwi/kiwi-geosparql/src/test/resources/convexHull.sparql new file mode 100644 index 0000000..f203271 --- /dev/null +++ b/libraries/kiwi/kiwi-geosparql/src/test/resources/convexHull.sparql @@ -0,0 +1,28 @@ +# +# Licensed to the Apache Software Foundation (ASF) under one +# or more contributor license agreements. See the NOTICE file +# distributed with this work for additional information +# regarding copyright ownership. The ASF licenses this file +# to you 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. +# +PREFIX geoes: <http://geo.marmotta.es/ontology#> +PREFIX geo: <http://www.opengis.net/ont/geosparql#> +PREFIX geof: <http://www.opengis.net/def/function/geosparql/> + +SELECT DISTINCT ?wkt (geof:convexHull(?wkt) as ?convexHull) +WHERE { + ?subject a <http://geo.marmotta.es/ontology#provincia>. + ?subject rdfs:label "Barcelona"@es. + ?subject geoes:hasExactGeometry ?geo. + ?geo geo:asWKT ?wkt. +} \ No newline at end of file
