Mercurial > libervia-pubsub

annotate db/libervia_pubsub_update_4_5.sql @ 481:0e801ae1869f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
backend: use `typing.Dict[]` instead of `dict[]` to be compatible with Python 3.7
author Goffi <goffi@goffi.org>
date Tue, 06 Sep 2022 11:31:00 +0200
parents 9af0ef2c145c
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
403
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
1 -- we check version of the database before doing anything
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
2 -- and stop execution if not good
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
3 \set ON_ERROR_STOP
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
4 DO $$
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
5 DECLARE ver text;
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
6 BEGIN
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
7 SELECT value INTO ver FROM metadata WHERE key='version';
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
8 IF NOT FOUND OR ver!='4' THEN
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
9 RAISE EXCEPTION 'This update file needs to be applied on database schema version 4, you use version %',ver;
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
10 END IF;
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
11 END$$;
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
12 \unset ON_ERROR_STOP
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
13 -- end of version check
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
14
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
15 /* new "max_items" and "consistent publisher" options */
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
16 ALTER TABLE nodes ADD COLUMN max_items integer NOT NULL DEFAULT 0
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
17 CHECK (max_items >= 0);
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
18 ALTER TABLE nodes ADD COLUMN consistent_publisher boolean NOT NULL DEFAULT FALSE;
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
19
1dc606612405 implemented experimental "consistent_publisher" option:
Goffi <goffi@goffi.org>
parents:
diff changeset
20 UPDATE metadata SET value='5' WHERE key='version';