New custom fields proposal

[Bradley Baetz]

On Thu, Apr 10, 2003 at 04:51:46PM -0700, Joel Peshkin wrote:
> My company maintains a "product hierarchy" in an Oracle database and 
> would want many of the selections of Bugzilla fields to be tied to that 
> foreign data source.   The problem is that just referencing that source 
> may not be enough.  Which values I can choose from for a given field may 
> be a function of a number of things (like who I am and what product I am 
> in).   I have not yet figured out a way to generalize this.

What you do is:

a) Port bugzilla to oracle

b) Create a VIEW which does the filtering you want, and presents the
data with the same format bugzilla uses. Use an application context for
the 'current user' info, or reference a package var manually, or
whatever.

c) Use that instead of the table, defining triggers to handle updating
if you want to (which you probably don't want to allow from the bz end).

You can s/oracle/postgres/, but then you'll need a stored proc returning
a set instead of the view, which will mean bugzilla hooks, and less
flexibility. You can also do dblinks with oracle, and you can't with pg.

Or did you mean something simpler? :)

You could manually have a script to push updates from one db to the
other...

Bradley