bug confirmed and reported: https://bugs.launchpad.net/myconnpy/+bug/933512
On Feb 16, 2012, at 9:51 AM, Michael Bayer 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 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. > -- 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.
