Mercurial > p > roundup > code
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', '', |
