- Zope - Zope lists

RE: [Zope] PythonScripts and REQUEST, RESPONSE objects
by Mayers, Philip J 08 Mar '01

08 Mar '01

Odd... a) Try: print dtml_method(context,context.REQUEST) If validate is in the REQUEST namespace, then context alone won't help. Context just contains the acquisition tree. b) is expected and normal behaviour. c) context contains the acquisition tree (folder path) so if the DTML method references anything else in the Zope hierarchy (other methods, headers, etc) then not passing context will fail, as you've seen. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Stefan H. Holek [mailto:stefan@epy.co.at] Sent: 08 March 2001 16:27 To: Mayers, Philip J; 'Wolfgang Strobl'; 'zope(a)zope.org' Subject: RE: [Zope] PythonScripts and REQUEST, RESPONSE objects Sorry Phil, this does not work for me in several ways: a) when I call any DTML Method from a Python Script with 'context' as the first parameter, I immediatley get Error Type: AttributeError Error Value: validate from the __call__ b) I have to use print context.blahblah( _.None, _ ) return printed to have anything output at all, and c) the called DTML Method does not aquire anything (possibly because I pass _.None) Duh! I must be doing something wrong then... Stefan -- Things work better when plugged in. --On Donnerstag, 08. März 2001 11:20 +0000 "Mayers, Philip J" <p.mayers(a)ic.ac.uk> wrote: > context.standard_html_{header,footer}(context,REQUEST) > > Or, if "_" is bound (called from DTML): > > context.standard_html_{header,footer}(context,_) > > Could this please go in the manual and Zope book? > > Regards, > Phil > > +----------------------------------+ > | Phil Mayers, Network Support | > | Centre for Computing Services | > | Imperial College | > +----------------------------------+ > > -----Original Message----- > From: Wolfgang Strobl [mailto:ws@gmd.de] > Sent: 08 March 2001 10:49 > To: zope(a)zope.org > Subject: Re: [Zope] PythonScripts and REQUEST, RESPONSE objects > > > On 8 Mar 2001, 9:26 Chris Withers wrote: > >> > after line 124 in Pythonscript.py. Now each time I add a new >> > PythonScript object, it starts with >> > >> > from Products.PythonScripts.standard import html_quote >> > REQUEST = context.REQUEST >> > RESPONSE = context.REQUEST.RESPONSE >> >> Can you stick that in the Collector as a 'Feature w/patch'? > > Done. In addition as an afterhought, I suggested adding two > additional lines > > print "This is Script (Python) ",script.getId(),"("+script.title+") at > ",container.absolute_url() > return printed > > in analogy to the default content of DTML Methods. > > Btw, what's the correct way of rendering the default > standard_html_header/footer from within a Python script? > > -- > o ( Wolfgang.Strobl(a)gmd.de (+49 2241) 14-2394 > /\ * GMD mbH #include > _`\ `_<=== Schloss Birlinghoven, <std.disclaimer> > __(_)/_(_)___.-._ 53754 Sankt Augustin, Germany ________________ > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

RE: [Zope] PythonScripts and REQUEST, RESPONSE objects
by Mayers, Philip J 08 Mar '01

08 Mar '01

context.standard_html_{header,footer}(context,REQUEST) Or, if "_" is bound (called from DTML): context.standard_html_{header,footer}(context,_) Could this please go in the manual and Zope book? Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Wolfgang Strobl [mailto:ws@gmd.de] Sent: 08 March 2001 10:49 To: zope(a)zope.org Subject: Re: [Zope] PythonScripts and REQUEST, RESPONSE objects On 8 Mar 2001, 9:26 Chris Withers wrote: > > after line 124 in Pythonscript.py. Now each time I add a new > > PythonScript object, it starts with > > > > from Products.PythonScripts.standard import html_quote > > REQUEST = context.REQUEST > > RESPONSE = context.REQUEST.RESPONSE > > Can you stick that in the Collector as a 'Feature w/patch'? Done. In addition as an afterhought, I suggested adding two additional lines print "This is Script (Python) ",script.getId(),"("+script.title+") at ",container.absolute_url() return printed in analogy to the default content of DTML Methods. Btw, what's the correct way of rendering the default standard_html_header/footer from within a Python script? -- o ( Wolfgang.Strobl(a)gmd.de (+49 2241) 14-2394 /\ * GMD mbH #include _`\ `_<=== Schloss Birlinghoven, <std.disclaimer> __(_)/_(_)___.-._ 53754 Sankt Augustin, Germany ________________ _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

