%META:TOPICPARENT{name="VirtRDFViews"}%

---+++RDF View for ODS Calendar

<strong>IMPORTANT!</strong> The following code is part of the ODS global VIEW regarding the Calendar part, it is not a separate VIEW and is strongly recommended NOT to be executed directly. Instead, you should use the code from [[VirtRDFViewODSGlobal][ODS RDF Views Deployment and Demo Scripts]].

<verbatim>
sparql prefix ods: <http://www.openlinksw.com/virtuoso/ods/>

	#Calendar
	create iri class ods:calendar_event "http://^{URIQADefaultHost}^/dataspace/%U/calendar/%U/%d"
		(in uname varchar not null, in inst_name varchar not null, in calendar_id integer not null)
		option (returns "http://^{URIQADefaultHost}^/dataspace/%U/calendar/%U/%d" ) .
	create iri class ods:calendar_event_text "http://^{URIQADefaultHost}^/dataspace/%U/calendar/%U/%d/text"
		(in uname varchar not null, in inst_name varchar not null, in calendar_id integer not null)
		option (returns "http://^{URIQADefaultHost}^/dataspace/%U/calendar/%U/%d/text" ) .
	create iri class ods:calendar_forum "http://^{URIQADefaultHost}^/dataspace/%U/calendar/%U"
		( in uname varchar not null, in forum_name varchar not null)
		option (returns  "http://^{URIQADefaultHost}^/dataspace/%U/calendar/%U") .

</verbatim>

<verbatim>
sparql
    prefix sioc: <http://rdfs.org/sioc/ns#>
    prefix sioct: <http://rdfs.org/sioc/types#>
    prefix atom: <http://atomowl.org/ontologies/atomrdf#>
    prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
    prefix foaf: <http://xmlns.com/foaf/0.1/>
    prefix dc: <http://purl.org/dc/elements/1.1/>
    prefix dct: <http://purl.org/dc/terms/>
    prefix skos: <http://www.w3.org/2004/02/skos/core#>
    prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
    prefix bm: <http://www.w3.org/2002/01/bookmark#>
    prefix exif: <http://www.w3.org/2003/12/exif/ns/>
    prefix ann: <http://www.w3.org/2000/10/annotation-ns#>
    prefix wikiont: <http://sw.deri.org/2005/04/wikipedia/wikiont.owl#>
    prefix calendar: <http://www.w3.org/2002/12/cal#>
    prefix ods: <http://www.openlinksw.com/virtuoso/ods/>

   alter quad storage virtrdf:DefaultQuadStorage
       
      from DB.DBA.ODS_CALENDAR_EVENTS as cal_events
      where (^{cal_events.}^.U_NAME = ^{users.}^.U_NAME)
      from DB.DBA.ODS_CALENDAR_TAGS as cal_tags
      where (^{cal_tags.}^.U_NAME = ^{users.}^.U_NAME)

{
	create virtrdf:ODS_DS as graph ods:graph (users.U_NAME) option (exclusive)
	  {
	    #----

            # Calendar
            ods:calendar_event (cal_events.U_NAME, cal_events.WAI_NAME, cal_events.E_ID) a calendar:vevent option (EXCLUSIVE) ;
	    dc:title cal_events.E_SUBJECT ;
	    dct:created cal_events.E_CREATED ;
	    dct:modified cal_events.E_UPDATED ;
	    dc:date cal_events.E_UPDATED ;
	    ann:created cal_events.E_CREATED ;
	    dc:creator cal_events.U_NAME ;
	    sioc:link ods:proxy (cal_events.E_URI) ;
	    sioc:content cal_events.E_DESCRIPTION ;
	    sioc:has_creator ods:user (cal_events.U_NAME) ;
	    foaf:maker ods:person (cal_events.U_NAME) ;
	    sioc:has_container ods:calendar_forum (cal_events.U_NAME, cal_events.WAI_NAME) .

	    ods:calendar_forum (cal_events.U_NAME, cal_events.WAI_NAME) sioc:container_of ods:calendar_event (cal_events.U_NAME, cal_events.WAI_NAME, cal_events.E_ID) .

	    ods:user (cal_events.U_NAME) sioc:creator_of ods:calendar_event (cal_events.U_NAME, cal_events.WAI_NAME, cal_events.E_ID) .

	    ods:calendar_event (cal_tags.U_NAME, cal_tags.WAM_INST, cal_tags.ITEM_ID)
	    sioc:topic ods:tag (cal_tags.U_NAME, cal_tags.E_TAG) .

	    ods:tag (cal_tags.U_NAME, cal_tags.E_TAG) a skos:Concept ;
	    skos:prefLabel cal_tags.E_TAG ;
	    skos:isSubjectOf ods:calendar_event (cal_tags.U_NAME, cal_tags.WAM_INST, cal_tags.ITEM_ID) .     
	    # end Calendar
            #---
	  } .
    } .
;
</verbatim>
CategoryVirtuoso CategoryRDF CategoryCalendar