@prefix map: <file:/home/olivier/d2r-server-0.6/mapping.n3#> .
@prefix db: <> .
@prefix vocab: <http://localhost:2020/vocab/resource/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .
@prefix d2rq: <http://www.wiwiss.fu-berlin.de/suhl/bizer/D2RQ/0.1#> .
@prefix jdbc: <http://d2rq.org/terms/jdbc/> .
@prefix debbugs:    <http://helios-project.org/ontologies/2009/01/20/debbugs#> .
@prefix foaf:	    <http://xmlns.com/foaf/0.1/> .
@prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .

<> a d2r:Server;
    rdfs:label "D2R Server";
#    d2r:baseURI <http://inf-6632.int-evry.fr:2020/>;
    d2r:baseURI <http://localhost:2020/>;
    d2r:port 2020;
    d2r:documentMetadata [
        rdfs:comment "This comment is custom document metadata.";
    ];
#	d2r:vocabularyIncludeInstances true;    
    .

map:database a d2rq:Database;
        d2rq:jdbcDriver "org.postgresql.Driver";
        d2rq:jdbcDSN "jdbc:postgresql://127.0.0.1/UDD";
        d2rq:username "udd";
        d2rq:password "xxxxxx";
#	d2rq:resultSizeLimit 500;
        .

# View d2r_bugs (contents of the bugs table plus de-enumed severity)
map:debbug a d2rq:ClassMap;
        d2rq:dataStorage map:database;
        d2rq:uriPattern "debbug/@@d2r_bugsouterjoin.id@@";
        d2rq:class debbugs:Debbug;
        d2rq:classDefinitionLabel "UDD bugs";

        .
map:debbug__label a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property rdfs:label;
        d2rq:pattern "Debian bug #@@d2r_bugsouterjoin.id@@";
        .
map:debbug_bugurl a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property debbugs:bugUrl;
        d2rq:propertyDefinitionLabel "bug URL";
#	d2rq:column "d2r_bugsouterjoin.id";
#	d2rq:datatype xsd:int;
        d2rq:uriPattern "http://bugs.debian.org/@@d2r_bugsouterjoin.id@@";
        .
map:debbug_id a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property debbugs:number;
        d2rq:propertyDefinitionLabel "bugs id";
        d2rq:column "d2r_bugsouterjoin.id";
        d2rq:datatype xsd:int;
        .
map:debbug_package a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_package;
        d2rq:propertyDefinitionLabel "bugs package";
#	d2rq:column "d2r_bugsouterjoin.package";
        d2rq:uriPattern "package/@@d2r_bugsouterjoin.package@@";
        .
map:debbug_source a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_source;
        d2rq:propertyDefinitionLabel "bugs source";
        d2rq:column "d2r_bugsouterjoin.source";
        .
map:debbug_arrival a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_arrival;
        d2rq:propertyDefinitionLabel "bugs arrival";
        d2rq:column "d2r_bugsouterjoin.arrival";
        d2rq:datatype xsd:dateTime;
        .
map:debbug_status a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_status;
        d2rq:propertyDefinitionLabel "bugs status";
        d2rq:column "d2r_bugsouterjoin.status";
        .
#
map:SeverityTable a d2rq:TranslationTable;
        d2rq:translation [ d2rq:databaseValue "critical"; d2rq:rdfValue debbugs:Critical; ];
        d2rq:translation [ d2rq:databaseValue "wishlist"; d2rq:rdfValue debbugs:Wishlist; ];
        d2rq:translation [ d2rq:databaseValue "minor"; d2rq:rdfValue debbugs:Minor; ];
        d2rq:translation [ d2rq:databaseValue "fixed"; d2rq:rdfValue debbugs:Fixed; ];
        d2rq:translation [ d2rq:databaseValue "grave"; d2rq:rdfValue debbugs:Grave; ];
        d2rq:translation [ d2rq:databaseValue "normal"; d2rq:rdfValue debbugs:Normal; ];
        d2rq:translation [ d2rq:databaseValue "important"; d2rq:rdfValue debbugs:Important; ];
        d2rq:translation [ d2rq:databaseValue "serious"; d2rq:rdfValue debbugs:Serious; ].

map:debbug_severity a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_severity;
        d2rq:uriColumn "d2r_bugsouterjoin.severity";
#	d2rq:propertyDefinitionLabel "bugs severity";
#	d2rq:uriPattern "debbugs:@@d2r_bugsouterjoin.severity@@";
        d2rq:translateWith map:SeverityTable
        .

# for those who have submitters known by carnivore
map:debbug_submitcar a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property debbugs:hasSubmitter;
        d2rq:propertyDefinitionLabel "bugs submitter known by carnivore";
        d2rq:uriPattern "foafcarnivore/@@d2r_bugsouterjoin.carnivore_id@@";
        d2rq:condition "d2r_bugsouterjoin.carnivore_id IS NOT NULL"
        .

