Users.r2rml.ttl

PREFIX rr: <http://www.w3.org/ns/r2rml#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX vcard: <http://www.w3.org/2006/vcard/ns#>
PREFIX wbo: <https://schema.wikibus.org/>

<#User>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:sqlQuery """select rtrim([UserId]) as [UserId], DriveImportFolder from [Sources].[Users]""" ];
	
	rr:subjectMap [
		rr:template "user/{UserId}";
		rr:graphMap [
		  rr:template "user/{UserId}"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate rdf:type;
		rr:objectMap [
			rr:template "api/User"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate wbo:driveImportFolder;
		rr:objectMap [
			rr:column "DriveImportFolder"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate vcard:hasUID;
		rr:objectMap [
			rr:column "UserId"
		]
	].