@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 helios_bt: <http://picoforge.int-evry.fr/projects/svn/helios_wp3/2009/09/helios_bt.owl#> .
@prefix bom: <http://www.ifi.uzh.ch/ddis/evoont/2008/11/bom#> .
@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#> .
@prefix sioc: <http://rdfs.org/sioc/ns#> .
@prefix dc: <http://purl.org/dc/elements/1.1/> .
# @prefix map: <file:/var/www/d2r/mapping.n3#> .
# @prefix db: <> .
# @prefix vocab: <http://erty.int-evry.fr: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 owl: <http://www.w3.org/2002/07/owl#> .
# @prefix foaf: <http://xmlns.com/foaf/0.1/> .
@prefix doap: <http://usefulinc.com/ns/doap#> .
# @prefix sioc: <http://rdfs.org/sioc/ns#> .
# @prefix sioctypes: <http://rdfs.org/sioc/types#> .
# @prefix dc: <http://purl.org/dc/elements/1.1/> .
# @prefix bom: <http://www.ifi.uzh.ch/ddis/evoont/2008/11/bom#> .
# @prefix hel: <http://picoforge.int-evry.fr/projects/svn/helios_wp3/helios_bt.owl#> .
# @prefix wf: <http://www.w3.org/2005/01/wf/flow#> .
# @prefix d2r: <http://sites.wiwiss.fu-berlin.de/suhl/bizer/d2r-server/config.rdf#> .
<> 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:debbugs a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "debbugs/@@bugs.id@@";
d2rq:class bom:Issue;
d2rq:classDefinitionLabel "UDD bugs";
.
map:debbugs_label a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property rdfs:label;
d2rq:pattern "Debian bug #@@bugs.id@@";
.
map:debbugs_bugurl a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property bom:bugURL;
d2rq:propertyDefinitionLabel "bug URL";
d2rq:uriPattern "http://bugs.debian.org/@@bugs.id@@";
.
map:debbugs_sameasurl a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property owl:sameAs;
d2rq:uriPattern "http://bugs.debian.org/@@bugs.id@@";
.
map:debbugs_id a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property bom:number;
d2rq:column "bugs.id";
d2rq:datatype xsd:int;
.
map:debbugs_title a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property dc:title;
d2rq:propertyDefinitionLabel "bugs title";
d2rq:column "bugs.title";
.
map:debbugs_bpackage a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property bom:isIssueOf;
d2rq:propertyDefinitionLabel "binary package of bug";
# # # d2rq:column "d2r_bugsouterjoin.package";
# # d2rq:uriPattern "package/@@d2r_bugsouterjoin.package@@";
d2rq:uriPattern "bpackage/@@bugs.package@@";
.
map:debbugs_spackage a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property bom:isIssueOf;
# d2rq:propertyDefinitionLabel "bugs source";
d2rq:uriPattern "spackage/@@bugs.source@@";
.
# map:debbugs_arrival a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_arrival;
# d2rq:propertyDefinitionLabel "bugs arrival";
# d2rq:column "d2r_bugsouterjoin.arrival";
# d2rq:datatype xsd:dateTime;
# .
# map:debbugs_status a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# 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:debbugs_severity a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_severity;
# d2rq:uriColumn "d2r_bugsouterjoin.severity";
# # d2rq:propertyDefinitionLabel "bugs severity";
# # d2rq:uriPattern "debbugs:@@d2r_bugsouterjoin.severity@@";
# d2rq:translateWith map:SeverityTable
# .
map:bugsubm a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "debbugs/@@d2r_v_bug_submitters.id@@";
d2rq:class bom:Issue;
.
map:bugsubm_submitter a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:bugsubm;
d2rq:property bom:hasReporter;
d2rq:uriPattern "bugsubmitters/@@d2r_v_bug_submitters.sha1mailto@@";
.
map:siocsubmitters a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "bugsubmitters/@@d2r_v_bug_submitters.sha1mailto@@";
d2rq:class sioc:User;
.
map:siocsubmitters_name a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:siocsubmitters;
d2rq:property sioc:name;
d2rq:column "d2r_v_bug_submitters.submitter_name";
.
map:siocsubmitters_foaf a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:siocsubmitters;
d2rq:property sioc:account_of;
d2rq:uriPattern "foafcarnivore/@@d2r_v_bug_submitters.mailtosha1@@";
.
# # for those who have submitters known by carnivore
# map:debbugs_submitcar a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# 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:debbugs_submitter a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property debbugs:hasSubmitter;
# d2rq:propertyDefinitionLabel "bugs submitter";
# # d2rq:uriPattern "foafdebbugs/@@d2r_bugsouterjoin.sha1mail@@";
# d2rq:uriPattern "foafcarnivore/@@bugs.submitter_email@@";
# # d2rq:condition "d2r_bugsouterjoin.carnivore_id IS NULL"
# .
# map:debbugs_owner a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_owner;
# d2rq:propertyDefinitionLabel "bugs owner";
# d2rq:column "d2r_bugsouterjoin.owner";
# .
# map:debbugs_last_modified a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_last_modified;
# d2rq:propertyDefinitionLabel "bugs last_modified";
# d2rq:column "d2r_bugsouterjoin.last_modified";
# d2rq:datatype xsd:dateTime;
# .
# map:debbugs_affects_stable a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_affects_stable;
# d2rq:propertyDefinitionLabel "bugs affects_stable";
# d2rq:column "d2r_bugsouterjoin.affects_stable";
# d2rq:datatype xsd:boolean;
# .
# map:debbugs_affects_testing a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_affects_testing;
# d2rq:propertyDefinitionLabel "bugs affects_testing";
# d2rq:column "d2r_bugsouterjoin.affects_testing";
# d2rq:datatype xsd:boolean;
# .
# map:debbugs_affects_unstable a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_affects_unstable;
# d2rq:propertyDefinitionLabel "bugs affects_unstable";
# d2rq:column "d2r_bugsouterjoin.affects_unstable";
# d2rq:datatype xsd:boolean;
# .
# map:debbugs_affects_experimental a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# d2rq:property vocab:bugs_affects_experimental;
# d2rq:propertyDefinitionLabel "bugs affects_experimental";
# d2rq:column "d2r_bugsouterjoin.affects_experimental";
# d2rq:datatype xsd:boolean;
# .
map:debbugs_forwarded a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:debbugs;
d2rq:property helios_bt:reportedAlsoIn;
d2rq:propertyDefinitionLabel "bugs forwarded";
d2rq:uriColumn "bugs.forwarded";
d2rq:condition "bugs.forwarded <> ''";
.
# map:debbugs_done a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:debbugs;
# 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:foafdebbugs a d2rq:ClassMap;
# d2rq:dataStorage map:database;
# d2rq:uriPattern "foafdebbugs/@@d2r_t_bugsubmitters.sha1mail@@";
# # d2rq:class vocab:bugs;
# d2rq:class foaf:Person;
# d2rq:classDefinitionLabel "FOAF profile of a UDD bug submitter";
# .
# map:foafdebbugs_submitter_phrase a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:foafdebbugs;
# d2rq:property foaf:name;
# d2rq:propertyDefinitionLabel "bug submitter name";
# d2rq:column "d2r_t_bugsubmitters.email_phrase";
# .
# map:debbugs_submitter_address a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:foafdebbugs;
# d2rq:property foaf:mbox;
# d2rq:propertyDefinitionLabel "bug submitter email";
# # d2rq:column "d2r_bugsouterjoin.email_address";
# d2rq:uriPattern "mailto:@@d2r_t_bugsubmitters.email_address@@";
# .
# map:debbugs_submitter_addressSHA1 a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:foafdebbugs;
# d2rq:property foaf:mbox_sha1sum;
# d2rq:column "d2r_t_bugsubmitters.sha1mailto";
# .
# packages of bugs
map:spackage a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "spackage/@@d2r_spackage.source@@";
d2rq:class helios_bt:DistributionSourcePackage;
d2rq:classDefinitionLabel "A Debian source package";
.
map:spackage_label a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:spackage;
d2rq:property rdfs:label;
d2rq:pattern "Debian source package @@d2r_spackage.source@@";
.
map:spackage_name a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:spackage;
d2rq:property doap:name;
d2rq:column "d2r_spackage.source";
.
map:spackage_doap a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:spackage;
d2rq:property rdfs:seeAlso;
d2rq:uriPattern "doap/@@d2r_spackage.source|urlify@@";
.
map:bpackage a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "bpackage/@@d2r_bpackage.package@@";
d2rq:class helios_bt:DistributionBinaryPackage;
d2rq:classDefinitionLabel "A Debian binary package";
.
map:bpackage_label a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:bpackage;
d2rq:property rdfs:label;
d2rq:pattern "Debian binary package @@d2r_bpackage.package@@";
.
map:bpackage_source a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:bpackage;
d2rq:property helios_bt:isBinaryOf;
d2rq:uriPattern "spackage/@@d2r_bpackage.source@@";
.
# # View d2r_v_carnivore
map:carnivore a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "foafcarnivore/@@d2r_v_carnivore.mailtosha1@@";
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@@";
.
#-----------------------
# # Table bugs
map:issue a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "issue/@@mdvbz_bugs.bug_id@@";
d2rq:class bom:Issue;
d2rq:classDefinitionLabel "issue";
.
map:mdvbz_bugs__label a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property rdfs:label;
d2rq:pattern "Bug #@@mdvbz_bugs.bug_id@@ in Mandriva's bugzilla";
.
map:issue_id a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property bom:number;
d2rq:propertyDefinitionLabel "issue id";
d2rq:column "mdvbz_bugs.bug_id";
d2rq:datatype xsd:int;
.
map:issue_bugurl a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property bom:bugURL;
d2rq:uriPattern "http://qa.mandriva.com/show_bug.cgi?id=@@mdvbz_bugs.bug_id@@";
.
map:issue_sameas a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property owl:sameAs;
d2rq:uriPattern "http://qa.mandriva.com/show_bug.cgi?id=@@mdvbz_bugs.bug_id@@";
.
map:issue_component_id a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property bom:isIssueOf;
# d2rq:uriPattern "component/@@mdvbz_bugs.component_id@@";
d2rq:uriPattern "package/@@mdvbz_rpmpkg.package|urlify@@";
d2rq:join "mdvbz_bugs.cf_rpmpkg = mdvbz_rpmpkg.fullname";
.
map:issue_short_desc a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property dc:title;
d2rq:propertyDefinitionLabel "issue title";
d2rq:column "mdvbz_bugs.short_desc";
.
map:issue_cf_rpmpkg a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property helios_bt:foundInVersion;
d2rq:uriPattern "package/@@mdvbz_rpmpkg.package|urlify@@/@@mdvbz_rpmpkg.ver|urlify@@";
d2rq:join "mdvbz_bugs.cf_rpmpkg = mdvbz_rpmpkg.fullname";
.
map:issue_assigned_to a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property bom:hasAssignee;
d2rq:uriPattern "user/@@mdvbz_bugs.assigned_to@@";
.
# map:issue_severity a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:hasSeverity;
# d2rq:propertyDefinitionLabel "issue has severity";
# d2rq:column "mdvbz_bugs.bug_severity";
# .
# map:issue_status a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:hasState;
# d2rq:propertyDefinitionLabel "issue has status";
# d2rq:column "mdvbz_bugs.bug_status";
# .
# map:issue_creation_ts a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:dateOpened;
# d2rq:propertyDefinitionLabel "issue date opened";
# d2rq:column "mdvbz_bugs.creation_ts";
# d2rq:datatype xsd:dateTime;
# .
# map:issue_priority a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:hasPriority;
# d2rq:propertyDefinitionLabel "issue has priority";
# d2rq:column "mdvbz_bugs.priority";
# .
# map:issue_computersystem a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:hasComputerSystem;
# d2rq:propertyDefinitionLabel "issue has computer system";
# d2rq:sqlExpression "10 * op_sys.id + rep_platform.id";
# d2rq:join "mdvbz_bugs.op_sys = op_sys.value";
# d2rq:join "mdvbz_bugs.rep_platform = rep_platform.value";
# .
map:issue_reporter a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:issue;
d2rq:property bom:hasReporter;
d2rq:uriPattern "user/@@mdvbz_bugs.reporter@@";
.
# map:issue_resolution a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:hasResolution;
# d2rq:propertyDefinitionLabel "issue has resolution";
# d2rq:column "mdvbz_bugs.resolution";
# .
# map:issue_milestone a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:issue;
# d2rq:property bom:hasMilestone;
# d2rq:propertyDefinitionLabel "issue has milestone";
# d2rq:column "mdvbz_bugs.target_milestone";
# .
# # Table mdvbz_rpmpkg
map:package a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "package/@@mdvbz_rpmpkg.package|urlify@@";
d2rq:class helios_bt:SoftwarePackage;
d2rq:classDefinitionLabel "package";
.
map:package_doap a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:package;
d2rq:property rdfs:seeAlso;
d2rq:uriPattern "doap/@@mdvbz_rpmpkg.package|urlify@@";
.
map:package_version a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:package;
d2rq:property helios_bt:hasVersion;
d2rq:uriPattern "package/@@mdvbz_rpmpkg.package|urlify@@/@@mdvbz_rpmpkg.ver|urlify@@";
.
map:package_component a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:package;
d2rq:property helios_bt:isPackageOf;
d2rq:join "mdvbz_rpmpkg.fullname = mdvbz_bugs.cf_rpmpkg";
d2rq:uriPattern "component/@@mdvbz_bugs.component_id@@";
.
# Table components
# map:component a d2rq:ClassMap;
# d2rq:dataStorage map:database;
# d2rq:uriPattern "component/@@components.id@@";
# d2rq:class bom:Component;
# d2rq:classDefinitionLabel "component";
# .
# map:component_name a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:component;
# d2rq:property bom:title;
# d2rq:propertyDefinitionLabel "component title";
# d2rq:column "components.name";
# .
# map:component_product_id a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:component;
# d2rq:property bom:isInProduct;
# d2rq:uriPattern "product/@@components.product_id@@";
# .
# map:component_description a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:component;
# d2rq:property rdfs:label;
# d2rq:propertyDefinitionLabel "component label";
# d2rq:column "components.description";
# .
# map:component_initialowner a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:component;
# d2rq:property sioc:User;
# d2rq:refersToClassMap map:person;
# d2rq:join "components.initialowner = mdvbz_profiles.userid";
# .
# # Blank node for ComputerSystem
# #map:computersystem a d2rq:ClassMap ;
# # d2rq:dataStorage map:database;
# # d2rq:bNodeIdColumns "op_sys.id,rep_platform.id" ;
# # d2rq:class bom:ComputerSystem ;
# # d2rq:classDefinitionLabel "Computer system";
# # .
# #map:computersystem_os a d2rq:PropertyBridge;
# # d2rq:belongsToClassMap map:computersystem;
# # d2rq:property bom:OS;
# # d2rq:column "op_sys.value";
# # d2rq:propertyDefinitionLabel "Operating system";
# # .
# #map:computersystem_rep_platform a d2rq:PropertyBridge;
# # d2rq:belongsToClassMap map:computersystem;
# # d2rq:property bom:Platform;
# # d2rq:column "rep_platform.value";
# # d2rq:propertyDefinitionLabel "Platform";
# # .
# # Table longdescs
# map:comment a d2rq:ClassMap;
# d2rq:dataStorage map:database;
# d2rq:uriPattern "comment/@@longdescs.comment_id@@";
# d2rq:class bom:Comment;
# d2rq:classDefinitionLabel "comment";
# .
# map:comment__label a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:comment;
# d2rq:property rdfs:label;
# d2rq:pattern "comment #@@longdescs.comment_id@@";
# .
# map:comment_bug_id a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:comment;
# d2rq:property bom:isCommentOf;
# d2rq:uriPattern "issue/@@longdescs.bug_id@@";
# .
# map:comment_who a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:comment;
# d2rq:property bom:hasCreator;
# d2rq:uriPattern "user/@@longdescs.who@@";
# .
# map:comment_thetext a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:comment;
# d2rq:property bom:Comment;
# d2rq:propertyDefinitionLabel "comment thetext";
# d2rq:column "longdescs.thetext";
# .
# # Table milestones
# map:milestone a d2rq:ClassMap;
# d2rq:dataStorage map:database;
# d2rq:uriPattern "milestone/@@milestones.id@@";
# d2rq:class bom:Milestone;
# d2rq:classDefinitionLabel "milestone";
# .
# map:milestone__label a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:milestone;
# d2rq:property rdfs:label;
# d2rq:pattern "milestone #@@milestones.id@@";
# .
# map:milestone_value a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:milestone;
# d2rq:property bom:Milestone;
# d2rq:column "milestones.value";
# d2rq:propertyDefinitionLabel "Milestone";
# .
# map:milestone_product_id a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:milestone;
# d2rq:property bom:product;
# d2rq:uriPattern "product/@@milestones.product_id@@";
# .
# # Table products
# map:product a d2rq:ClassMap;
# d2rq:dataStorage map:database;
# d2rq:uriPattern "product/@@products.id@@";
# d2rq:class bom:Product;
# d2rq:classDefinitionLabel "products";
# .
# map:product__label a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:product;
# d2rq:property rdfs:label;
# d2rq:pattern "product #@@products.id@@";
# .
# map:product_name a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:product;
# d2rq:property bom:name;
# d2rq:propertyDefinitionLabel "product name";
# d2rq:column "products.name";
# .
# map:product_description a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:product;
# d2rq:property rdfs:label;
# d2rq:propertyDefinitionLabel "product label";
# d2rq:column "products.description";
# .
# # Table mdvbz_profiles
map:person a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "person/@@mdvbz_profiles.userid@@";
d2rq:class foaf:Person;
d2rq:classDefinitionLabel "person";
.
map:person__label a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:person;
d2rq:property rdfs:label;
d2rq:pattern "person #@@mdvbz_profiles.userid@@";
.
map:person_userid a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:person;
d2rq:property foaf:holdsAccount;
d2rq:uriPattern "user/@@mdvbz_profiles.userid@@";
.
map:person_realname a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:person;
d2rq:property foaf:name;
d2rq:propertyDefinitionLabel "person realname";
d2rq:column "mdvbz_profiles.realname";
.
# map:person_mailto a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:person;
# d2rq:property foaf:mbox_sha1sum;
# d2rq:propertyDefinitionLabel "person mbox_sha1sum";
# d2rq:sqlExpression "SHA(CONCAT('mailto:',mdvbz_profiles.login_name))";
# .
# # Table users (mdvbz_profiles)
map:user a d2rq:ClassMap;
d2rq:dataStorage map:database;
d2rq:uriPattern "user/@@mdvbz_profiles.userid@@";
d2rq:class sioc:User;
d2rq:classDefinitionLabel "user";
.
map:user__label a d2rq:PropertyBridge;
d2rq:belongsToClassMap map:user;
d2rq:property rdfs:label;
d2rq:pattern "user id #@@mdvbz_profiles.userid@@";
.
# map:user_userid a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:user;
# d2rq:property rdf:sameAs;
# d2rq:uriPattern "person/@@mdvbz_profiles.userid@@";
# .
# map:user_mailto a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:user;
# d2rq:property sioc:email_sha1;
# d2rq:propertyDefinitionLabel "user email_sha1";
# d2rq:sqlExpression "SHA(CONCAT('mailto:',mdvbz_profiles.login_name))";
# .
#map:user_mailto a d2rq:PropertyBridge;
# d2rq:belongsToClassMap map:user;
# d2rq:property sioc:email;
## d2rq:propertyDefinitionLabel "user email_sha1";
## d2rq:sqlExpression "SHA(CONCAT('mailto:',mdvbz_profiles.login_name))";
# d2rq:uriPattern "mailto:@@mdvbz_profiles.login_name@@";
# .
|