map:debbug_submitter a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property debbugs:hasSubmitter;
        d2rq:propertyDefinitionLabel "bugs submitter";
        d2rq:uriPattern "foafdebbug/@@d2r_bugsouterjoin.submitter|urlencode@@";
        d2rq:condition "d2r_bugsouterjoin.carnivore_id IS NULL"
        .

map:debbug_owner a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_owner;
        d2rq:propertyDefinitionLabel "bugs owner";
        d2rq:column "d2r_bugsouterjoin.owner";
        .
map:debbug_title a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property debbugs:summary;
        d2rq:propertyDefinitionLabel "bugs title";
        d2rq:column "d2r_bugsouterjoin.title";
        .
map:debbug_last_modified a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_last_modified;
        d2rq:propertyDefinitionLabel "bugs last_modified";
        d2rq:column "d2r_bugsouterjoin.last_modified";
        d2rq:datatype xsd:dateTime;
        .
map:debbug_affects_stable a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_affects_stable;
        d2rq:propertyDefinitionLabel "bugs affects_stable";
        d2rq:column "d2r_bugsouterjoin.affects_stable";
        d2rq:datatype xsd:boolean;
        .
map:debbug_affects_testing a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_affects_testing;
        d2rq:propertyDefinitionLabel "bugs affects_testing";
        d2rq:column "d2r_bugsouterjoin.affects_testing";
        d2rq:datatype xsd:boolean;
        .
map:debbug_affects_unstable a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_affects_unstable;
        d2rq:propertyDefinitionLabel "bugs affects_unstable";
        d2rq:column "d2r_bugsouterjoin.affects_unstable";
        d2rq:datatype xsd:boolean;
        .
map:debbug_affects_experimental a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_affects_experimental;
        d2rq:propertyDefinitionLabel "bugs affects_experimental";
        d2rq:column "d2r_bugsouterjoin.affects_experimental";
        d2rq:datatype xsd:boolean;
        .
map:debbug_forwarded a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_forwarded;
        d2rq:propertyDefinitionLabel "bugs forwarded";
        d2rq:column "d2r_bugsouterjoin.forwarded";
        .
map:debbug_done a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:debbug;
        d2rq:property vocab:bugs_done;
        d2rq:propertyDefinitionLabel "bugs done";
        d2rq:column "d2r_bugsouterjoin.done";
        .



# View d2r_t_bugsubmitters (bug submitters with email addresses exploded)
map:foafdebbug a d2rq:ClassMap;
        d2rq:dataStorage map:database;
        d2rq:uriPattern "foafdebbug/@@d2r_t_bugsubmitters.submitter|urlencode@@";
#	d2rq:class vocab:bugs;
        d2rq:class foaf:Person;
        d2rq:classDefinitionLabel "FOAF profile of a UDD bug submitter";
        .
map:foafdebbug_submitter_phrase a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:foafdebbug;
        d2rq:property foaf:name;
        d2rq:propertyDefinitionLabel "bug submitter name";
        d2rq:column "d2r_t_bugsubmitters.email_phrase";
        .
map:debbug_submitter_address a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:foafdebbug;
        d2rq:property foaf:mbox;
        d2rq:propertyDefinitionLabel "bug submitter email";
#	d2rq:column "d2r_bugsouterjoin.email_address";
        d2rq:uriPattern "mailto:@@d2r_t_bugsubmitters.email_address@@";
        .
map:debbug_submitter_addressSHA1 a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:foafdebbug;
    d2rq:property foaf:mbox_sha1sum;
    d2rq:column "d2r_t_bugsubmitters.sha1mailto";
    .

# Table d2r_t_bugsubmitters
map:package a d2rq:ClassMap;
        d2rq:dataStorage map:database;
        d2rq:uriPattern "package/@@d2r_package.package@@";
#	d2rq:class vocab:bugs;
        d2rq:class debbugs:Package;
        d2rq:classDefinitionLabel "A Debian package";
        .
map:package__label a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:package;
        d2rq:property rdfs:label;
        d2rq:pattern "Debian package @@d2r_package.package@@";
        .

# View d2r_carnivore
map:carnivore a d2rq:ClassMap;
        d2rq:dataStorage map:database;
        d2rq:uriPattern "foafcarnivore/@@d2r_carnivore.id@@";
#	d2rq:class vocab:bugs;
        d2rq:class foaf:Person;
        d2rq:classDefinitionLabel "FOAF profile of a Debian contributor";
        .
map:carnivore_name a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:carnivore;
        d2rq:property foaf:name;
        d2rq:propertyDefinitionLabel "name";
        d2rq:column "d2r_carnivore.name";
        .
map:carnivore_address a d2rq:PropertyBridge;
        d2rq:belongsToClassMap map:carnivore;
        d2rq:property foaf:mbox;
        d2rq:propertyDefinitionLabel "email";
        d2rq:uriPattern "mailto:@@d2r_carnivore.email@@";
        .
map:carnivore_addressSHA1 a d2rq:PropertyBridge;
    d2rq:belongsToClassMap map:carnivore;
    d2rq:property foaf:mbox_sha1sum;
    d2rq:column "d2r_carnivore.sha1mailto";
    .