Bug#941470: Too old version of zope.sqlalchemy

[jarek]

Package: python-zope.sqlalchemy
Version: 0.6.1-2

Version of zope.sqlalchemy in buster is incompatible with sqlalchemy in
some way:

Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/tukanweb-2.0-
py2.7.egg/myapp/users_view.py", line 63, in login_view
    user = DBSession.query(User).filter(User.login == userId).first()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2979, in first
    ret = list(self[0:1])
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
2771, in __getitem__
    return list(res)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
3081, in __iter__
    return self._execute_and_instances(context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
3103, in _execute_and_instances
    querycontext, self._connection_from_session, close_with_result=True
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
3111, in _get_bind_args
    mapper=self._bind_mapper(), clause=querycontext.statement, **kw
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line
3096, in _connection_from_session
    conn = self.session.connection(**kw)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
line 1120, in connection
    execution_options=execution_options,
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
line 1126, in _connection_for_bind
    engine, execution_options
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py",
line 441, in _connection_for_bind
    self.session.dispatch.after_begin(self.session, self, conn)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/event/attr.py",
line 297, in __call__
    fn(*args, **kw)
  File "/usr/lib/python2.7/dist-
packages/zope/sqlalchemy/datamanager.py", line 222, in after_begin
    join_transaction(session, self.initial_state,
self.transaction_manager)
  File "/usr/lib/python2.7/dist-
packages/zope/sqlalchemy/datamanager.py", line 199, in join_transaction
    transaction_manager.get().join(DataManager(session, initial_state,
transaction_manager))
  File "/usr/lib/python2.7/dist-
packages/zope/sqlalchemy/datamanager.py", line 67, in __init__
    self.tx = session.transaction._iterate_parents()[-1]
AttributeError: 'SessionTransaction' object has no attribute
'_iterate_parents'

Upgrade  of zope.sqlalchemy to zope.sqlalchemy-1.1 fixes the problem.

The problem is decribed here:
https://github.com/zopefoundation/zope.sqlalchemy/issues/15

It looks that zope.sqlalchemy have to be in version at least 0.7.7 to
work with sqlalchemy >= 1.1

Debian Buster 10.1, 
Linux debian10 4.19.0-6-amd64 #1 SMP Debian 4.19.67-2+deb10u1 (2019-09-
20) x86_64 GNU/Linux
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-zope-developers/attachments/20191001/6d10b213/attachment.html>