Re: Using SQLAlchemy with Plone/Zope

--On 16. Mai 2008 08:58:38 -0700 Mike <kyosohma <at> gmail.com> wrote:

>
> Hi,
>
> We are using SQLAlchemy 4.X in Zope using SQLAlchemyDA, found here:
>
> http://opensource.zopyx.com/projects/SQLAlchemyDA
>
> This uses SA 0.4.0. We are connecting to MS SQL 2000. While this works
> in Zope for normal SQL commands, if we try to execute a stored
> procedure, we get the following traceback:
>
>
> [Traceback (most recent call last):
>   File "sqltest.py", line 14, in ?
>     print cur.fetchall()
>   File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/
> SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1231, in
> __repr__
>     return repr(tuple(self))
>   File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/
> SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1223, in
> __iter__
>     yield self.__parent._get_col(self.__row, i)
>   File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/
> SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1468, in
> _get_col
>     rec = self._key_cache[key]
> AttributeError: 'ResultProxy' object has no attribute '_key_cache'
>
>
> I'm not sure how to go about troubleshooting this.

You're basically on the wrong list. This issue belong on the SQLAlchemy 
mailing list. There is no indication for a anything related to Zope.

> Would upgrading it
> to SQLAlchemy 0.4.5 fix it?

Try it out yourself and see what's happening. Nobody know about your 
particular setup, code etc. - but you do.

Andreas