[jira] Commented: (INFRA-859) Notify Bugzilla users when a project has moved to JIRA

["Henri Yandell (JIRA)" <ji...@apache.org>]

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

Henri Yandell commented on INFRA-859:
-------------------------------------

Select from postgres various data for a particular project (rather than the whole thing) (??) then generate INSERT statements for comments to bugzilla.

> 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: Bugzilla, JIRA
>            Reporter: Jeff Turner
>         Assigned To: Henri Yandell
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira