You are viewing a plain text version of this content. The canonical link for it is here.
Posted to infrastructure-issues@apache.org by "Jeff Turner (JIRA)" <ji...@apache.org> on 2006/06/23 07:45:29 UTC
[jira] Created: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Notify Bugzilla users when a project has moved to JIRA
------------------------------------------------------
Key: INFRA-859
URL: http://issues.apache.org/jira/browse/INFRA-859
Project: Infrastructure
Type: Improvement
Security: public (Regular issues)
Components: JIRA, Bugzilla
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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "Sebb (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "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
[jira] Updated: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "Henri Yandell (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Henri Yandell updated INFRA-859:
--------------------------------
Component/s: (was: JIRA)
(was: Bugzilla)
Infra Wishlist
Considering this a wishlist issue.
> 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
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "Sander Temme (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466129 ]
Sander Temme commented on INFRA-859:
------------------------------------
When a project moves to JIRA, all its bugs, resolutions, history and comments are preserved, right? Perhaps we should just excise projects that have left from Bugzilla altogether.
> 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
[jira] Commented: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "Henri Yandell (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466259 ]
Henri Yandell commented on INFRA-859:
-------------------------------------
The history doesn't come over - so every now and then I go to look at the original Bugzilla issue to see who reopened it, or who closed it etc. So I've definitely found value in maintaining the old version.
> 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
[jira] Assigned: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "Henri Yandell (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Henri Yandell reassigned INFRA-859:
-----------------------------------
Assignee: Henri Yandell
> 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
[jira] Assigned: (INFRA-859) Notify Bugzilla users when a project
has moved to JIRA
Posted by "Henri Yandell (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/INFRA-859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Henri Yandell reassigned INFRA-859:
-----------------------------------
Assignee: (was: Henri Yandell)
> 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.