Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!selfless.tophat.at!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.000 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'wed,': 0.03; 'context': 0.04; 'warnings': 0.05; 'terry': 0.07; 'python': 0.08; '>>>>': 0.09; 'exception.': 0.09; 'exceptions': 0.09; 'linux.': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:80.91.229.12': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'received:lo.gmane.org': 0.09; 'substitute': 0.09; 'pm,': 0.10; '>>>': 0.12; 'am,': 0.14; 'wrote:': 0.14; 'objects?': 0.16; 'reedy': 0.16; 'class,': 0.16; 'looked': 0.16; 'jan': 0.20; 'header:In-Reply-To:1': 0.21; 'unsure': 0.23; 'there.': 0.25; 'tried': 0.27; 'class': 0.29; 'module': 0.30; 'url:library': 0.31; 'properly': 0.32; 'header:X -Complaints-To:1': 0.32; 'to:addr:python-list': 0.33; 'header :User-Agent:1': 0.35; 'instances': 0.35; 'using': 0.35; 'log': 0.36; '(to': 0.37; 'url:docs': 0.37; 'url:python': 0.38; 'received:org': 0.38; 'url:org': 0.38; 'but': 0.38; 'docs': 0.38; 'subject:: ': 0.38; 'skip:s 20': 0.39; 'should': 0.39; 'johnson': 0.39; 'printed': 0.39; 'header:Mime-Version:1': 0.39; 'to:addr:python.org': 0.39; 'getting': 0.40; 'manager,': 0.63; 'warning.': 0.84 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Terry Reedy Subject: Re: Trapping MySQLdb warnings Date: Thu, 16 Jun 2011 14:47:44 -0400 References: <20110616015837.GA1885@johnsons-web.com> <20110616023829.GB1885@johnsons-web.com> <20110616155533.GD1885@johnsons-web.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: rain.gmane.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10 In-Reply-To: <20110616155533.GD1885@johnsons-web.com> X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 34 NNTP-Posting-Host: 82.94.164.166 X-Trace: 1308250082 news.xs4all.nl 49180 [::ffff:82.94.164.166]:59627 X-Complaints-To: abuse@xs4all.nl Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:7759 On 6/16/2011 11:55 AM, Tim Johnson wrote: > * Tim Johnson [110615 18:53]: >> * geremy condra [110615 18:03]: >>> On Wed, Jun 15, 2011 at 6:58 PM, Tim Johnson wrote: >>>> Using Python 2.6.5 on linux. >>>> >>>> When using MySQLdb I am getting warnings printed to stdout, but I would >>>> like to trap, display and log those warnings. >> <.....> The machinery in the warnings module is only for instances of subsclasses of Warning. Are the warnings from MySQLdb properly such objects? If so, what class are they? >>> Have you tried http://docs.python.org/library/warnings.html#temporarily-suppressing-warnings >> Hi Geremy: >> I just looked at the docs there. This is a new module (to me), and >> I am unsure of the implementation or whether this is what I should >> use. >> I tried the following : >> try : >> self.__rdb.execute(S) >> except warnings.catch_warnings: warnings.catch_warnings is a context manager, not an exception. This is a TypeError in 3.x, which requires that exceptions be instances of BaseException. Try except warnings.Warning, warn: Substitute specific MySQLdb warning class, whatever it is, for Warning. -- Terry Jan Reedy