RT for Database Updates

RT Users
1

Hi,

I’m working on a project called jake (http://jake-db.org/docs/about.php), and considering using RT as an ‘update tracker’, shifting its use slightly to allow approval and update of database changes (for instance, if the publisher of a particular journal decides to change its name). I’m wondering if anyone has used RT to do this before, and if they could point me to some examples, or share some tips.

Essentially, we want web users to submit update requests (e.g. “Life Magazine” will now be called “Lives Magazine”). The web update engine will generate an XML change object, and create a ticket in the RT system (possibly using SOAP). Then RT ‘Approvers’ will be able to review the change tickets and approve them if appropriate, triggering another action from the RT system to the database front end software, which applies the XML chunk to update the entry to “Lives Magazine”.

If anyone has any suggestions or leads, that would help a great deal.

Thanks much,

David Sarno

2

| Essentially, we want web users to submit update requests (e.g. “Life
| Magazine” will now be called “Lives Magazine”). The web update engine
| will generate an XML change object, and create a ticket in the RT system
| (possibly using SOAP). Then RT ‘Approvers’ will be able to review the
| change tickets and approve them if appropriate, triggering another action
| from the RT system to the database front end software, which applies the
| XML chunk to update the entry to “Lives Magazine”.
±–>8

RT2 could probably be made to do that kind of thing via scrips. RT1 would
require more hacking…

This sounds to me like a web interface to Aegis (a free version control
system with configurable test and review mechanisms for checkins, among
many other features) might be closer to what you want, though. Although
I’m not aware of any of those, either… possibly RT2 with scrips acting as
a front end to Aegis?

http://www.pcug.org.au/~millerp/aegis/aegis.html

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]