From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.emacs.gnus.general/62765 Path: news.gmane.org!not-for-mail From: Lars Magne Ingebrigtsen Newsgroups: gmane.emacs.gnus.general Subject: Re: Gnus interface to Bugzilla? Date: Thu, 13 Apr 2006 19:50:08 +0200 Organization: Programmerer Ingebrigtsen Message-ID: References: NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable X-Trace: sea.gmane.org 1144950701 1250 80.91.229.2 (13 Apr 2006 17:51:41 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Thu, 13 Apr 2006 17:51:41 +0000 (UTC) Original-X-From: ding-owner+m11292@lists.math.uh.edu Thu Apr 13 19:51:39 2006 Return-path: Envelope-to: ding-account@gmane.org Original-Received: from malifon.math.uh.edu ([129.7.128.13]) by ciao.gmane.org with esmtp (Exim 4.43) id 1FU5yj-0000GL-L6 for ding-account@gmane.org; Thu, 13 Apr 2006 19:51:38 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.math.uh.edu ident=lists) by malifon.math.uh.edu with smtp (Exim 3.20 #1) id 1FU5yd-0002Yk-00; Thu, 13 Apr 2006 12:51:31 -0500 Original-Received: from nas02.math.uh.edu ([129.7.128.40]) by malifon.math.uh.edu with esmtp (Exim 3.20 #1) id 1FU5y9-0002Yf-00 for ding@lists.math.uh.edu; Thu, 13 Apr 2006 12:51:01 -0500 Original-Received: from quimby.gnus.org ([80.91.224.244]) by nas02.math.uh.edu with esmtp (Exim 4.52) id 1FU5y5-0003Ow-QY for ding@lists.math.uh.edu; Thu, 13 Apr 2006 12:51:01 -0500 Original-Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by quimby.gnus.org with esmtp (Exim 3.35 #1 (Debian)) id 1FU5y4-0005Tf-00 for ; Thu, 13 Apr 2006 19:50:56 +0200 Original-Received: from list by ciao.gmane.org with local (Exim 4.43) id 1FU5xq-00006e-Kt for ding@gnus.org; Thu, 13 Apr 2006 19:50:42 +0200 Original-Received: from quimbies.gnus.org ([80.91.231.2]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 13 Apr 2006 19:50:42 +0200 Original-Received: from larsi by quimbies.gnus.org with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 13 Apr 2006 19:50:42 +0200 X-Injected-Via-Gmane: http://gmane.org/ Mail-Followup-To: ding@gnus.org Original-To: ding@gnus.org Original-Lines: 43 Original-X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: quimbies.gnus.org Mail-Copies-To: never X-Now-Playing: Pale Saints's _In Ribbons_: "Liquid" Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAHlBMVEV4dGmIfG6njXPLo3n2 wXmwqpi8wsDTtJDn06/t7d5OIB6wAAAACXBIWXMAAABIAAAASABGyWs+AAACM0lEQVQ4y11TwXLT QAzdYYZ7+QU6gTMtM/EHcMgVZgzTD2DJXmnTtc9xY+ncsJH+lietYxscJ471JL2nJzuoRi2lxFI4 7TmWU0wpxliCJi2pqOIU//hf1YBr0RRxw6LN7hVISggFQ5P6QdKxklq4lOBdosWZLh9JhVNJSA3q F4szvb6/bZRBmVKyVikhjwGNt01nnGBMofaxuOrxTU8AkJ+Kk0d1mcYsWqdSVKBTEWdRT8CA0B/S NKCKTIBGsFurNA1SAUYeHIEqGwQA2pMDYr6hlXOoTjZVchT4HFobkbUijGv2urtWklDRI56tMdjj tQLW2vRjZmYbcGkFSKi/bFnhYpkrxAqEnvkR+KmYJcXVE9nPNtPI6OgmViOgSCT/yDn3F2LbVPAh aECHY85dbuiMYngSyEYmsu+Yu47AxPsTOAbWQTrALMP4ZCnKv6A4nL/QMPJg92QHmwcEuUc+3nHd rMXdYpMPjua+30lnEjIp1SVDFcuOznzemSnIbBj6xr1KMFNpGkT1vIVYohNpYIv7wmXEc/LIvpfL Q6iLNk/4QpRH0BwshAoTQtYL7D0Sxk2LzQTxhw3W4nTf9BC/bezZrbt2EifTl/3P9oMBk/I540+L N2pVAZ56fWn3FVgOLPf31+9dG+urdu1k/n7+9O7m4fA/APbx7uatynMFZNVquN9MiWERdd29ToAs NbISUufg6/Prc84VSyIvUoKu9a46GkD/DMlzhTu+kjwDNAOyyvgLycJ0ya+YvYoAAAAASUVORK5C YII= User-Agent: Gnus/5.110005 (No Gnus v0.5) Emacs/22.0.50 (gnu/linux) Cancel-Lock: sha1:+pgLBb8vE46bCTWB7VODB/lY01M= X-Spam-Score: -2.6 (--) Precedence: bulk Original-Sender: ding-owner@lists.math.uh.edu Xref: news.gmane.org gmane.emacs.gnus.general:62765 Archived-At: Lars Magne Ingebrigtsen writes: > All Gnus needs is the number of responses per bug report, and that can > probably be put into buglist.cgi as it is... I've looked at the code. It basically creates a select from the BUGS table. That table doesn't have a count of the number of responses, so you'd need to select from the longdescs table. Uhm... you wouldn't happen to be working on this at the moment, Steve? http://issues.sxemacs.org/buglist.cgi?query_format=3Dspecific&order=3Drelev= ance+desc&bug_status=3D__open__&product=3D&content=3Dgnus =3D> DBD::Pg::st execute failed: ERROR: syntax error at or near "desc" at chara= cter 1146 [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs= .bug_status, bugs.resolution, bugs.bug_severity, bugs.priority, bugs.rep_pl= atform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.= short_desc, (SUM(CASE WHEN (LOWER(longdescs_0.thetext) LIKE '%gnus%') THEN = 1 ELSE 0 END)/COUNT(CASE WHEN (LOWER(longdescs_0.thetext) LIKE '%gnus%') TH= EN 1 ELSE 0 END) + CASE WHEN (LOWER(bugs.short_desc) LIKE '%gnus%') THEN 1 = ELSE 0 END) AS relevance FROM bugs INNER JOIN profiles AS map_assigned_to = ON (bugs.assigned_to =3D map_assigned_to.userid) INNER JOIN longdescs AS lo= ngdescs_0 ON (bugs.bug_id =3D longdescs_0.bug_id ) LEFT JOIN bug_group_map = ON bug_group_map.bug_id =3D bugs.bug_id WHERE ((bugs.bug_status IN ('UNCO= NFIRMED','NEW','ASSIGNED','REOPENED'))) AND (((CASE WHEN (LOWER(longdescs_0= .thetext) LIKE '%gnus%') THEN 1 ELSE 0 END > 0) OR (bugs.short_desc ~* '(^|= [^a-z0-9])gnus($|[^a-z0-9])'))) AND bugs.creation_ts IS NOT NULL AND ((bug_= group_map.group_id IS NULL)) GROUP BY bugs.bug_id, bugs.short_desc, bugs.bu= g_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.rep_platf= orm, map_assigned_to.login_name, relevance desc ORDER BY relevance desc LIM= IT 200"] at /var/www/htdocs/SXEmacs-issues/buglist.cgi line 820 --=20 (domestic pets only, the antidote for overdose, milk.) larsi@gnus.org * Lars Magne Ingebrigtsen