Mercurial > libervia-pubsub
annotate db/sat_pubsub_update_2_3.sql @ 431:5e8b8ef5c862
implentation of XEP-0346 (Form Discovery and Publishing):
The former non standard node schema has been replaced by XEP-0346 which uses 2 nodes (one
from schema/template and one for submitted values).
The implementation is an adapation of the former one, and data validation is still done
even if this is not currently specified in any XEP.
When the template node is modified, the change is reflected in the node schema.
| author | Goffi <goffi@goffi.org> |
|---|---|
| date | Fri, 11 Dec 2020 17:19:00 +0100 |
| parents | 1dc606612405 |
| children |
| rev | line source |
|---|---|
| 350 | 1 -- we check version of the database before doing anything |
| 2 -- and stop execution if not good | |
| 3 \set ON_ERROR_STOP | |
| 4 DO $$ | |
| 5 DECLARE ver text; | |
| 6 BEGIN | |
| 7 SELECT value INTO ver FROM metadata WHERE key='version'; | |
| 8 IF NOT FOUND OR ver!='2' THEN | |
|
403
1dc606612405
implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
350
diff
changeset
|
9 RAISE EXCEPTION 'This update file needs to be applied on database schema version 2, you use version %',ver; |
| 350 | 10 END IF; |
| 11 END$$; | |
| 12 \unset ON_ERROR_STOP | |
| 13 -- end of version check | |
| 14 | |
| 15 /* we add "presence" access model */ | |
| 16 ALTER TABLE nodes DROP CONSTRAINT nodes_access_model_check; | |
| 17 ALTER TABLE nodes ADD CHECK (access_model IN ('open', 'presence', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')); | |
| 18 | |
| 19 /* and schema column */ | |
| 20 ALTER TABLE nodes ADD COLUMN schema xml; | |
| 21 | |
| 22 /* we want xml types for items data too */ | |
| 23 ALTER TABLE items ALTER data TYPE xml using data::xml; | |
| 24 | |
| 25 UPDATE metadata SET value='3' WHERE key='version'; |