3 2

Re: [Zope] SQLTEST is case insensitive?
by Dieter Maurer 08 Mar '01

08 Mar '01

FThe Doctor What writes: > The problem is two fold: > 1) ID = 1 should be "ID" = 1 so that PostgreSQL will treat it as a > case sensitive string. This was discussed some time ago (--> list archives). Changing "dtml-sqltest" to enclose the column name in double quotes would break lots of code (as many people rely on the case insensitive interpretation). > 2) ID = 1 should really be "URL"."ID", but I can't figure out how to > pass that through sqltest! You know the "column" argument to "dtml-sqltest". It can be used to provide an alternativ column name. The quotes will make difficulties, however, as they would be interpreted as DTML syntax. You can use vanilla DTML to emulate "dtml-sqltest" like for example: .... "URL"."ID" = '<dtml-var ID sql_quote>' .... Dieter

2 1

RE: [Zope] Reloading a page.
by Schmidt, Allen J. 08 Mar '01

08 Mar '01

Could this same thing be used to stop a proxy server from caching a page? We have a dtml method (that calls a ZSQL method) that is stuck in someone's proxy server and hits the page once every minute all day long. The resulting query that is showing up in our HitBox listing is for a DB category that is not even in the DB anymore but it keeps executing the same URL. Any ideas? Thanks Allen -----Original Message----- From: Casey Duncan [mailto:cduncan@kaivo.com] Sent: Thursday, March 08, 2001 10:11 AM To: Daniel Corrêa de Azevedo Cc: 'zope(a)zope.org' Subject: Re: [Zope] Reloading a page. Daniel Corrêa de Azevedo wrote: > > Whatz up, guys? > > Well, I´m having problems in reloading a page that shows information > contained in a table of a database. > The problem is that whenever I include some data in the database at > another page it send´s me back to that page that shows information, it > doens´t show the update, but a cached page. I´m using the IE 5.0 and I > haven´t figured out how to reload it every time without changing the > configuration of the browser. > I´ve tryed the same code that I´m using in IE 5.0 in IE 5.5 and > this problem doens´t happen. > Hope that you all could give me some help. > Thank´s, > Daniel C. Azevedo > Try putting this in the head of your standard_html_header: <dtml-if no_cache> <META HTTP-EQUIV="pragma" CONTENT="no-cache"> </dtml-if no_cache> Then set a boolean property on the DTML Document (or folder if it's a method) called "no_cache". This should prevent the browser from caching the page. -- | Casey Duncan | Kaivo, Inc. | cduncan(a)kaivo.com `------------------> _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

LoginManager form-based login and <dtml-raise "LoginRequired">
by Gerald Gutierrez 08 Mar '01

08 Mar '01

In my continuing quest to get LoginManager working for me, I've found that the loginForm needs to be wrapped with a <dtml-raise> tag before it'll display. If not, the basic authentication dialog box pops up. The <dtml-raise> tag seems to cause a stack trace to be displayed along with the login form. I cannot seem to get rid of it no matter what I do. I must have it not show up because my application uses WML and the <pre> tag is not a part of WML (and it'll make the page exceeded the maximum size of the page anyway). The source to LoginManager seems to just "call" acl_users.loginForm() and expect that it raises an exception in order to display a page to the user. Does this mean that there is no way around not displaying the stack trace to the user? Thanks.

2 1

ZMysql and MysqlDB
by Olaf Marc Zanger 08 Mar '01

08 Mar '01

hi there, i had a zope 2.3 installation under suse 7.0 (python 1.5.2) running wonderfully with connection to mysql (don't know the version anymore) now i installed the same mysql-data,. zope-data on suse 7.1. with mysql 3.22.30 and ZMySQL da 1-2-0 and MySQLdb 0.1.2, python 2.0 now i can use the database, so the data and passwords should be correct. unfortunately, if i connect to the database i get the error message printed in the addendum. is it possible, that i have to recompile the MySQLdb ? what else could be the problem? thanks for help olaf addendum -------------------- Zope Error Zope has encountered an error while publishing this resource. BadRequest Invalid connection string: ipOperate soli-con Traceback (innermost last): File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/soli-con/ipOffice/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: RoleManager) File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/soli-con/ipOffice/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_open_connection) File /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_open_connection) File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 220, in manage_open_connection (Object: RoleManager) File /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 240, in connect (Object: RoleManager) File /home/soli-con/ipOffice/lib/python/Products/ZMySQLDA/db.py, line 155, in __init__ BadRequest: (see above) -- soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23, 3013 Bern / Switzerland fon:+41-31-332 9782, mob:+41-76-572 9782 mailto:olaf.zanger@soli-con.com, http://www.soli-con.com

1 0

manage_addDTMLDocument
by nuno 08 Mar '01

08 Mar '01

Hi All ! I'm trying to add a dtml-document to my site, still i am having some problems with the location. If i write something like: <dtml-call "PARENTS[0].DIR.manage_addDTMLDocument(id=pagename,title=pagetitle,file=page )"> It creates all fine : ) BUT... If the location where i want to create the DTML Document, is recieved like a parameter All goes wrong... (something like) <dtml-var location> -> has the string 'PARENTS[0].DIR1.DIR2' which is the place where i desire to create the document.then i try this: <dtml-call "_[location].manage_addDTMLDocument(id=pagename,title=pagetitle,file=page)"> I think this is more a string problem, anyway if anyone had this problem or have any idea how to get over this, i'll be apreciatted thanks in advance regards Nuno

2 1

Add python class to Zope.
by Pattreeya Tanisaro 08 Mar '01

08 Mar '01

Hi! I found some python sources which declared "class" inside. I tried to call the function inside this class with external method and python script but it didn't work out. For examples: Guestbook.py class Guestbook: def __init__ .... def signGuestBook .... def feedBack. .. How can I call the function "feedBack" to Zope? Thank you! pattreeya .

1 0

Wrapping pre-existing content
by Phil Harris 08 Mar '01

08 Mar '01

All, I'm looking for ideas, so don't be afraid to shout any comments out. I have a hierarchy of 'documents', lots of them circa. 300 and the number will continue to grow (dramatically). These 'documents' could be of any type, XML/HTML/Images etc. What I want to do is to have some way of wrapping these documents to include a header and footer, but I want to do this at render time not before. I've got a naive Python Script (restricted) that looks like this: #=================== import string a=context.restrictedTraverse(string.join(traverse_subpath,'/'),0) if a.meta_type == 'Folder': a=a.default_html h=context.aspire_html_header_orig(None,context) f=context.aspire_html_footer_orig(None,context) c=a(None,context) return h+c+f #=================== However this has problems when rendering the header and footer (h & f), it's somehow losing the namespace and things such as PARENTS are no longer available. Any ideas? tia Phil phil.harris(a)zweb.co.uk

4 7

Zope/MySQL problem
by Richard Moon 08 Mar '01

08 Mar '01

Has anyone come across anything like this ? I have a site www.tunedb.org which is using a MySQL backend. We are getting this error Error Type : Operation Error Error Value : (1100,"Table 'n' was not locked with lock tables") When anyone submits a search (e.g. Searh by Tune name) This seems to have been triggered when someone dip a query to the site which addressed a results page directly eg http://tunedb.nipltd.net/tunedb/tune_details_results.html?tune_id=23&tune_n… After that everyone gets the error until I restart Zope - (closing an re-opening the MySQL connections has the same effect). I have four MySQL connections open. Any ideas gratefully received Thanks Full traceback Traceback (innermost last): File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/sites/site7/users/tunedb/2-2-2/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: tune_search_results.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: tune_search_results.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_In.py, line 630, in renderwob (Object: tune_search_exact) File /home/sites/site7/users/tunedb/2-2-2/lib/python/Shared/DC/ZRDB/DA.py, line 453, in __call__ (Object: tune_search_exact) File /usr/share/zope/lib/python/Products/ZMySQLDA/db.py, line 184, in query OperationalError: (see above) Richard Moon richard(a)dcs.co.uk

1 0