[Zope-dev] Re: zope.sqlalchemy

[Laurence Rowe]

You need an svn checkout of SQLAlchemy until 0.4.6 is released.

Laurence

Andreas Jung wrote:
> 
> 
> --On 6. Mai 2008 06:01:14 +0200 Andreas Jung <lists at zopyx.com> wrote:
> 
>>
>>
>> --On 6. Mai 2008 02:26:58 +0100 Laurence Rowe <l at lrowe.co.uk> wrote:
>>
>>> Following discussions with Kapil, Christian and Martin I've developed
>>> zope.sqlalchemy. The aim is to provide a common base for transaction
>>> integration. It does not attempt to define any particular way to handle
>>> database configuration as there is not yet consensus on the best way to
>>> handle it.
> 
>>
>> Looks great (on the paper :-)). Trying to integrate it with
>> z3c.sqlalchemy over the weekend. Thanks Laurence.
> 
> I got a big stuck with the zope.sa integration in z3c.sa. Two tests of 
> my testsuite fail (likely related to a session.save() operation):
> 
> Error in test testXXMapperGetMapper 
> (z3c.sqlalchemy.tests.testSQLAlchemy.WrapperTests)
> Traceback (most recent call last):
>  File "/opt/python-2.4.4/lib/python2.4/unittest.py", line 260, in run
>    testMethod()
>  File 
> "/Users/ajung/sandboxes/z3c.sqlalchemy/lib/python/z3c/sqlalchemy/tests/testSQLAlchemy.py", 
> line 168, in testXXMapperGetMapper
>    user = session.query(User).filter_by(firstname='foo')[0]
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/SQLAlchemy-0.4.5-py2.4.egg/sqlalchemy/orm/query.py", 
> line 834, in __getitem__
>    return list(self[item:item+1])[0]
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/SQLAlchemy-0.4.5-py2.4.egg/sqlalchemy/orm/query.py", 
> line 925, in __iter__
>    self.session._autoflush()
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/SQLAlchemy-0.4.5-py2.4.egg/sqlalchemy/orm/session.py", 
> line 747, in _autoflush
>    self.flush()
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/SQLAlchemy-0.4.5-py2.4.egg/sqlalchemy/orm/session.py", 
> line 757, in flush
>    self.uow.flush(self, objects)
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/SQLAlchemy-0.4.5-py2.4.egg/sqlalchemy/orm/unitofwork.py", 
> line 236, in flush
>    session.extension.after_flush(session, flush_context)
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/zope.sqlalchemy-0.1dev_r86482-py2.4.egg/zope/sqlalchemy/datamanager.py", 
> line 187, in after_flush
>    invalidate(session)
>  File 
> "/opt/python-2.4.4/lib/python2.4/site-packages/zope.sqlalchemy-0.1dev_r86482-py2.4.egg/zope/sqlalchemy/datamanager.py", 
> line 170, in invalidate
>    assert _SESSION_STATE[id(session)] is not STATUS_READONLY
> KeyError: 32500656
> 
> The integration code follows your documentation;
> 
> <http://svn.zope.org/z3c.sqlalchemy/branches/zope.sqlalchemy-integration/src/z3c/sqlalchemy/base.py?rev=86543&view=auto> 
> 
> 
> And the tests are here:
> 
> <http://svn.zope.org/z3c.sqlalchemy/branches/zope.sqlalchemy-integration/src/z3c/sqlalchemy/tests/testSQLAlchemy.py?rev=86552&view=markup> 
> 
> 
> Any idea?
> 
> Andreas
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev at zope.org
> http://mail.zope.org/mailman/listinfo/zope-dev
> **  No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope )