Author: dktrkranz Date: 2010-05-04 13:05:12 +0000 (Tue, 04 May 2010) New Revision: 1737
Added: udd/web/cgi-bin/python_bugs.cgi Log: Extract from UDD Python packages with outstanding noteworthy bugs Added: udd/web/cgi-bin/python_bugs.cgi =================================================================== --- udd/web/cgi-bin/python_bugs.cgi (rev 0) +++ udd/web/cgi-bin/python_bugs.cgi 2010-05-04 13:05:12 UTC (rev 1737) @@ -0,0 +1,98 @@ +#!/usr/bin/python +# +# Copyright (C) 2010 Luca Falavigna <[email protected]> +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 3 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA. +# +# Extract from UDD Python packages with outstanding noteworthy bugs + +from psycopg2 import connect + +query_rc = """ +SELECT all_bugs.id, all_bugs.source, title, severity +FROM all_bugs +INNER JOIN sources_uniq +ON sources_uniq.source = all_bugs.source +WHERE status != 'done' +AND severity in ('critical', 'grave', 'serious') +AND release = 'sid' +AND (maintainer LIKE '%python-apps-team%' +OR maintainer LIKE '%python-modules-team%' +OR uploaders LIKE '%python-apps-team%' +OR uploaders LIKE '%python-modules-team%') +ORDER BY all_bugs.source;""" + +query_help = """ +SELECT all_bugs.id, all_bugs.source, title, severity +FROM all_bugs +INNER JOIN sources_uniq +ON sources_uniq.source = all_bugs.source +INNER JOIN bugs_tags +ON all_bugs.id = bugs_tags.id +WHERE status != 'done' +AND release = 'sid' +AND tag LIKE '%help%' +AND (maintainer LIKE '%python-apps-team%' +OR maintainer LIKE '%python-modules-team%' +OR uploaders LIKE '%python-apps-team%' +OR uploaders LIKE '%python-modules-team%') +ORDER BY all_bugs.source;""" + +query_usertag = """ +SELECT all_bugs.id, all_bugs.source, title, severity +FROM all_bugs +INNER JOIN sources_uniq +ON sources_uniq.source = all_bugs.source +INNER JOIN bugs_usertags +ON all_bugs.id = bugs_usertags.id +WHERE status != 'done' +AND release = 'sid' +AND email LIKE '%[email protected]%' +AND (maintainer LIKE '%python-apps-team%' +OR maintainer LIKE '%python-modules-team%' +OR uploaders LIKE '%python-apps-team%' +OR uploaders LIKE '%python-modules-team%') +ORDER BY all_bugs.source;""" + +conn = connect(database="udd", port=5441, host="localhost", user="guest") +cur = conn.cursor() +cur.execute(query_rc) +rc = cur.fetchall() +cur.close() +cur = conn.cursor() +cur.execute(query_help) +help = cur.fetchall() +cur.close() +cur = conn.cursor() +cur.execute(query_usertag) +usertag = cur.fetchall() +cur.close() +conn.close() + +print 'Content-Type: text/html\n\n' +print '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";>' +print '<html>\n<head>\n<title>Bugs for DPMT/PAPT packages</title>\n<meta http-equiv="Content-Type" content="text/html;charset=utf-8">\n</head>\n<body>' +print '<h1>Release Critical bugs</h1>' +print '<table>\n<tr>\n<td><b>ID</b></td>\n<td><b>Package</b></td>\n<td><b>Title</b></td>\n<td><b>Severity</b></td>\n</tr>' +for d in rc: + print '<tr>\n<td><a href="http://bugs.debian.org/%s";>#%s</a></td>\n<td>%s</td>\n<td>%s</td>\n<td>%s</td>\n</tr>' % (d[0], d[0], d[1], d[2], d[3]) +print '</table>\n<h1>Bugs needing help</h1>' +print '<table>\n<tr>\n<td><b>ID</b></td>\n<td><b>Package</b></td>\n<td><b>Title</b></td>\n<td><b>Severity</b></td>\n</tr>' +for d in help: + print '<tr>\n<td><a href="http://bugs.debian.org/%s";>#%s</a></td>\n<td>%s</td>\n<td>%s</td>\n<td>%s</td>\n</tr>' % (d[0], d[0], d[1], d[2], d[3]) +print '</table>\n<h1>Bugs with usertag [email protected]</h1>' +print '<table>\n<tr>\n<td><b>ID</b></td>\n<td><b>Package</b></td>\n<td><b>Title</b></td>\n<td><b>Severity</b></td>\n</tr>' +for d in usertag: + print '<tr>\n<td><a href="http://bugs.debian.org/%s";>#%s</a></td>\n<td>%s</td>\n<td>%s</td>\n<td>%s</td>\n</tr>' % (d[0], d[0], d[1], d[2], d[3]) +print'</table>\n</body>\n</html>' Property changes on: udd/web/cgi-bin/python_bugs.cgi ___________________________________________________________________ Added: svn:executable + * _______________________________________________ Collab-qa-commits mailing list [email protected] http://lists.alioth.debian.org/mailman/listinfo/collab-qa-commits
