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