Books.r2rml.ttl

PREFIX rr: <http://www.w3.org/ns/r2rml#>
PREFIX bibo: <http://purl.org/ontology/bibo/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX hydra: <http://www.w3.org/ns/hydra/core#>
PREFIX opus: <http://lsdis.cs.uga.edu/projects/semdis/opus#>
PREFIX schema: <http://schema.org/>
PREFIX wba: <https://wikibus.org/api#>
PREFIX wbo: <https://wikibus.org/ontology#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

<#Book>
	rr:logicalTable [ rr:sqlQuery """select
	    Id,
	    Pages,
	    Year,
	    IIF(rtrim(Notes) = '', NULL, Notes) as Notes,
	    BookTitle,
	    BookISBN,
	    BookAuthor,
	    rtrim([User]) as [User],
		DateCreated,
	    DateUpdated,
	    IIF(rtrim(value) = '', NULL, value) as Language,
	    IIF(Image is NULL, NULL, Id) as LegacyImage
	from Sources.Source
	         CROSS APPLY STRING_SPLIT(Languages, ';')
	where SourceType = 'book'""" ];
	
	rr:subjectMap [
		rr:template "book/{Id}" ;
		rr:graphMap [ rr:template "book/{Id}" ; ] ;
		rr:class wbo:Source ;
		rr:class wbo:Book ;
		rr:class schema:Book ;
		rr:class bibo:Book ;
		rr:class hydra:Resource ;
	];
	
	rr:predicateObjectMap [
		rr:predicate bibo:pages ;
		rr:objectMap [
			rr:column "Pages" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate opus:year ;
		rr:objectMap [
			rr:column "Year" ;
			rr:datatype xsd:gYear ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate dcterms:description ;
		rr:objectMap [
			rr:column "Notes" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate dcterms:title ;
		rr:objectMap [
			rr:column "BookTitle" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate schema:isbn ;
		rr:objectMap [
			rr:column "BookISBN" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate dcterms:language ;
		rr:objectMap [
			rr:template "http://lexvo.org/id/iso639-1/{Language}" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate schema:image ;
		rr:objectMap [
			rr:template "book/{LegacyImage}/image" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate schema:primaryImageOfPage ;
		rr:objectMap [
			rr:template "book/{LegacyImage}/image" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate schema:author ;
		rr:objectMap [
			rr:template "book-{Id}-author" ;
			rr:termType rr:BlankNode ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate dcterms:created ;
		rr:objectMap [
			rr:column "DateCreated" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate dcterms:modified ;
		rr:objectMap [
			rr:column "DateUpdated" ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate wba:images ;
		rr:objectMap [
			rr:template "source/{Id}/images" ;
		];
	]
.
<#BookOwners>
	rr:logicalTable [ rr:sqlQuery """select
	    Id,
	    Pages,
	    Year,
	    IIF(rtrim(Notes) = '', NULL, Notes) as Notes,
	    BookTitle,
	    BookISBN,
	    BookAuthor,
	    rtrim([User]) as [User],
		DateCreated,
	    DateUpdated,
	    IIF(rtrim(value) = '', NULL, value) as Language,
	    IIF(Image is NULL, NULL, Id) as LegacyImage
	from Sources.Source
	         CROSS APPLY STRING_SPLIT(Languages, ';')
	where SourceType = 'book'""" ];
	
	rr:subjectMap [
		rr:template "https://users.wikibus.org/user/{User}" ;
		rr:graphMap [ rr:template "https://users.wikibus.org/user/{User}" ; ] ;
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:owns ;
		rr:objectMap [
			rr:template "book/{Id}" ;
		];
	]
.
<#BookAuthors>
	rr:logicalTable [ rr:sqlQuery """select
	    Id,
	    Pages,
	    Year,
	    IIF(rtrim(Notes) = '', NULL, Notes) as Notes,
	    BookTitle,
	    BookISBN,
	    BookAuthor,
	    rtrim([User]) as [User],
		DateCreated,
	    DateUpdated,
	    IIF(rtrim(value) = '', NULL, value) as Language,
	    IIF(Image is NULL, NULL, Id) as LegacyImage
	from Sources.Source
	         CROSS APPLY STRING_SPLIT(Languages, ';')
	where SourceType = 'book'""" ];
	
	rr:subjectMap [
		rr:template "book-{Id}-author" ;
		rr:termType rr:BlankNode ;
		rr:graphMap [ rr:template "book/{Id}" ; ] ;
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:name ;
		rr:objectMap [
			rr:column "BookAuthor" ;
		];
	]
.
<#BookLegacyImage>
	rr:logicalTable [ rr:sqlQuery """select
	    Id,
	    Pages,
	    Year,
	    IIF(rtrim(Notes) = '', NULL, Notes) as Notes,
	    BookTitle,
	    BookISBN,
	    BookAuthor,
	    rtrim([User]) as [User],
		DateCreated,
	    DateUpdated,
	    IIF(rtrim(value) = '', NULL, value) as Language,
	    IIF(Image is NULL, NULL, Id) as LegacyImage
	from Sources.Source
	         CROSS APPLY STRING_SPLIT(Languages, ';')
	where SourceType = 'book'""" ];
	
	rr:subjectMap [
		rr:template "book/{LegacyImage}/image" ;
		rr:class schema:ImageObject ;
		rr:graphMap [ rr:template "book/{Id}" ; ] ;
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:contentUrl ;
		rr:objectMap [
			rr:template "https://wikibus-sources.herokuapp.com/book/{LegacyImage}/image" ;
			rr:termType rr:Literal ;
		];
	];
	rr:predicateObjectMap [
		rr:predicate schema:thumbnail ;
		rr:objectMap [
			rr:template "book/{LegacyImage}/image/small" ;
		];
	]
.
<#BookImageThumbnail>
	rr:logicalTable [ rr:sqlQuery """select
	    Id,
	    Pages,
	    Year,
	    IIF(rtrim(Notes) = '', NULL, Notes) as Notes,
	    BookTitle,
	    BookISBN,
	    BookAuthor,
	    rtrim([User]) as [User],
		DateCreated,
	    DateUpdated,
	    IIF(rtrim(value) = '', NULL, value) as Language,
	    IIF(Image is NULL, NULL, Id) as LegacyImage
	from Sources.Source
	         CROSS APPLY STRING_SPLIT(Languages, ';')
	where SourceType = 'book'""" ];
	
	rr:subjectMap [
		rr:template "book/{LegacyImage}/image/small" ;
		rr:class schema:ImageObject ;
		rr:graphMap [ rr:template "book/{Id}" ; ] ;
	];
	
	rr:predicateObjectMap [
		rr:predicate schema:contentUrl ;
		rr:objectMap [
			rr:template "https://wikibus-sources.herokuapp.com/book/{LegacyImage}/image/small" ;
			rr:termType rr:Literal ;
		];
	]
.