Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #7721

Re: Trapping MySQLdb warnings

References <20110616015837.GA1885@johnsons-web.com>
Date 2011-06-15 19:03 -0700
Subject Re: Trapping MySQLdb warnings
From geremy condra <debatem1@gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.10.1308189796.1164.python-list@python.org> (permalink)

Show all headers | View raw


On Wed, Jun 15, 2011 at 6:58 PM, Tim Johnson <tim@johnsons-web.com> 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.
>
> In the past I have used _mysql_exceptions.Warning, but that approach
> is not working in this case.
>
> My cursor is created with the relevant following code:
>
> ## connection object
> self.__conn = MySQLdb.connect(db = self.__db,
>  host = self.__host, user = self.__user,
>  passwd = self.__passwd)
>
> ## cursor object
> self.__rdb = self.__conn.cursor()
> ## And implemented as :
> try :
>    self.__rdb.execute(S)
> except _mysql_exceptions.Warning,e:
>    raise e ## replace with log(e)
>
> What else needs to be done?

Have you tried http://docs.python.org/library/warnings.html#temporarily-suppressing-warnings
?

Geremy Condra

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: Trapping MySQLdb warnings geremy condra <debatem1@gmail.com> - 2011-06-15 19:03 -0700

csiph-web