[Zope3-Users] Re: sqlobject and psycopg

[Philipp von Weitershausen]

Luca Manini wrote:
> Hi, 
> 
> I have some simple Python classes that use SQLObject and PostgreSQL
> for persistence (both from Debian unstable).
> 
> I'm trying to integrate those classe in a module I'm writing for Zope
> 3 (Zope 3 from svn).
> 
> The first thing I've tried is to make a folderish class with a view
> that list the instances of my class.
> 
> Getting the instances is very easy from plain Python as class
> SQLObject has two methods setConnection() and select() that do the
> job.
> 
> My problem is that the very same code does not work from Zope. I get a
> traceback like this:
> 

I'm not sure how to interpret that error of yours. All I can suggest, 
just like Tom, is using Sidnei's SQLObject support package 'sqlos', 
available at http://codespeak.net/z3/sqlos.

You can check out the latest version using a subversion client:

   svn co http://codespeak.net/svn/z3/sqlos/trunk sqlos

Notice that the psycopg database adapter that is being talked about in 
the docs is now hosted at svn.zope.org. You can either check it out from 
there anonymously or download a released tarball from 
http://zope.org/Products/Zope3-Packages/psycopgda/view.

Hope that helps,

Philipp