[Zope-DB] RE: ZPTs and database accesses
aaron at hypervision.com
Fri Apr 29 14:21:01 EDT 2005
Sql methods can do any type of database interaction, including inserts,
updates & deletes. You can find all kinds of documentation online about
how to do this. One example (using dtml) is here:
I suggest you re-read the zope database chapter, then look at some of
the code examples in zopelabs. You should also look at the Znolk SQL
Wizard from BlueDynamics.
One case where you would use an external method (python) would be
inserting blob data such as an image. Generally, you don't need to write
python for accessing text data.
Ken Winter wrote:
>>Date: Thu, 28 Apr 2005 23:48:58 +0200
>>From: Charlie Clark <charlie at egenix.com>
>>Subject: RE: [Zope-DB] ZPTs and database accesses
>>To: zope-db at zope.org
>>Message-ID: <20050428234858.60637.19 at bepc.1114682852.fake>
>>Content-Type: text/plain; charset="us-ascii"
>>On 2005-04-28 at 20:26:47 [+0200], Ken Winter <ken at sunward.org> wrote:
>>>Thanks for your answer. I'm relieved to know that the ZPT-ZSQL
>>>will suffice for database accesses. As a Zope neophyte, though, I still
>>>need an example or tutorial showing me how to get data from page to
>>>via ZPTs and ZSQL objects. Can you point me to such a reference?
>>Yes, the Zope book is the place to look.
>>You create a ZSQL method with the SQL code
>>You then call this method through your ZPT or better in the case of
>>from page to database a PythonScript which in turn calls the ZSQL method
>>passes the parameters.
>So, is it true that for posting (moving data from page to database) it's NOT
>possible to do this by a direct ZPT-to-ZSQL method call? - i.e. that it can
>ONLY be done via a Python script?
>I've been trying to figure out a way to do it directly, because it seemed
>that if possible that would be the simplest way. But if it's not possible,
>then I can stop wasting my time on that path and start learning to do it
>Zope-DB mailing list
>Zope-DB at zope.org
More information about the Zope-DB