Thank you for really fast answer. I don't want to bother you, but which connector should I use? I've just started with Python and I would like to use MySQL as well. Is here something working with Python 3? Thx
On 16 ún, 15:51, Michael Bayer <[email protected]> wrote: > I would say that that "yes" on our support page for py3k is a bug - Myconnpy > has never been tested with Py3k, and last I tested with Py2k there were still > a good deal of bugs. The ones I reported seem to have been fixed. This > below would appear to be a py3k specific bug and I would diagnose the issue > that mysql-connector python is returning the column names in > cursor.description as bytestrings and not unicode strings. That would be a > mysql-connectorpython bug. SQLAlchemy has a way of working around encodings > at that level but usually in py3k we hope to not have to use them. > > I'll see if i can create a test case for them and post. > > On Feb 16, 2012, at 9:22 AM, Ivan wrote: > > > > > > > > > Hello, I use SQLAlchemy 0.7.5, Python 3.2.2 and MySQL connector 0.3.2- > > devel (https://launchpad.net/myconnpy). Accordind to website, MySQL > > connector should be supported. But I get this exception: > > > Traceback (most recent call last): > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/pool.py", > > line 675, in _do_get > > return self._pool.get(wait, self._timeout) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/util/ > > queue.py", line 137, in get > > raise Empty > > sqlalchemy.util.queue.Empty > > > During handling of the above exception, another exception occurred: > > > Traceback (most recent call last): > > File "/home/ivan/diplomka/app/Pokus/pokusne/main.py", line 39, in > > <module> > > Base.metadata.create_all(engine) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/schema.py", > > line 2538, in create_all > > tables=tables) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 2232, in _run_visitor > > conn = self.contextual_connect(close_with_result=False) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 2342, in contextual_connect > > self.pool.connect(), > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/pool.py", > > line 210, in connect > > return _ConnectionFairy(self).checkout() > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/pool.py", > > line 371, in __init__ > > rec = self._connection_record = pool._do_get() > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/pool.py", > > line 697, in _do_get > > con = self._create_connection() > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/pool.py", > > line 174, in _create_connection > > return _ConnectionRecord(self) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/pool.py", > > line 259, in __init__ > > pool.dispatch.first_connect.exec_once(self.connection, self) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/event.py", > > line 262, in exec_once > > self(*args, **kw) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/event.py", > > line 271, in __call__ > > fn(*args, **kw) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > strategies.py", line 167, in first_connect > > dialect.initialize(c) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/dialects/ > > mysql/base.py", line 1891, in initialize > > default.DefaultDialect.initialize(self, connection) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > default.py", line 176, in initialize > > self._get_default_schema_name(connection) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/dialects/ > > mysql/base.py", line 1856, in _get_default_schema_name > > return connection.execute('SELECT DATABASE()').scalar() > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 1405, in execute > > params) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 1582, in _execute_text > > statement, parameters > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 1665, in _execute_context > > result = context.get_result_proxy() > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > default.py", line 634, in get_result_proxy > > return base.ResultProxy(self) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 2738, in __init__ > > self._init_metadata() > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 2745, in _init_metadata > > self._metadata = ResultMetaData(self, metadata) > > File "/usr/local/lib/python3.2/dist-packages/sqlalchemy/engine/ > > base.py", line 2608, in __init__ > > if keymap.setdefault(name.lower(), rec) is not rec: > > TypeError: unhashable type: 'bytearray' > > > Thank you for any help. > > > -- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group.> To post to this group, send email > > [email protected].> To unsubscribe from this group, send email > > [email protected]. > > For more options, visit this group > > athttp://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
