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 <[EMAIL PROTECTED]> wrote:
--On 6. Mai 2008 02:26:58 +0100 Laurence Rowe <[EMAIL PROTECTED]> 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 - [email protected]
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 )
_______________________________________________
Zope-Dev maillist - [email protected]
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 )