Jindřich Mynarz jindrichmynarz

Data for the queries

The queries use statistical yearbook data on pensions in the Czech Republic. The data is modelled using the Data Cube Vocabulary.

Load statistical yearbooks of pensions into the named graph <https://data.cssz.cz/resource/dataset/duchodci-v-cr-krajich-okresech>.
Load code lists into the named graph ``.

	PREFIX country: <http://eurostat.linked-statistics.org/dic/geo#>
	PREFIX currency: <http://eurostat.linked-statistics.org/dic/currency#>
	PREFIX deflator-unit: <http://eurostat.linked-statistics.org/dic/unit#>
	PREFIX eurostat: <http://eurostat.linked-statistics.org/property#>
	PREFIX na-item: <http://eurostat.linked-statistics.org/dic/na_item#>
	PREFIX qb: <http://purl.org/linked-data/cube#>
	PREFIX sdmx-code: <http://purl.org/linked-data/sdmx/2009/code#>
	PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
	PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
	PREFIX statinfo: <http://eurostat.linked-statistics.org/dic/statinfo#>

	(ns generating-sparql.spin-jsonld
	(:require [generating-sparql.data :as data]
	[cheshire.core :as json]
	[clojure.java.io :as io])
	(:import [org.apache.jena.rdf.model ModelFactory]
	[org.apache.jena.riot Lang RDFDataMgr]
	[org.apache.jena.query DatasetFactory]
	[org.topbraid.spin.model SPINFactory]
	[org.topbraid.spin.arq ARQFactory]))

	(ns generating-sparql.spin
	(:import [org.apache.jena.rdf.model ModelFactory]
	[org.topbraid.spin.model SPINFactory]
	[org.topbraid.spin.arq ARQFactory]))

	; Disable caching to allow debugging
	(.setUseCaches (ARQFactory/get) false)

	(def query
	(let [model (doto (ModelFactory/createDefaultModel) (.read "query.ttl"))

	(ns generating-sparql.jena-query-builder
	(:require [generating-sparql.data :as data])
	(:import [org.apache.jena.arq.querybuilder SelectBuilder]
	[org.apache.jena.vocabulary RDF]
	[org.apache.jena.rdf.model ResourceFactory]
	[org.apache.jena.sparql.core Var]
	[org.apache.jena.sparql.expr ExprAggregator ExprVar]
	[org.apache.jena.sparql.expr.aggregate AggSample]))

	(defn query

	(ns generating-sparql.matsu
	(:require [generating-sparql.data :as data]
	[boutros.matsu.sparql :refer :all :exclude [concat count filter]]
	[boutros.matsu.core :refer [register-namespaces]]))

	(def namespaces {:dbo "http://dbpedia.org/ontology/"
	:foaf "http://xmlns.com/foaf/0.1/"
	:rdf "http://www.w3.org/1999/02/22-rdf-syntax-ns#"})

	(register-namespaces (into {} (map (fn [[k v]] [k (str "<" v ">")]) namespaces)))

	(ns generating-sparql.templating
	(:require [generating-sparql.data :as data]
	[stencil.core :refer [render-file]]))

	(defn query
	[properties limit offset]
	(render-file "query.mustache" {:properties properties
	:limit limit
	:offset offset}))

	(ns generating-sparql.prepared-statement
	(:require [generating-sparql.data :as data]
	[clojure.java.io :as io])
	(:import [org.apache.jena.query DatasetFactory QueryExecutionFactory QuerySolutionMap]
	[org.apache.jena.rdf.model ResourceFactory]
	[org.apache.jena.datatypes.xsd XSDDatatype]))

	(def parameterized-query (slurp (io/resource "parametrized_query.rq")))

	(defn ->integer [n] (ResourceFactory/createTypedLiteral (str n) XSDDatatype/XSDinteger))

	(ns generating-sparql.parametrized-query
	(:require [generating-sparql.data :as data]
	[clojure.java.io :as io])
	(:import [org.apache.jena.query ParameterizedSparqlString QuerySolutionMap]
	[org.apache.jena.rdf.model ResourceFactory]
	[org.apache.jena.datatypes.xsd XSDDatatype]))

	(def parameterized-query (slurp (io/resource "parametrized_query.rq")))

	(defn ->integer [n] (ResourceFactory/createTypedLiteral (str n) XSDDatatype/XSDinteger))

	(ns generating-sparql.string-concatenation
	(:require [generating-sparql.data :as data]))

	(defn query
	[properties limit offset]
	(letfn [(lines [template-fn properties]
	(str \newline
	(->> properties
	(map template-fn)
	(interpose \newline)