cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Sanders <sand...@apache.org>
Subject Re: Would this show up in BugZilla???
Date Mon, 31 Oct 2005 16:08:19 GMT

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.

Scott
Mime
View raw message