User:Zache/Ontop SPARQL-gateway

Homepage

• https://ontop-vkg.org/

Github page

• https://github.com/ontop/ontop

Running

Needed files

• start_ontop.sh
• myproject.properties
• myproject.odbl
• myproject_lenses.json

Commands

Start_ontop.sh

ontop_cli/ontop endpoint \
    --ontology=myproject.ttl \
    --mapping=myproject.odbl  \
    --properties=myproject.properties \
    --cors-allowed-origins='*'
    --lenses=myproject_lenses.json

Command line parameters

ontop_cli/ontop help endpoint

myproject.properties

Config file

#Sun Aug 27 14:33:35 CST 2017
#jdbc.url=jdbc:mariadb://fiwiki.web.db.svc.wikimedia.cloud:3306/fiwiki_p
#jdbc.driver=org.mariadb.jdbc.Driver
jdbc.url=jdbc:postgresql://localhost:5432/postgres
jdbc.driver=org.postgresql.Driver
jdbc.user=imagehash_ro
jdbc.name=6e4bc129-9d1d-4ae5-94e8-45a6ca6a4539
jdbc.password=

myproject.odbl

PrefixDeclaration]
:               http://example.org/voc#
owl:            http://www.w3.org/2002/07/owl#
rdf:            http://www.w3.org/1999/02/22-rdf-syntax-ns#
xml:            http://www.w3.org/XML/1998/namespace
xsd:            http://www.w3.org/2001/XMLSchema#
foaf:           http://xmlns.com/foaf/0.1/
obda:           https://w3id.org/obda/vocabulary#
rdfs:           http://www.w3.org/2000/01/rdf-schema#
wdt:            http://www.wikidata.org/prop/direct/

[MappingDeclaration] @collection [[
mappingId       imagehash_phash
target          :imagehash/phash/{page_id} wdt:P9310 {phash}^^xsd:int; wdt:P12563 {dhash}^^xsd:int .
source          SELECT p.commons as page_id, p.hash as phash, d.hash as dhash FROM mv_phash as p,  mv_dhash as d WHERE p.commons=d.commons

Start using docker

• https://github.com/SPARQL-Anything/sparql.anything/blob/v0.9-DEV/BROWSER.md