Roundup Tracker - Issues

Message5142

Author smcgraw
Recipients smcgraw
Date 2014-09-13.05:15:00
Message-id <1410585301.72.0.708698110835.issue2550852@psf.upfronthosting.co.za>
In-reply-to
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 ...".
History
Date User Action Args
2014-09-13 05:15:01smcgrawsetrecipients: + smcgraw
2014-09-13 05:15:01smcgrawsetmessageid: <1410585301.72.0.708698110835.issue2550852@psf.upfronthosting.co.za>
2014-09-13 05:15:01smcgrawlinkissue2550852 messages
2014-09-13 05:15:01smcgrawcreate