-
Notifications
You must be signed in to change notification settings - Fork 21
Examples
Nikolaos Konstantinou edited this page Jul 30, 2013
·
14 revisions
The following are examples of the capabilities the R2RML Parser tool offers.
-
Allow arbitrary SQL queries as logical views, using the rr:sqlQuery construct:
map:dc-creator rr:logicalTable <#dc-creator-view>; rr:subjectMap [ rr:template 'http://data.example.com/item/{"item_id"}'; rr:class dcterms:BibliographicResource; ]; rr:predicateObjectMap [ rr:predicate dcterms:creator; rr:objectMap [ rr:column '"text_value"' ]; ]. <#dc-creator-view> rr:sqlQuery """ SELECT i.item_id AS item_id, mv.text_value AS text_value FROM item AS i INNER JOIN metadatavalue AS mv ON i.item_id=mv.item_id INNER JOIN metadatafieldregistry AS mfr ON mfr.metadata_field_id=mv.metadata_field_id INNER JOIN metadataschemaregistry AS msr ON msr.metadata_schema_id=mfr.metadata_schema_id WHERE i.in_archive=TRUE AND mv.text_value IS NOT NULL AND msr.namespace='http://dublincore.org/documents/dcmi-terms/' AND mfr.element='creator' """.
-
Allow functions in the SQL queries, for instance string manipulation functions (such as the SQL function replace), which can be nested:
<#dc-language-view> rr:sqlQuery """ SELECT h.handle AS handle, replace(replace(replace(replace(replace(replace(mv.text_value,'Greek','ell'),'Spanish','spa'),'German','deu'),'Italian','ita'),'English','eng'),'French','fra') AS text_value FROM handle AS h, item AS i, metadatavalue AS mv, metadataschemaregistry AS msr, metadatafieldregistry AS mfr WHERE i.in_archive=TRUE AND h.resource_id=i.item_id AND h.resource_type_id=2 AND msr.metadata_schema_id=mfr.metadata_schema_id AND mfr.metadata_field_id=mv.metadata_field_id AND mv.text_value is not null AND i.item_id=mv.item_id AND msr.namespace='http://dublincore.org/documents/dcmi-terms/' AND mfr.element='language' AND mfr.qualifier IS NULL """.
-
Allow templates, using rr:template involving many table fields when generating URI's or Literals:
map:persons rr:logicalTable [ rr:tableName '"eperson"'; ]; rr:subjectMap [ rr:template 'http://data.example.org/repository/person/{"eperson_id"}'; rr:class foaf:Person; ]; rr:predicateObjectMap [ rr:predicate foaf:name; rr:objectMap [ rr:template '{"firstname"} {"lastname"}' ; rr:termType rr:Literal; ] ].