[Zope] PoPy module

[jani]

Alexander N Gould wrote:
> 
> I'm trying to install the PoPy Python module on my Yellowdog Linux system
> (a redhat clone for PowerPC hardware).  I'm sure it's a simple task, but I
> don't know how to do it.  Any suggestions or tips?  Thanks in advance.
> 
> Building highways to reduce traffic is like loosening your belt to reduce
> obesity

First make sure that pyton-devel is installed on your system. 
It's available at www.python.org I think.

Untar PoPy-1.1.tar.gz and ZPoPyDA-0.3.tar.gz .
First you have to build PoPy. 
On my system I had to modify the lib and include path in Setup and
in PoPymodule.c

Setup:
*shared*
PoPy PoPymodule.c -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -lpr

PoPymodule.c:
...
#include <libpq-fe.h>
#include <libpq/libpq-fs.h>
...

Go on with:
make -f Makefile.pre.in boot
make

You should now have the shared library PoPymodule.so .
Copy this file to python1.5/site-packages on your system.

Now you have to install zope-popyda-0.3
"make install" will place the Zope product to
/usr/lib/zope/lib/python/Products/ZPoPyDA

Just move it to the Product folder of your Zope installation.
Restart Zope and it should work ;-)

Take a look at the README. It describes the format of the connection
string.
It's different from that of PyGreSQLDA!
Also make sure that you hav set proper permissions on
&PGDATA/pg_hba.conf

BTW after i recognized some problems using PoPy I switched back to
PyGreSQLDA.
1. When I try to connect to postgres 6.4 using PoPy the connect fails
   postgres.log: ERROR: parser: parse error at or near "transaction"

2. Whether Auto-commit mode is on or off on ZPoPyDA  the new postgres
7.0 syntax 
 "select * from foo limit 20 offset 10" returns all records of foo and
not only 20 !
  With PyGreSQLDA it works :-)

-- 
_________________________________________________________
Andreas Heckel                            andreas@aHIT.de