Message5142
The attached patch modifies backends/back_postgresql.py to allow
Roundup to create and use a roundup tracker in a Postgresql schema
(as opposed to requiring a separate database as formerly). This
allows multiple trackers to share a single database.
Having multiple trackers in separate schema of a single database
can simplify management of the trackers and offers options for
aggregated reporting.
The possibility was discussed in the roundup users email list,
"Data in postgres 'trackers' database, 'helpdesk' schema.",
Tom Ekberg <tekberg@uw.edu>, 2014-08-29.
The approach used largely follows the suggestions of John P.
Rouillard in
http://sourceforge.net/p/roundup/mailman/message/32777168/.
After applying the attached patch, use of a Postgresql schema
is requested by setting a RDBMS name value in the config file
with a dot and schema name following the database name. E.g.,
"roundup.myschema". (This is the same syntax used in Postgresql
and in standard SQL for referencing a schema.) If only the
database name is given, Roundup's behavior is as it was before.
When initializing a new tracker and the use of a schema is
specified, the database must already exist and the roundup user
must have been granted "create" privilege (allows the creation
of new schema) in the named database when "roundup-admin init"
is run.
The patch is incomplete (e.g., requires at least doc updates and
tests) but I wanted to verify the approach is acceptable before
spending more time on it. I am also not totally sure that the "."
in the rdbms name won't cause a problem elsewhere in the Roundup
code.
The patch is against the development version of Roundup as of
rev 5a59c723e57f (2014-09-06) but applies ok to the 1.5.0 version
with "patch --fuzz=3 ...". |
|
Date |
User |
Action |
Args |
2014-09-13 05:15:01 | smcgraw | set | recipients:
+ smcgraw |
2014-09-13 05:15:01 | smcgraw | set | messageid: <1410585301.72.0.708698110835.issue2550852@psf.upfronthosting.co.za> |
2014-09-13 05:15:01 | smcgraw | link | issue2550852 messages |
2014-09-13 05:15:01 | smcgraw | create | |
|