Because of the problems with a Sybase SA backend on both python-sybase and pyodbc, I changed the poolclass to AssertionPool and found a bunch of unexpected (to me) situations where AssertionPool failed. Based on a casual examination of the code, it seems that one connection should be sufficient most of the tests (apart, of course, from the ones that test multiple connections). Is this assumption correct?
pjjH ====================================================================== FAIL: test_create_drop_bound (__main__.BindTest) ---------------------------------------------------------------------- Traceback (most recent call last): File "/u/harringp/work/open_source/sqlalchemy/test/testlib/ testing.py", line 387, in safe return fn(*args, **kw) File "test/engine/bind.py", line 109, in test_create_drop_bound metadata.create_all() File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/ schema.py", line 1765, in create_all bind.create(self, checkfirst=checkfirst, tables=tables) File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 1129, in create self._run_visitor(self.dialect.schemagenerator, entity, connection=connection, **kwargs) File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 1154, in _run_visitor conn = self.contextual_connect(close_with_result=False) File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/engine/ base.py", line 1229, in contextual_connect return self.Connection(self, self.pool.connect(), close_with_result=close_with_result, **kwargs) File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/ pool.py", line 142, in connect return _ConnectionFairy(self).checkout() File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/ pool.py", line 304, in __init__ rec = self._connection_record = pool.get() File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/ pool.py", line 161, in get return self.do_get() File "/u/harringp/work/open_source/sqlalchemy/lib/sqlalchemy/ pool.py", line 839, in do_get assert self.connection is not None AssertionError --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---