Mercurial > libervia-pubsub

diff db/sat_pubsub_update_0_1.sql @ 303:3c2705199108

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sat_pubsub_update_0_1.sql now also updates comment nodes
author Goffi <goffi@goffi.org>
date Tue, 01 Dec 2015 23:32:32 +0100
parents 05c875a13a62
children 4d4575911060
line wrap: on
line diff
--- a/db/sat_pubsub_update_0_1.sql	Wed Nov 25 22:48:59 2015 +0100
+++ b/db/sat_pubsub_update_0_1.sql	Tue Dec 01 23:32:32 2015 +0100
@@ -28,5 +28,5 @@
                         xmlelement(name entry, xmlattributes('http://www.w3.org/2005/Atom' as xmlns), array_to_string(xpath('/item/entry/*', data::xml)::text[], '')::xml),
                         XMLPARSE(CONTENT NULLIF(array_to_string(xpath('/item/entry/following-sibling::*', data::xml)::text[],''),'')))
              FROM nodes WHERE nodes.node_id = items.node_id
-             AND node = 'urn:xmpp:microblog:0'
+             AND (node = 'urn:xmpp:microblog:0' or node LIKE 'urn:xmpp:comments:%')
              AND XMLEXISTS('/item/entry' PASSING (data::xml));