Mercurial > libervia-pubsub
diff sat_pubsub/pgsql_storage.py @ 466:0d38c3529972
psql: schema update (9) to add `roster` table
author | Goffi <goffi@goffi.org> |
---|---|
date | Fri, 15 Oct 2021 13:40:59 +0200 |
parents | f520ac3164b0 |
children | d86e0f8a1405 |
line wrap: on
line diff
--- a/sat_pubsub/pgsql_storage.py Fri Oct 15 13:40:59 2021 +0200 +++ b/sat_pubsub/pgsql_storage.py Fri Oct 15 13:40:59 2021 +0200 @@ -78,7 +78,7 @@ parseXml = lambda unicode_data: generic.parseXml(unicode_data.encode('utf-8')) ITEMS_SEQ_NAME = 'node_{node_id}_seq' PEP_COL_NAME = 'pep' -CURRENT_VERSION = '8' +CURRENT_VERSION = '9' # retrieve the maximum integer item id + 1 NEXT_ITEM_ID_QUERY = r"SELECT COALESCE(max(item::integer)+1,1) as val from items where node_id={node_id} and item ~ E'^\\d+$'"