comparison CHANGES.txt @ 7719:3071db43bfb6

feat: issue2550852 - support using a specified PostgreSQL db schema Finally after 7 years this is closed. roundup/backends/back_postgresql.py: Support use of schema when specified in RDBMS_NAME. Stuart McGraws code is finally merged 8-). test/test_postgresql.py, test/conftest.py: Run all postgresql tests in the schema db as well. Also make sure that db_nuke raises an error when trying to delete the schema test database. Conftest defines pg_schema mark that can be used to exclude schema tests with pytest -m "not pg_schema". roundup/configuration.py: change doc on RDBMS_NAME to include db.schema form. .travis.yml, .github/workflows/ci-test.yml: create schema test db; add user for testing with schema; grant new user create privs for schema. doc/installation.txt: Reference to roundup-admin init deleting schema added. doc/mysql.txt doc/postgresql.txt: New documentation on psql/mysql commands to set up a production db. doc/upgrading.txt: mention schema support, also document service setting for selecting connection from pg_service.conf. doc/reference.txt: update config.ini documentation for RDBMS_NAME.
author John Rouillard <rouilj@ieee.org>
date Wed, 27 Dec 2023 22:52:14 -0500
parents 29ef4b69f18c
children 6f66d74d37f3
comparison
equal deleted inserted replaced
7718:3da452f4a3ac 7719:3071db43bfb6
102 - issue2551299 - support config.ini rdbms option 'service'. Allow use 102 - issue2551299 - support config.ini rdbms option 'service'. Allow use
103 of a PostgreSQL connection service file (pg_service.conf) for 103 of a PostgreSQL connection service file (pg_service.conf) for
104 configuring database on a per-tracker basis. Also replaces use of 104 configuring database on a per-tracker basis. Also replaces use of
105 PGSERVICE env variable for single instance trackers. (From ML 105 PGSERVICE env variable for single instance trackers. (From ML
106 question by ivanov. John Rouillard) 106 question by ivanov. John Rouillard)
107 - issue2550852 - support for specifying a PostgreSQL schema to use for
108 the Roundup database. (Patch by Stuart McGraw; slight modifications,
109 tests, docs: John Rouillard).
107 110
108 2023-07-13 2.3.0 111 2023-07-13 2.3.0
109 112
110 Fixed: 113 Fixed:
111 114

Roundup Issue Tracker: http://roundup-tracker.org/