[Zope] Newbie questions

[Dieter Maurer]

fowlertrainer at anonym.hu wrote at 2003-12-1 10:38 +0100:
 > 1.)
 >  I cannot show results of Z-SQL method.
 > 
 >  I see the examples on web, on tutorial, but...
 > 
 >  ZSQL method name: testgroup.
 > ...
 >  But no result.
 > ... in template ...

Add a "Z Search Interface" for your Z SQL Method (via the "Add list").
Adjust the generated "report page" as needed.

Note that the batching links for the generated ZPT "report page" 
are broken. I posted a patch to the mailing list (may be a bit
difficult to find; search for "url_query").

 > 2.)
 >  I want to process the result of zsql query under PythonScript (select
 >  * from xxx).

Please read the respective chapter in the Zope Book (online 2.6 edition).

 > 3.)
 >  There is an (K)InterBase Connection.
 >  I want to access the IB specials.
 > 
 >  These are:
 >         - start transaction/Commit/Rollback, more if possible

This is done automatically for you (transactions are tied to
Zope's requests).

 >         - call stored procs

Many DA's support a "callproc" method. Check whether your DA
belongs to this class.

 >         - set the transactions isolation level

The default set by the DA should be "serialized".

I fear, you will need to change its code when you want something
else.

 > 4.)
 >  If there are two requests in zope, and the scripts are have
 >  use (K)InterBase Connection, that the connection object is
 >  duplicated ?
 >  The ZSQL method objects are duplicated also ?
 >  So: the requests' processes are separated ?

The DA authors should handle this for you such that
you do not need to worry about these details...

 > 5.)

Note: it is *much* better to send several small messages
(each with a well chosen "Subject) than a huge message with
dozens of questions.

I am going to loose patience....

 >  I wan to log in users under zope just like php.
 >  This is the logical scheme (pseudo):

Usually, Zope DA's do not support this (as connections are
often expensive and most databases only allow authentication
when the connection is opened).

 > 6.)
 >  Under Zope I how to create/set an variable in PyScript what useable
 >  in DTML ? So how to set more DTML variables under PyScript ?
 >  (example: dtml_username='xxx'; dtml_func="8"; etc.)

You can set request variables (with the request's "set" method).
But, it is not very good style.

 > 7.)
 >  If I write this:
 >   <dtml-var expr="myzsqlmethod">
 > 
 >   I get all of results of the method ?

No, you get none at all.

What you get is the Z SQL Method object itself.
The context will probably coerce it into a string and the result
looks like "<ZSQLMethod at 0xfdfdff>".
Your browser will not understand this funny tag and ignore it.

 > 8.)
 >  What is the ZSQL method caching (1000 row)?

You must read more carefully!

It says:

  *  "Maximum rows to retrieve": this limits the number of rows retrieved
     from the database (per request).

     Use "0" for unlimited

  *  "Maximum results to cache": this limits the number of query results
     (i.e. calls of the ZSQL Method) held in the cache

  *  "Maximum time (sec) to cache": this limits the time a single
     result is held in the cache.


 > 9.)
 >  How to I import XML file ?
 >  I export my zope folder in home. I want to use another site.
 >  But I cannot do import.
 >  I try with these variations:
 > 
 >    c:\test.xml
 >    file://localhost/C:/test.xml

Please read the Zope Book!  Carefully, if you already did!

For security reasons, files are only imported from Zope's "import" folder...

-- 
Dieter