@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#> . @prefix owl: <http://www.w3.org/2002/07/owl#> . <> a d2r:Server; rdfs:label "D2R Server"; d2r:baseURI <http://kilauea.int-evry.fr:8180/d2r-server/>; # 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:jdbcDSN "jdbc:postgresql://localhost/UDD?user=udd&password=coin123"; d2rq:username "udd"; d2rq:password "coin123"; 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:uriPattern "debbug/@@bugs.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@@"; # d2rq:pattern "Debian bug #@@bugs.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@@"; # d2rq:uriPattern "http://bugs.debian.org/@@bugs.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:column "bugs.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@@"; # d2rq:uriPattern "package/@@bugs.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.sha1mail@@"; # d2rq:uriPattern "foafcarnivore/@@bugs.submitter_email@@"; # # 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 "bugs.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.sha1mail@@"; # # 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_v_carnivore map:carnivore a d2rq:ClassMap; d2rq:dataStorage map:database; # d2rq:uriPattern "foafcarnivore/@@d2r_v_carnivore.id@@"; d2rq:uriPattern "foafcarnivore/@@d2r_v_carnivore.mailtosha1@@"; # # 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_v_carnivore.name"; . map:carnivore_address a d2rq:PropertyBridge; d2rq:belongsToClassMap map:carnivore; d2rq:property foaf:mbox; d2rq:propertyDefinitionLabel "email"; d2rq:uriPattern "mailto:@@d2r_v_carnivore.email@@"; . map:carnivore_addressSHA1 a d2rq:PropertyBridge; d2rq:belongsToClassMap map:carnivore; d2rq:property foaf:mbox_sha1sum; d2rq:column "d2r_v_carnivore.mailtosha1"; . map:carnivore_key a d2rq:PropertyBridge; d2rq:belongsToClassMap map:carnivore; d2rq:property owl:sameAs; d2rq:uriPattern "carnivorekey/@@d2r_v_carnivore.key@@"; . |