. . . "2017-06-13T05:49:29Z" . . "2017-06-13T05:49:29Z" . . . "VirtRDFViewWordpressScript" . "---++WordPress Linked Data Views Script to set up your own instance\n\n\nuse wordpress;\n\ndrop view wpl_users_rdf;\ndrop view wpl_site_rdf;\ndrop view wpl_posts_rdf;\n\nsparql\nprefix v: \ndrop quad map virtrdf:Wordpress .\ndrop iri class v:user_iri .\ndrop iri class v:iri .\ndrop iri class v:post_iri .\ndrop iri class v:site_iri .\ndrop iri class v:forum_iri .\ndrop iri class v:mbox .\n;\n\n\nuse wordpress;\n\ncreate procedure w3c_date (in ds varchar)\n{\n return replace (ds, ' ', 'T') || 'Z';\n};\n\ncreate view wpl_users_rdf as select ID, user_login, user_nicename, user_email as user_email, sha1_digest (user_email) as user_email_sha1, display_name from wpl_users;\n\ncreate view wpl_site_rdf as select a.option_value url, b.option_value blogname, c.option_value blogdesc from wpl_options a, wpl_options b, wpl_options c where c.option_name = 'blogdescription'and a.option_name = 'siteurl' and b.option_name = 'blogname';\n\ncreate view wpl_posts_rdf as select post_title, p.ID as post_id, post_content,\n wordpress..w3c_date (post_date_gmt) as post_date_gmt, wordpress..w3c_date (post_modified_gmt) as post_modified_gmt, user_login,\n o.option_value as site_url, concat (o.option_value, '?p=', cast (p.ID as varchar)) as post_url,\n o2.option_value as blogname\n from\n wpl_posts p, wpl_users u, wpl_options o, wpl_options o2 where ((post_author = u.ID) or (post_author = 0 and u.ID = 1)) and o.option_name = 'siteurl' and p.post_status = 'publish' and o2.option_name = 'blogname';\n\ngrant select on wpl_users_rdf to \"SPARQL\";\ngrant select on wpl_site_rdf to \"SPARQL\";\ngrant select on wpl_posts_rdf to \"SPARQL\";\ngrant execute on wordpress..w3c_date to \"SPARQL\";\n\n\nsparql\nprefix sioc: \nprefix sioct: \nprefix atom: \nprefix rdfs: \nprefix foaf: \nprefix dc: \nprefix dct: \nprefix skos: \nprefix geo: \nprefix v: \n\ncreate iri class v:user_iri \"http://^{URIQADefaultHost}^/wordpress/user/%U#this\" (in user_name varchar not null) .\ncreate iri class v:iri \"http://^{URIQADefaultHost}^/wordpress/proxy/%U#this\" (in uri varchar not null) .\ncreate iri class v:post_iri \"http://^{URIQADefaultHost}^/wordpress/post/%d#this\" (in post_id integer not null) .\ncreate iri class v:site_iri \"http://^{URIQADefaultHost}^/wordpress/site/%U#this\" (in blogname varchar not null) .\ncreate iri class v:forum_iri \"http://^{URIQADefaultHost}^/wordpress/blog/%U#this\" (in blogname varchar not null) .\ncreate iri class v:mbox \"mailto:%s\" (in mail varchar not null) .\n\nalter quad storage virtrdf:DefaultQuadStorage\n {\n create virtrdf:Wordpress as graph iri (\"http://^{URIQADefaultHost}^/wpl_v\")\n {\n\n v:site_iri (wordpress.DBA.wpl_site_rdf.blogname) a sioc:Space ;\n dc:title blogname ;\n sioc:link v:iri (url) ;\n sioc:host_of v:forum_iri (blogname) .\n\n v:forum_iri (wordpress.DBA.wpl_site_rdf.blogname) a sioc:Forum ;\n a sioc:Container ;\n a sioct:Weblog ;\n dc:title blogname ;\n sioc:description blogdesc ;\n sioc:link v:iri (url) ;\n sioc:has_host v:site_iri (blogname) .\n\n v:user_iri (wordpress.DBA.wpl_users_rdf.user_login) a sioc:User ;\n sioc:id user_login ;\n sioc:name user_nicename ;\n sioc:email v:mbox (user_email) ;\n sioc:email_sha1 user_email_sha1 .\n\n v:post_iri (wordpress.DBA.wpl_posts_rdf.post_id) a sioc:Item ;\n a sioc:Post ;\n a sioct:BlogPost ;\n dc:title post_title ;\n dct:created post_date_gmt ;\n dct:modified post_modified_gmt ;\n sioc:has_creator v:user_iri (user_login) ;\n sioc:has_container v:forum_iri (blogname) ;\n sioc:content post_content ;\n sioc:link v:iri (post_url) ;\n sioc:id post_id .\n\n v:forum_iri (wordpress.DBA.wpl_posts_rdf.blogname) sioc:container_of v:post_iri (post_id) .\n v:user_iri (wordpress.DBA.wpl_posts_rdf.user_login) sioc:creator_of v:post_iri (post_id) .\n\n }\n } .\n;\n\n\nDB.DBA.URLREWRITE_CREATE_REGEX_RULE (\n 'wpl_rule3',\n 1,\n '/wordpress/([^#]*)',\n vector('path'),\n 1,\n '/sparql?query=DESCRIBE+%%3Chttp%%3A//^{URIQADefaultHost}^/wordpress/%U%%23this%%3E+FROM+%%3Chttp%%3A//^{URIQADefaultHost}^/wpl_v%%3E&format=%U',\n vector('path', 'path', '*accept*'),\n null,\n '(text/rdf.n3)|(application/rdf.xml)',\n 2,\n null\n );\n\nDB.DBA.URLREWRITE_CREATE_REGEX_RULE (\n 'wpl_rule2',\n 1,\n '/wordpress/(user|post|site|proxy|blog)/([^#]*)',\n vector('obj', 'path'),\n 1,\n '/ode/index.html?uri=http%%3A//^{URIQADefaultHost}^/wordpress/%U/%U%%23this',\n vector('obj', 'path'),\n null,\n '(text/html)|(\\\\*/\\\\*)',\n 0,\n 303\n );\n\n\nDB.DBA.URLREWRITE_CREATE_RULELIST (\n 'wpl_rule_list1',\n 1,\n vector (\n 'wpl_rule2',\n 'wpl_rule3'\n ));\n\nDB.DBA.VHOST_REMOVE (lpath=>'/wordpress');\nDB.DBA.VHOST_DEFINE (lpath=>'/wordpress', ppath=>'/vad/vsp/wordpress/', is_dav=>0, vsp_user=>'dba', is_brws=>1, def_page=>'index.php',\n opts=>vector ('url_rewrite', 'wpl_rule_list1'));\n\n\n\n\n---+++References\n\n * [[WordPressSIOCRef][WordPress SIOC Reference]]\n * [[http://ods.openlinksw.com/dataspace/dav/wiki/ODS/OdsIntegrationWordPress][WordPress Installation Guide]]" . . . . . . . . . . "2017-06-13T05:49:29.325371"^^ . . "51b865479ee5f89ebeff850e0faebdbe" . "VirtRDFViewWordpressScript" . "2017-06-13T05:49:29.325371"^^ . "VirtRDFViewWordpressScript" .