"2017-06-13T05:48:37Z" . "95acb5f0a5f3d3e1b6b7c9848cc238b3" . "2017-06-13T05:48:37Z" . . . . . . "VirtRDFViewODSBlog" . . "VirtRDFViewODSBlog" . . . . . "VirtRDFViewODSBlog" . . . . . . "2017-06-13T05:48:37.336781"^^ . . "2017-06-13T05:48:37.336781"^^ . . "---+++RDF View for ODS Weblog\n\nIMPORTANT! The following code is part of the ODS global VIEW regarding the Weblog 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]].\n\n\nsparql prefix ods: \n\ncreate iri class ods:blog_forum \"http://^{URIQADefaultHost}^/dataspace/%U/weblog/%U\"\n\t\t(in uname varchar not null, in forum_name varchar not null)\n\t\toption (returns \"http://^{URIQADefaultHost}^/dataspace/%U/weblog/%U\") .\n\tcreate iri class ods:blog_post \"http://^{URIQADefaultHost}^/dataspace/%U/weblog/%U/%U\"\n\t\t(in uname varchar not null, in forum_name varchar not null, in postid varchar not null)\n\t\toption (returns \"http://^{URIQADefaultHost}^/dataspace/%U/weblog/%U/%U\" ) .\n\tcreate iri class ods:blog_comment \"http://^{URIQADefaultHost}^/dataspace/%U/weblog/%U/%U/%d\"\n\t\t(in uname varchar not null, in forum_name varchar not null, in postid varchar not null, in comment_id int not null)\n \t option (returns \"http://^{URIQADefaultHost}^/dataspace/%U/weblog/%U/%U/%d\" ) .\n\tcreate iri class ods:tag \"http://^{URIQADefaultHost}^/dataspace/%U/concept#%U\"\n\t\t(in uname varchar not null, in tag varchar not null)\n option (returns \"http://^{URIQADefaultHost}^/dataspace/%U/concept#%U\") .\n\tcreate iri class ods:blog_post_text \"http://^{URIQADefaultHost}^/dataspace/%U/weblog-text/%U/%U\"\n\t\t(in uname varchar not null, in forum_name varchar not null, in postid varchar not null)\n\t\toption (returns \"http://^{URIQADefaultHost}^/dataspace/%U/weblog-text/%U/%U\" ) .\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 from DB.DBA.ODS_BLOG_POSTS as blog_posts\n where (^{blog_posts.}^.B_OWNER = ^{users.}^.U_NAME)\n from DB.DBA.ODS_BLOG_POST_LINKS as blog_links\n where (^{blog_links.}^.B_OWNER = ^{users.}^.U_NAME)\n from DB.DBA.ODS_BLOG_POST_ATTS as blog_atts\n where (^{blog_atts.}^.B_OWNER = ^{users.}^.U_NAME)\n from DB.DBA.ODS_BLOG_POST_TAGS as blog_tags\n where (^{blog_tags.}^.U_NAME = ^{users.}^.U_NAME)\n from DB.DBA.ODS_BLOG_COMMENTS as blog_comms\n where (^{blog_comms.}^.U_NAME = ^{users.}^.U_NAME) \n\n{\n\tcreate virtrdf:ODS_DS as graph ods:graph (users.U_NAME) option (exclusive)\n\t {\n\t ods:user (users.U_NAME) a sioc:User ;\n sioc:id users.U_NAME ;\n sioc:name users.U_FULL_NAME ;\n sioc:email ods:mbox (users.E_MAIL) ;\n sioc:email_sha1 users.E_MAIL_SHA1 ;\n sioc:account_of ods:person (users.U_NAME) .\n\n\t ods:person (person.U_NAME) a foaf:Person ;\n foaf:nick person.U_NAME ;\n\t foaf:name person.U_FULL_NAME ;\n\t foaf:mbox ods:mbox (person.E_MAIL) ;\n foaf:mbox_sha1sum person.E_MAIL_SHA1 ;\n foaf:holdsAccount ods:user (person.U_NAME) ;\n foaf:firstName person.FIRST_NAME ;\n foaf:family_name person.LAST_NAME ;\n foaf:gender person.GENDER ;\n foaf:icqChatID person.ICQ ;\n foaf:msnChatID person.MSN ;\n foaf:aimChatID person.AIM ;\n foaf:yahooChatID person.YAHOO ;\n foaf:birthday person.BIRTHDAY ;\n foaf:organization person.ORG ;\n foaf:phone ods:phone (person.PHONE) ;\n\t foaf:based_near ods:geo_point (person.U_NAME)\n\t .\n\n # Weblog\n\t ods:blog_post (blog_posts.B_OWNER, blog_posts.B_INST, blog_posts.B_POST_ID) a sioct:BlogPost ;\n\t sioc:link ods:proxy (blog_posts.B_LINK) ;\n\t sioc:has_creator ods:user (blog_posts.B_CREATOR) ;\n\t foaf:maker ods:person (blog_posts.B_CREATOR) ;\n\t sioc:has_container ods:blog_forum (blog_posts.B_OWNER, blog_posts.B_INST) ;\n\t dc:title blog_posts.B_TITLE ;\n\t dct:created blog_posts.B_CREATED ;\n\t dct:modified blog_posts.B_MODIFIED ;\n\t sioc:content blog_posts.B_CONTENT .\n\n\t ods:blog_forum (blog_posts.B_OWNER, blog_posts.B_INST)\n\t sioc:container_of\n\t ods:blog_post (blog_posts.B_OWNER, blog_posts.B_INST, blog_posts.B_POST_ID) .\n\n\t ods:user (blog_posts.B_CREATOR)\n\t sioc:creator_of\n\t ods:blog_post (blog_posts.B_OWNER, blog_posts.B_INST, blog_posts.B_POST_ID) .\n\n\t ods:blog_post (blog_links.B_OWNER, blog_links.B_INST, blog_links.B_POST_ID)\n\t sioc:links_to\n\t ods:proxy (blog_links.PL_LINK) .\n\t # end Weblog\n\t } .\n } .\n;\n\nCategoryVirtuoso CategoryRDF CategoryBlog\n\n\n\n\n\n\n\n\n" .