Mercurial > libervia-pubsub
annotate db/sat_pubsub_update_2_3.sql @ 428:34bd55179e22
environment variables can now be used to set options:
if an environment variable is set using `SAT_PUBSUB_[OPTION NAME]` it will be used if not
specified directly in command line.
Options are retrieved in this order of priority:
- command line (highest priority)
- environment variable
- option set in `sat.conf`
For database options, following PostgreSQL aliases can also be used: PGUSER, PGDATABASE,
PGPASSWORD, PGHOST, PGPORT.
| author | Goffi <goffi@goffi.org> |
|---|---|
| date | Fri, 09 Oct 2020 18:26:50 +0200 |
| 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'; |