. . "VirtRDFViewODSFeedManager" . . . . "2017-06-13T05:37:42.086979"^^ . . . "VirtRDFViewODSFeedManager" . "2017-06-13T05:37:42.086979"^^ . . . "0bbb9bdf8965fde566c043cbb0591f85" . "%META:TOPICPARENT{name=\"VirtRDFViews\"}%\n\n\n---+++Linked Data View for ODS Feed Manager\n\nIMPORTANT! The following code is part of the ODS global VIEW regarding the Feed Manager 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 Linked Data Views Deployment and Demo Scripts]].\n\n\nsparql prefix ods: \n\n #Feeds\n\tcreate iri class ods:feed \"http://^{URIQADefaultHost}^/dataspace/feed/%d\" (in feed_id integer not null)\n \toption (returns \"http://^{URIQADefaultHost}^/dataspace/feed/%d\" ) .\n\tcreate iri class ods:feed_item \"http://^{URIQADefaultHost}^/dataspace/feed/%d/%d\" (in feed_id integer not null, in item_id integer not null)\n\t \toption (returns \"http://^{URIQADefaultHost}^/dataspace/feed/%d/%d\" ) .\n\tcreate iri class ods:feed_item_text \"http://^{URIQADefaultHost}^/dataspace/feed/%d/%d/text\" (in feed_id integer not null, in item_id integer not null)\n\t\toption (returns \"http://^{URIQADefaultHost}^/dataspace/feed/%d/%d/text\" ) .\n\tcreate iri class ods:feed_mgr \"http://^{URIQADefaultHost}^/dataspace/%U/feeds/%U\" (in uname varchar not null, in inst_name varchar not null)\n\t\toption (returns \"http://^{URIQADefaultHost}^/dataspace/%U/feeds/%U\" ) .\n\tcreate iri class ods:feed_comment \"http://^{URIQADefaultHost}^/dataspace/%U/feeds/%U/%d/%d\"\n\t\t(in uname varchar not null, in inst_name varchar not null, in item_id integer not null, in comment_id integer not null)\n\t\toption (returns \"http://^{URIQADefaultHost}^/dataspace/%U/feeds/%U/%d/%d\" ) .\n\n\n\nsparql\n prefix sioc: \n prefix sioct: \n prefix atom: \n prefix rdfs: \n prefix foaf: \n prefix dc: \n prefix dct: \n prefix skos: \n prefix geo: \n prefix bm: \n prefix exif: \n prefix ann: \n prefix wikiont: \n prefix calendar: \n prefix ods: \n\n alter quad storage virtrdf:DefaultQuadStorage\n \n from DB.DBA.ODS_FEED_FEED_DOMAIN as feed_domain\n where (^{feed_domain.}^.U_NAME = ^{users.}^.U_NAME)\n from DB.DBA.ODS_FEED_POSTS as feed_posts\n where (^{feed_posts.}^.EFI_FEED_ID = ^{feed_domain.}^.EF_ID)\n from DB.DBA.ODS_FEED_COMMENTS as feed_comments\n where (^{feed_comments.}^.U_NAME = ^{users.}^.U_NAME)\n from DB.DBA.ODS_FEED_TAGS as feed_tags\n where (^{feed_tags.}^.U_NAME = ^{users.}^.U_NAME)\n from DB.DBA.ODS_FEED_LINKS as feed_links\n where (^{feed_links.}^.EFI_FEED_ID = ^{feed_domain.}^.EF_ID)\n from DB.DBA.ODS_FEED_ATTS as feed_atts\n where (^{feed_atts.}^.EFI_FEED_ID = ^{feed_domain.}^.EF_ID)\n\n{\n\tcreate virtrdf:ODS_DS as graph ods:graph (users.U_NAME) option (exclusive)\n\t {\n\t #----\n\n # Feeds\n\t ods:feed (feed_domain.EF_ID) a atom:Feed ;\n\t sioc:link ods:proxy (feed_domain.EF_URI) ;\n\t atom:link ods:proxy (feed_domain.EF_URI) ;\n\t atom:title feed_domain.EF_TITLE ;\n\t sioc:has_parent ods:feed_mgr (feed_domain.U_NAME, feed_domain.WAI_NAME) .\n\n\t ods:feed_mgr (feed_domain.U_NAME, feed_domain.WAI_NAME)\n\t sioc:parent_of ods:feed (feed_domain.EF_ID) .\n\n\n\t ods:feed_item (feed_tags.EFI_FEED_ID, feed_tags.EFID_ITEM_ID)\n\t sioc:topic\n\t ods:tag (feed_tags.U_NAME, feed_tags.EFID_TAG) .\n\n\t ods:tag (feed_tags.U_NAME, feed_tags.EFID_TAG) a skos:Concept ;\n\t skos:prefLabel feed_tags.EFID_TAG ;\n\t skos:isSubjectOf ods:feed_item (feed_tags.EFI_FEED_ID, feed_tags.EFID_ITEM_ID) .\n\n\t ods:feed_comment (feed_comments.U_NAME, feed_comments.WAI_NAME, feed_comments.EFIC_ITEM_ID, feed_comments.EFIC_ID)\n\t a sioct:Comment ;\n\t dc:title feed_comments.EFIC_TITLE ;\n\t sioc:content feed_comments.EFIC_COMMENT ;\n\t dct:modified feed_comments.LAST_UPDATE ;\n\t dct:created feed_comments.LAST_UPDATE ;\n\t sioc:link ods:proxy (feed_comments.LINK) ;\n\t sioc:has_container ods:feed (feed_comments.EFI_FEED_ID) ;\n\t sioc:reply_of ods:feed_item (feed_comments.EFI_FEED_ID, feed_comments.EFIC_ITEM_ID) ;\n\t foaf:maker ods:proxy (feed_comments.EFIC_U_URL) .\n\n\t ods:proxy (feed_comments.EFIC_U_URL) a foaf:Person ;\n\t foaf:name feed_comments.EFIC_U_NAME;\n\t foaf:mbox ods:mbox (feed_comments.EFIC_U_MAIL) .\n\n ods:feed (feed_comments.EFI_FEED_ID)\n\t sioc:container_of\n ods:feed_comment (feed_comments.U_NAME, feed_comments.WAI_NAME, feed_comments.EFIC_ITEM_ID, feed_comments.EFIC_ID) .\n\n ods:feed_item (feed_comments.EFI_FEED_ID, feed_comments.EFIC_ITEM_ID)\n\t sioc:has_reply\n\t ods:feed_comment (feed_comments.U_NAME, feed_comments.WAI_NAME, feed_comments.EFIC_ITEM_ID, feed_comments.EFIC_ID) .\n\n ods:feed_item (feed_links.EFI_FEED_ID, feed_links.EFI_ID)\n\t sioc:links_to\n\t ods:proxy (feed_links.EFIL_LINK) .\n\n\t ods:feed_item (feed_atts.EFI_FEED_ID, feed_atts.EFI_ID)\n\t sioc:attachment\n\t ods:proxy (feed_atts.EFIE_URL) .\n\n\t ods:feed_item (feed_posts.EFI_FEED_ID, feed_posts.EFI_ID) a atom:Entry ;\n\t sioc:has_container ods:feed (feed_posts.EFI_FEED_ID) ;\n\t dc:title feed_posts.EFI_TITLE ;\n\t dct:created feed_posts.PUBLISH_DATE ;\n\t dct:modified feed_posts.PUBLISH_DATE ;\n\t sioc:link ods:proxy (feed_posts.EFI_LINK) ;\n\t sioc:content feed_posts.EFI_DESCRIPTION ;\n\t atom:title feed_posts.EFI_TITLE ;\n\t atom:source ods:feed (feed_posts.EFI_FEED_ID) ;\n\t atom:published feed_posts.PUBLISH_DATE ;\n\t atom:updated feed_posts.PUBLISH_DATE ;\n\t atom:content ods:feed_item_text (feed_posts.EFI_FEED_ID, feed_posts.EFI_ID) .\n\n\t ods:feed (feed_posts.EFI_FEED_ID) sioc:container_of ods:feed_item (feed_posts.EFI_FEED_ID, feed_posts.EFI_ID) .\n\n\t ods:feed_item_text (feed_posts.EFI_FEED_ID, feed_posts.EFI_ID) a atom:Content ;\n\t atom:type \"text/xhtml\" ;\n\t atom:lang \"en-US\" ;\n\t atom:body feed_posts.EFI_DESCRIPTION .\n\n\t ods:feed (feed_posts.EFI_FEED_ID)\n\t atom:contains\n\t ods:feed_item (feed_posts.EFI_FEED_ID, feed_posts.EFI_ID) .\n # end Feeds\n #---\n\t } .\n } .\n;\n\n\nCategoryVirtuoso CategoryRDF CategoryFeedManager CategoryODS CategoryOdsFeedManager" . . . . . . "2017-06-13T05:37:42Z" . . . "2017-06-13T05:37:42Z" . . . . "VirtRDFViewODSFeedManager" .