Wishlist.r2rml.ttl

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

<#WishlistItem>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:sqlQuery """select 
				Id,
				rtrim([User]) as [User],
				SourceId,
				IIF(Done = '1', 'Complete', 'Incomplete') as Status 
			from Sources.Wishlist""" ];
	
	rr:subjectMap [
		rr:template "wishlist/{User}/{SourceId}";
		rr:graphMap [
		  rr:template "wishlist/{User}/{SourceId}"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate rdf:type;
		rr:objectMap [
			rr:template "api/WishlistItem"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate wbo:source;
		rr:objectMap [
			rr:template "brochure/{SourceId}"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:status;
		rr:objectMap [
			rr:template "https://schema.wikibus.org/wishlist-status/{Status}"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate acl:owner;
		rr:objectMap [
			rr:template "user/{User}"
		]
	].
	
<#WishlistUser>
	a rr:TriplesMap;
	
	rr:logicalTable [ rr:sqlQuery """select 
				Id,
				rtrim([User]) as [User],
				SourceId,
				IIF(Done = '1', 'Complete', 'Incomplete') as Status 
			from Sources.Wishlist""" ];
	
	rr:subjectMap [
		rr:template "user/{User}";
		rr:class vcard:Individual;
		rr:graphMap [
		  rr:template "user/{User}"
		]
	];
	
	rr:predicateObjectMap [
		rr:predicate vcard:hasUID;
		rr:objectMap [
			rr:column "User"
		]
	].