www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sebb (JIRA)" <j...@apache.org>
Subject [jira] Commented: (INFRA-859) Notify Bugzilla users when a project has moved to JIRA
Date Tue, 13 Nov 2007 17:30:43 GMT

    [ https://issues.apache.org/jira/browse/INFRA-859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12542177
] 

Sebb commented on INFRA-859:
----------------------------

"select pkey"  - could use "select count(pkey)" ?

But it seems to me that querying the Jira database is unnecessary overhead.

When a project is migrated, all project issues are migrated.

It would probably be cheaper to maintain a list of migrated projects, and use that to decide
what to do.

Perhaps show_bug.cgi could look up the bug in the Bugzilla database and match the project
name against a list?
Or indeed can it look at the read-only status?

Or the show bug page could be given a different background if the project is in a list?

Migrations are fairly infrequent, so updating a fixed list of migrated projects should not
be too much of an overhead.


> Notify Bugzilla users when a project has moved to JIRA
> ------------------------------------------------------
>
>                 Key: INFRA-859
>                 URL: https://issues.apache.org/jira/browse/INFRA-859
>             Project: Infrastructure
>          Issue Type: Improvement
>      Security Level: public(Regular issues) 
>          Components: Infra Wishlist
>            Reporter: Jeff Turner
>
> Various projects have moved from Bugzilla to JIRA. Although we can disable creation of
new Bugzilla bugs, we cannot prevent people from commenting. We need a way of redirecting
users to the equivalent JIRA issue.
> Testing if a Bugzilla bug is superceded by a JIRA issue is fairly easy. Just query the
JIRA database with the bug ID. Eg. to test bug 798:
> jira@brutus:~$ mysql jira -e "select pkey from jiraissue, customfield, customfieldvalue
where jiraissue.id=customfieldvalue.issue and customfield.id=customfieldvalue.customfield
and customfield.cfname='Bugzilla Id' and customfieldvalue.NUMBERVALUE=798"
> +-----------+
> | pkey      |
> +-----------+
> | XALANJ-40 |
> +-----------+
> If the query returns nothing, the Bugzilla bug is not superceded.
> So now we just need someone with enough Perl/Bugzilla-fu to integrate this test into
show_bug.cgi :) Any takers?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message