@prefix rr: <http://www.w3.org/ns/r2rml#> .
@prefix daq:     <http://purl.org/eis/vocab/daq#> .
@prefix rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs:    <http://www.w3.org/2000/01/rdf-schema#> .
@prefix ex: <http://example.com/ns#> .
@prefix xsd:    <http://www.w3.org/2001/XMLSchema#> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix dc: <http://purl.org/dc/elements/1.1/> .
@prefix vocab: <http://purl.org/vocab/vann/> .


<#Class-ValidationRule-View>
    rr:sqlQuery """
    SELECT DISTINCT CATEGORY, DIMENSION, ERROR_DESCRIPTION, ORA_ERROR  || 'ERROR' as ORA_ERROR_ID
FROM VALIDATION_RULE inner join ORA_ERRORS on ORA_ERRORS.ERROR_ID=VALIDATION_RULE.ORA_ERROR;
        """;
    rr:sqlVersion rr:Oracle .

    <#OracleCategory>
        rr:logicalTable <#Class-ValidationRule-View> ;
        rr:subjectMap [
            rr:template "http://data.example.com/category/{CATEGORY}" ;
            rr:class rdfs:Class ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:label ;
            rr:objectMap [ rr:column "CATEGORY" ];
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:subClassOf ;
            rr:objectMap [ rr:constant daq:Category ] ;
        ] .

    <#TriplesMapForDimensionClass>
        rr:logicalTable <#Class-ValidationRule-View> ;
        rr:subjectMap [
            rr:template "http://data.example.com/dimension/{DIMENSION}";
            rr:class rdfs:Class ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:label ;
            rr:objectMap [ rr:column "DIMENSION" ];
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:subClassOf ;
            rr:objectMap [ rr:constant daq:Dimension ] ;
        ] .

    <#TriplesMapForDimensionProperty>
        rr:logicalTable <#Class-ValidationRule-View> ;
        rr:subjectMap [
            rr:template "http://data.example.com/dimension/has{DIMENSION}Dimension";
            rr:class rdf:Property ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:subPropertyOf ;
            rr:objectMap [ rr:constant daq:hasDimension ] ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:domain ;
            rr:objectMap [ rr:template "http://data.example.com/category/{CATEGORY}" ] ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:range ;
            rr:objectMap [ rr:template "http://data.example.com/dimension/{DIMENSION}" ] ;
        ] .

    <#TriplesMapForMetricClass>
        rr:logicalTable <#Class-ValidationRule-View> ;
        rr:subjectMap [
            rr:template "http://data.example.com/metric/{ORA_ERROR_ID}";
            rr:class rdfs:Class ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:label ;
            rr:objectMap [ rr:column "ORA_ERROR_ID" ];
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:subClassOf ;
            rr:objectMap [ rr:constant daq:Metric ] ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:comment ;
            rr:objectMap [ rr:column "ERROR_DESCRIPTION" ] ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate daq:expectedDataType ;
            rr:objectMap [ rr:constant xsd:double ] ;
        ] .

    <#TriplesMapForMetricProperty>
        rr:logicalTable <#Class-ValidationRule-View> ;
        rr:subjectMap [
            rr:template "http://data.example.com/metric/has{ORA_ERROR_ID}Metric";
            rr:class rdf:Property ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:subPropertyOf ;
            rr:objectMap [ rr:constant daq:hasMetric ] ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:domain ;
            rr:objectMap [ rr:template "http://data.example.com/dimension/{DIMENSION}" ] ;
        ] ;
        rr:predicateObjectMap [
            rr:predicate rdfs:range ;
            rr:objectMap [ rr:template "http://data.example.com/metric/{ORA_ERROR_ID}" ] ;
        ] .