[storm] can i supress mysql warnings from reaching the terminal ?

shawn bright nephish at gmail.com
Tue Jul 31 20:02:46 BST 2007


hello there friends,

i have a weird sort order i am trying to pull off, it works, but pipes a lot
of junk to my terminal, and makes it hard to find debugging lines that i
have in my stuff ( every minute this can happen a few hundred times )

here is the query
sql = "select `id` from `sites` where `group_id` = '16'  order by
cast(`site_name` as unsigned), `site_name` "
store.execute(sql)

here is what i get:
/usr/lib/python2.4/site-packages/storm-0.9-py2.4.egg/storm/database.py:120:
Warning: Truncated incorrect INTEGER value: '6W'
/usr/lib/python2.4/site-packages/storm-0.9-py2.4.egg/storm/database.py:120:
Warning: Truncated incorrect INTEGER value: '1B'

now, it still works. I am able to use the objects that i have selected, even
though mysql doesn't like how i have sorted them.
Also, i know this is not a storm issue, because i was getting the same thing
with just the python-mysqldb module.

However, i would like it a lot if i could suppress these messages from going
to my terminal.

any tips would be appreciated.

thanks

shawn
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/storm/attachments/20070731/cb3b3759/attachment.htm 


More information about the storm mailing list