ascii-encoded string:
>>> url = 'mysql://login:[EMAIL PROTECTED]/adverts?charset=cp1251'
>>> engine = sqlalchemy.create_engine(url, convert_unicode=True, pool_recycle=4)
>>> metadata = sqlalchemy.BoundMetaData(engine)
>>> ad_table = sqlalchemy.Table('adverts', metadata, autoload=True)
>>>
unicode string:
>>> url = u'mysql://login:[EMAIL PROTECTED]/adverts?charset=cp1251'
>>> engine = sqlalchemy.create_engine(url, convert_unicode=True, pool_recycle=4)
>>> metadata = sqlalchemy.BoundMetaData(engine)
>>> ad_table = sqlalchemy.Table('adverts', metadata, autoload=True)
Traceback (most recent call last):
File "<interactive input>", line 1, in ?
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\schema.py", line
167, in __call__
metadata.get_engine().reflecttable(table)
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\engine\base.py",
line 754, in reflecttable
conn = self.contextual_connect()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\engine\base.py",
line 748, in contextual_connect
return Connection(self, close_with_result=close_with_result,
**kwargs)
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\engine\base.py",
line 374, in __init__
self.__connection = connection or engine.raw_connection()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\engine\base.py",
line 769, in raw_connection
return self.connection_provider.get_connection()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\engine
\default.py", line 19, in get_connection
return self._pool.connect()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
147, in connect
return _ConnectionFairy(self).checkout()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
232, in __init__
self._connection_record = pool.get()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
160, in get
return self.do_get()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
429, in do_get
con = self.create_connection()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
143, in create_connection
return _ConnectionRecord(self)
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
180, in __init__
self.connection = self.__connect()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\pool.py", line
210, in __connect
connection = self.__pool._creator()
File "c:\python24\develop\sqlalchemy\lib\sqlalchemy\engine
\strategies.py", line 71, in connect
raise exceptions.DBAPIError("Connection failed", e)
DBAPIError: (Connection failed) (TypeError) Connect() keywords must be
strings
>>>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
