[Zope] Non-query SQL with Zope (naive question)

Bruce Elrick belrick@saltus.ab.ca
Mon, 23 Aug 1999 22:15:54 -0600


Hi all...

I'm just discovering Zope, have installed v1.10.3 on Linux, am using Zserver
for the http server, and am using PostGreSQL with ZPyGreSQLDA.

I was happily developing my web site, including creating queries of a
PostGres DB, when I found that I could not create insert, update, or
deletion SQL commands.

The docs support this fact, but I can't believe that people have not
wanted to do more SQL beyond just querying.  I'm guessing that I could write
some Python extensions to do that sort of thing, but I'm not a Python
programmer and I have to believe that someone else wants to do this and is
working on it already.  I imagine the features of the SQLMethods included
with Zope would be as useful in non-query SQL as they are in querying.

I haven't delved into v2 and the ZClasses that are available there.  Looking
at the contributed Products for v1 on the Zope site, I could not see anything
that addressed this.  
Update: I found sqlinputwix1.0.tar.gz, which from the name I can only hope is
what I want, but it is MySQL only.  I haven't tried setting up a MySQL DB just
to see what functionality is provided by this Product.

How do people make full-fledged web applications with DB back ends using Zope?
Or do they even try?

How does one get information about the contributed Products without actually
installing and tryinig them out?

Cheers...
Bruce
--
Bruce Elrick, Ph.D.                       Saltus Technology Consulting Group
Cell:     (403) 870-4429
Personal: belrick@home.com                          IBM Certified Specialist
Business: belrick@saltus.ab.ca          ADSM, AIX Support, RS/6000 SP, HACMP