I have no idea what I'm doing wrong, but I can't get sqlalchemy working
with MySQL and PyMySQL driver. The driver works with my db. But SQLAlchemy
blows with traceback. Any hints, please?
Here is testing script:
#!/usr/bin/python3
import sys
print('sys.version: %s' % sys.version)
import pymysql
print('pymysql version: %s' % repr(pymysql.VERSION))
conn = pymysql.connect(host='127.0.0.1', port=3306, user='root',
passwd='root', database='mydb')
cur = conn.cursor()
cur.execute("SELECT * FROM users")
for row in cur:
print(row)
cur.close()
conn.close()
import sqlalchemy
print('sqlalchemy version: %s' % sqlalchemy.__version__)
engine =
sqlalchemy.create_engine('mysql+pymysql://root:root@127.0.0.1:3306/mydb')
engine.connect()
#--------------------------------------------------------------
And here is what I got:
sys.version: 3.3.3 (v3.3.3:c3896275c0f6, Nov 18 2013, 21:18:40) [MSC v.1600
32 bit (Intel)]
pymysql version: (0, 6, 1, None)
(1, 'al...@wonderland.com', 1)
sqlalchemy version: 0.9.2
Traceback (most recent call last):
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 913, in _do_get
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\util\queue.py",
line 158, in get
available, else raise the Empty exception ('timeout' is ignored
sqlalchemy.util.queue.Empty
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\work\db-wrapper\alchemy\test-connect.py", line 21, in <module>
engine.connect()
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\engine\base.py",
line 1678, in connect
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\engine\base.py",
line 59, in __init__
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\engine\base.py",
line 1747, in raw_connection
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 272, in unique_connection
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 608, in _checkout
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 425, in checkout
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 928, in _do_get
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 277, in _create_connection
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\pool.py",
line 401, in __init__
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\event\attr.py",
line 238, in exec_once
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\event\attr.py",
line 247, in __call__
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\util\langhelpers.py",
line 1180, in go
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\engine\strategies.py",
line 166, in first_connect
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\dialects\mysql\base.py",
line 2199, in initialize
File
"C:\Python33\lib\site-packages\sqlalchemy-0.9.2-py3.3.egg\sqlalchemy\connectors\mysqldb.py",
line 133, in _detect_charset
TypeError: unorderable types: NoneType() < tuple()
[Finished in 1.2s with exit code 1]
Alexander
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
