Mercurial > libervia-pubsub

annotate db/sat_pubsub_update_4_5.sql @ 405:c56a728412f1

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
file organisation + setup refactoring: - `/src` has been renamed to `/sat_pubsub`, this is the recommended naming convention - revamped `setup.py` on the basis of SàT's `setup.py` - added a `VERSION` which is the unique place where version number will now be set - use same trick as in SàT to specify dev version (`D` at the end) - use setuptools_scm to retrieve Mercurial hash when in dev version
author Goffi <goffi@goffi.org>
date Fri, 16 Aug 2019 12:00:02 +0200
parents 1dc606612405
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';