OurSQL works more or less though I've had problems installing it on Py3K. I've also expressed frustration that there aren't any Py3K/Mysql drivers that aren't hosted on Launchpad, which I find to be an awkward interface.
On Feb 16, 2012, at 10:07 AM, Ivan wrote: > 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. > -- 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.
