Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #7765
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail |
|---|---|
| Return-Path | <tim@johnsons-web.com> |
| X-Original-To | python-list@python.org |
| Delivered-To | python-list@mail.python.org |
| X-Spam-Status | OK 0.010 |
| X-Spam-Evidence | '*H*': 0.98; '*S*': 0.00; 'warnings': 0.05; 'srinivas': 0.07; 'finally:': 0.09; 'received:64.4': 0.09; 'tim,': 0.09; 'def': 0.12; 'error:': 0.12; '*very*': 0.16; 'conn.close()': 0.16; 'error)': 0.16; 'header:In-Reply-To:1': 0.21; 'code.': 0.22; 'do,': 0.25; 'statement': 0.26; 'thanks': 0.28; 'import': 0.29; 'least': 0.30; 'sort': 0.31; 'to:addr:python-list': 0.33; 'post': 0.33; 'header:User-Agent:1': 0.35; 'try:': 0.35; 'charset:us- ascii': 0.36; 'query': 0.37; 'problem.': 0.38; 'but': 0.38; 'subject:: ': 0.38; 'some': 0.38; 'got': 0.39; 'to:addr:python.org': 0.39; 'hope': 0.60; 'back': 0.63; 'tour': 0.82; 'yeah!': 0.84 |
| Date | Thu, 16 Jun 2011 11:41:39 -0800 |
| From | Tim Johnson <tim@johnsons-web.com> |
| To | python-list@python.org |
| Subject | Re: Trapping MySQLdb warnings |
| References | <20110616015837.GA1885@johnsons-web.com> <BANLkTint8YP9W7hUnvYh4nmMo_6h0WPXTA@mail.gmail.com> <20110616023829.GB1885@johnsons-web.com> <20110616155533.GD1885@johnsons-web.com> <BANLkTikjEtmRtnqQnnCHUkc1DL7QuRKm9g@mail.gmail.com> |
| MIME-Version | 1.0 |
| Content-Type | text/plain; charset=us-ascii |
| Content-Disposition | inline |
| In-Reply-To | <BANLkTikjEtmRtnqQnnCHUkc1DL7QuRKm9g@mail.gmail.com> |
| Organization | AkWebsoft |
| User-Agent | Mutt/1.5.20 (2009-06-14) |
| X-BeenThere | python-list@python.org |
| X-Mailman-Version | 2.1.12 |
| Precedence | list |
| List-Id | General discussion list for the Python programming language <python-list.python.org> |
| List-Unsubscribe | <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe> |
| List-Archive | <http://mail.python.org/pipermail/python-list> |
| List-Post | <mailto:python-list@python.org> |
| List-Help | <mailto:python-list-request@python.org?subject=help> |
| List-Subscribe | <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.39.1308253297.1164.python-list@python.org> (permalink) |
| Lines | 37 |
| NNTP-Posting-Host | 82.94.164.166 |
| X-Trace | 1308253297 news.xs4all.nl 49041 [::ffff:82.94.164.166]:32932 |
| X-Complaints-To | abuse@xs4all.nl |
| Xref | x330-a1.tempe.blueboxinc.net comp.lang.python:7765 |
Show key headers only | View raw
* srinivas hn <hnsri49@gmail.com> [110616 11:06]:
> Hi Tim,
>
> Use this method it will sort tour problem.
>
> def do_query(insert_query):
> import warnings
>
> with warnings.catch_warnings():
> warnings.simplefilter('error', MySQLdb.Warning)
> try:
> cursor.execute(insert_query)
> conn.commit()
> return 'Success'
> except MySQLdb.Error, error:
> logging.error("Error in insertion %s query is ", error)
> return 'Failure'
> finally:
> conn.close()
>
>
> try:
> xyz = do_query(insert_query)
> except MySQLdb.Warning, warning:
> logging.warning(warning)
>
>
> you need to use the with statement and then you need to catch the warnings
> hope it helps
Yeah!
Got some tweaking to do, but will post back again on working code.
At least I am now raising errors.
thanks *very* much.
--
Tim
tim at johnsons-web dot com or akwebsoft dot com
http://www.akwebsoft.com
Back to comp.lang.python | Previous | Next | Find similar | Unroll thread
Re: Trapping MySQLdb warnings Tim Johnson <tim@johnsons-web.com> - 2011-06-16 11:41 -0800
csiph-web