<br>Hi<br>Welcome everyone! <br>At the beginning I would like to remark that I'm new to Python and Storm.<br><br>I'm working with python & storm installed on Ubuntu 8.04<br>I have installed strom from Ubuntu repositories.<br>
Python 2.5.2 and I think Storm version is 0.12<br><br><br>First of all I'm unable to load storm.tracer module:<br> from storm.tracer import debug:<br> ImportError: No module named tracer<br>But probably this is an issue for ubuntu team and I can leave without it for now.<br>
<br>The second issue more important.<br>I wanted to use Storm with existing mysql database and one of the columns names is: 'long' which is also sql kyeword.<br>So every time in my queries I have to escape colums names like for example: SELECT ... WHERE `long` = 100.<br>
And I think Strom doesn't escape columns names so it's completely useless for me :(<br><br>My question is: it's a Storm bug or I miss something ?<br>Below you can find my sample Traceback when I wanted to update 'long' column.<br>
For other columns it works.<br><br>Regards<br>Peter<br><br>Traceback (most recent call last):<br> File "<stdin>", line 1, in <module><br> File "/usr/lib/python2.5/site-packages/storm/store.py", line 105, in commit<br>
self.flush()<br> File "/usr/lib/python2.5/site-packages/storm/store.py", line 443, in flush<br> self._flush_one(obj_info)<br> File "/usr/lib/python2.5/site-packages/storm/store.py", line 502, in _flush_one<br>
self._connection.execute(expr, noresult=True)<br> File "/usr/lib/python2.5/site-packages/storm/database.py", line 202, in execute<br> self.raw_execute, statement, params)<br> File "/usr/lib/python2.5/site-packages/storm/database.py", line 317, in _check_disconnect<br>
return function(*args, **kwargs)<br> File "/usr/lib/python2.5/site-packages/storm/database.py", line 283, in raw_execute<br> raw_cursor.execute(statement, params)<br> File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in execute<br>
self.errorhandler(self, exc, value)<br> File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35, in defaulterrorhandler<br> raise errorclass, errorvalue<br>_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'long=100 WHERE giata_hotel.giata_id = 2' at line 1")<br>