cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pier Fumagalli <p...@betaversion.org>
Subject Re: Would this show up in BugZilla???
Date Mon, 31 Oct 2005 16:10:25 GMT
On 31 Oct 2005, at 16:08, Scott Sanders wrote:
> On Oct 31, 2005, at 7:21 AM, Pier Fumagalli wrote:
>> On 31 Oct 2005, at 14:52, Sander Temme wrote:
>>> On Oct 31, 2005, at 5:53 AM, Pier Fumagalli wrote:
>>>
>>>
>>>> As we want to put a comment into all cocoon bugs in BugZilla  
>>>> pointing to Jira, would something like this work?
>>>>
>>>> insert into longdescs (bug_id,who,bug_when,thetext) values (X, 
>>>> 1,SYSDATE(),'Issue migrated to Jira: http://issues.apache.org/ 
>>>> jira/bugzillasearch.jsp?id=X');
>>>> update bugs set resolution = 'MOVED' where bug_id = X;
>>>>
>>>> where X is the Cocoon bug ID (select bug_id from bugs where  
>>>> product_id=8;) ????????
>>>>
>>>
>>> At quick glance, that would be the way to hack it. Let me give it  
>>> a more coomprehensive glance after I get myself a cup of coffee.
>>>
>>
>> Coffee is _always_ priority.
>>
>>
>>> I don't suppose this could be done in one line of SQL?
>>>
>>
>> Dunno, maybe tweaking about with the SQL one can do the select for  
>> all cocoon bugs and in-line with the insert and the update  
>> statement, but my SQL is not that good when it comes to bulk  
>> operations (under Oracle, i'd do that with a stored procedure, but  
>> we all agree that Oracle AND stored procedures are the root of all  
>> evil)...
>
> INSERT INTO longdescs (bug_id,who,bug_when,thetext) SELECT bug_id, 
> 1,SYSDATE(),'Issue migrated to Jira: http://issues.apache.org/jira/ 
> bugzillasearch.jsp?id=' || bug_id from bugs where product_id =8;
>
> Should work, unless I messed up some minor bit of syntax.

Ok, but I don't have permissions to try this out... The only thing I  
got is "readbugs" access! :-)

     Pier


Mime
View raw message