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 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. > -- 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.
