comparison roundup/configuration.py @ 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 4af0d235b570
children 6f66d74d37f3
comparison
equal deleted inserted replaced
7718:3da452f4a3ac 7719:3071db43bfb6
1433 )), 1433 )),
1434 ("rdbms", ( 1434 ("rdbms", (
1435 (DatabaseBackend, 'backend', NODEFAULT, 1435 (DatabaseBackend, 'backend', NODEFAULT,
1436 "Database backend."), 1436 "Database backend."),
1437 (Option, 'name', 'roundup', 1437 (Option, 'name', 'roundup',
1438 "Name of the database to use.", 1438 "Name of the database to use. For Postgresql, this can\n"
1439 "be database.schema to use a specific schema within\n"
1440 "a Postgres database.",
1439 ['MYSQL_DBNAME']), 1441 ['MYSQL_DBNAME']),
1440 (NullableOption, 'host', 'localhost', 1442 (NullableOption, 'host', 'localhost',
1441 "Database server host.", 1443 "Database server host.",
1442 ['MYSQL_DBHOST']), 1444 ['MYSQL_DBHOST']),
1443 (NullableOption, 'port', '', 1445 (NullableOption, 'port', '',

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