applicationsystemtype.tarql.template

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX hito: <http://hitontology.eu/ontology/>                                                                      
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>

CONSTRUCT
{
    ?f a hito:ApplicationSystemTypeClassified;
	hito:astClaFrom ?cat;
	rdfs:comment ?co;
	skos:definition ?def;
	skos:definition ?def_de;
	hito:internalId ?num;
	dcterms:source ?dcts;
	rdfs:label ?len;
	rdfs:label ?lde.
}
FROM <file:../applicationsystemtype.csv>
WHERE
{
   BIND (URI(CONCAT(tarql:expandPrefix('hito'),?uri)) AS ?f)
   BIND (IF(?comment != '', STRLANG(?comment,"en"), ?nothing) AS ?co)
   BIND (IF(?definition!= '', STRLANG(?definition,"en"), ?nothing) AS ?def)
   BIND (IF(?definition_de!= '', STRLANG(?definition_de,"en"), ?nothing) AS ?def_de)
   BIND (IF(?en != '', STRLANG(?en,"en"), ?nothing) AS ?len)
   BIND (IF(?de != '', STRLANG(?de,"de"), ?nothing) AS ?lde)
   BIND (URI(CONCAT(tarql:expandPrefix('hito'),"{SUB}ApplicationSystemTypeCatalogue")) AS ?cat)
   BIND (IF(BOUND(?n)&&(?n != ''), ?n, ?nothing) AS ?num)
   BIND (IF(BOUND(?dctsource)&&(?dctsource != ''), URI(tarql:expandPrefixedName(?dctsource)), ?nothing) AS ?dcts)
}

CONSTRUCT
{
    ?f skos:altLabel ?synonymen.
}
FROM <file:../applicationsystemtype.csv>
WHERE
{
   BIND (URI(CONCAT(tarql:expandPrefix('hito'),?uri)) AS ?f)
   ?synonym apf:strSplit (?synonyms ";")
   BIND (STRLANG(?synonym,"en") AS ?synonymen)
}

CONSTRUCT
{
    ?f skos:altLabel ?synonymde.
}
FROM <file:../applicationsystemtype.csv>
WHERE
{
   BIND (URI(CONCAT(tarql:expandPrefix('hito'),?uri)) AS ?f)
   ?synonym apf:strSplit (?synonyms_de ";")
   BIND (STRLANG(?synonym,"de") AS ?synonymde)
}

CONSTRUCT
{
    ?f dc:source ?dce.
}
FROM <file:../function.csv>
WHERE
{
   BIND (URI(CONCAT(tarql:expandPrefix('hito'),?uri)) AS ?f)
   ?dce apf:strSplit (?dcesource ";")
}