[Bug 560] "Integrate" AppDB and bugzilla

[Wine Bugs]

http://bugs.winehq.org/show_bug.cgi?id=560

[e-mail] changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]
                URL|                            |http://bugs.winehq.org/bugli
                   |                            |st.cgi?product=Wine&bug_file
                   |                            |_loc_type=substring&bug_file
                   |                            |_loc=http%3A%

------- Additional Comments From [e-mail]  2004-17-03 23:21 -------
Well Jeremy Has opened up the code for the AppDB so that helps

So Here is my thoughts at the moment.

The Problem of Integrateing these two databases is this.

1. when I am in the AppDB I would like a quick way to see all the bugs for this 
app.

2. When am in Bugzilla I would like to have a quick way to see it has to say 
about in the AppDB.

There is a URL Field in the Bugsilla database that is primarily used to point 
to a place where you can download the app when the bug has the Keyword 
Download. If we used this field to point to the Appdb then we have a link to 
the app for the bug.

In the Appdb we can have a link  that has a query to look for the url for this 
app in the URL field in Bugzilla.

I have tried this out in theory using "The Bat: as an Example. In each of the 
bugs in bugzilla I have entered the URL for the bat 
http://appdb.winehq.org/appview.php?appId=68 in the URL Field.

When I use this Query in the URL of this bug I get all the bugs for the bat.

The biggest problem with this solution is that the URL will need to be changed 
for all the existing bugs which is no small task. The second problem is 
maintaining new bugs as they come into Bugzilla.

The first problem can only be overcome with a lot of hard (Grunt) work. There 
are just over 2100 bugs in bugzilla at this time, so if 21 people were to take 
a hundred bugs each I think we could be done in a about a week.

The second problem can be overcome only if we can use the AppDB to be a 
frontend for submissions to bugzilla. I see that there are is at least one 
person (besides myself and Jerry) willing to put some work into the AppDB so I 
have at least a hope of this flying.