prelib.obda

[PrefixDeclaration]
:		http://mshb.huma-num.fr/prelib/
owl:		http://www.w3.org/2002/07/owl#
rdf:		http://www.w3.org/1999/02/22-rdf-syntax-ns#
xml:		http://www.w3.org/XML/1998/namespace#
xsd:		http://www.w3.org/2001/XMLSchema#
ecrm:		http://erlangen-crm.org/current/
gndo:		http://d-nb.info/standards/elementset/gnd#
rdfs:		http://www.w3.org/2000/01/rdf-schema#
skos:		http://www.w3.org/2004/02/skos/core#
prelib:		http://mshb.huma-num.fr/prelib/
efrbroo:		http://erlangen-crm.org/efrbroo/
wikidata:	http://www.wikidata.org/entity/

[SourceDeclaration]
sourceUri	*****
connectionUrl	*****
username	*****
password	*****
driverClass	com.mysql.jdbc.Driver

[MappingDeclaration] @collection [[
mappingId	MAPID-9413a17c447e4ce8939c32909036f2dc
target		prelib:oeuvre/{id}/titre a ecrm:E35_Title ; rdfs:label {titre}^^xsd:string . prelib:oeuvre/{id} a efrbroo:F22_Self-Contained_Expression ; ecrm:P102_has_title prelib:oeuvre/{id}/titre ; rdfs:label {titre}^^xsd:string . 
source		SELECT id, titre FROM prelib_oeuvre

mappingId	MAPID-2d837ca05a984473807576e51972616a
target		prelib:oeuvre/{oeuvre_id} a ecrm:E33_Linguistic_Object ; ecrm:P72_has_language prelib:langue/{langue_id} . 
source		SELECT oeuvre_id, langue_id FROM prelib_oeuvrelangue WHERE 1

mappingId	MAPID-b34f110d02ab463d9387828477236d8d
target		prelib:langue/{id} a ecrm:E56_Language ; rdfs:label {nom}@fr . 
source		SELECT id, nom, code_iso_639_3 FROM prelib_langue WHERE nom != '?'

mappingId	MAPID-6da6fa55e4ec4655a5d3f8ef2edb2c40
target		prelib:oeuvre/{oeuvre_inspiree_id} ecrm:P73i_is_translation_of prelib:oeuvre/{oeuvre_originale_id} . prelib:oeuvre/{oeuvre_originale_id} ecrm:P73_has_translation prelib:oeuvre/{oeuvre_inspiree_id} . 
source		SELECT oeuvre_originale_id, oeuvre_inspiree_id FROM prelib_oeuvreoeuvre WHERE type_relation_oeuvres_id = 1

mappingId	MAPID-d431eac7031c460481eb0294bb69014a
target		prelib:manuscrit/{id}/titre a ecrm:E35_Title ; rdfs:label {titre}^^xsd:string . prelib:manuscrit/{id} a efrbroo:F4_Manifestation_Singleton ; rdfs:label {titre}^^xsd:string ; ecrm:P102_has_title prelib:manuscrit/{id}/titre . 
source		SELECT id, titre FROM prelib_manuscrit WHERE 1.

mappingId	MAPID-05d4ab2b0936453482867c7b89d5bb8d
target		prelib:edition/{id}/publication_expression a efrbroo:F24_Publication_Expression ; efrbroo:R24i_was_created_through prelib:edition/{id}/publication_event . prelib:edition/{id}/titre a ecrm:E35_Title ; rdfs:label {titre}^^xsd:string . prelib:edition/{id} a efrbroo:F3_Manifestation_Product_Type ; rdfs:label {titre}^^xsd:string ; ecrm:P102_has_title prelib:edition/{id}/titre ; efrbroo:CLR6_should_carry prelib:edition/{id}/publication_expression . prelib:edition/{id}/publication_event/date a ecrm:E52_Time-Span ; ecrm:P82_at_some_time_within {annee_publication}^^xsd:gYear . prelib:edition/{id}/publication_event a efrbroo:F30_Publication_Event ; ecrm:P4_has_time-span prelib:edition/{id}/publication_event/date . 
source		SELECT id, titre, annee_publication FROM prelib_edition WHERE 1.

mappingId	MAPID-294a5b1ea9b44c129e768bdbe5ef8cae
target		prelib:edition/{edition_id}/publication_expression ecrm:P165_incorporates prelib:oeuvre/{oeuvre_id} . 
source		SELECT edition_id, oeuvre_id FROM prelib_oeuvreedition WHERE 1.

mappingId	MAPID-0d87c48debee462e8b8b84c1728483c7
target		prelib:personne/{id} a efrbroo:F10_Person ; rdfs:seeAlso wikidata:{wikidata} . 
source		SELECT id, wikidata FROM prelib_personne WHERE wikidata IS NOT NULL AND wikidata != ''

mappingId	MAPID-79ff84e995c14f07bd865f5e8f2670d2
target		prelib:personne/{id} gndo:dateOfBirth {annee_naissance}^^xsd:gYear . 
source		SELECT id, annee_naissance FROM prelib_personne WHERE annee_naissance IS NOT NULL AND annee_naissance != ''

mappingId	MAPID-79ff84e995c14f07bd865f5e8f2670d2(0)
target		prelib:personne/{id} gndo:dateOfDeath {annee_naissance}^^xsd:gYear . 
source		SELECT id, annee_deces FROM prelib_personne WHERE annee_deces IS NOT NULL AND annee_deces != ''
]]