December 2002 - Zope

API for Zope cacheing
by Felix Ulrich-Oltean 18 Dec '02

18 Dec '02

Is there an API for using Zope's cacheing machinery from python products? Specifically, I have a subclass of SimpleUserFolder which calls 20+ SQL statements every time it's called just to work out the user's details - this is all very cacheable and I can see that Zope provides various caches - there are some useful-looking methods in RAMCacheManager.py, but I was wondering if there is a 'known' way to do it. Thanks, Felix.

2 1

ZSQL arguments
by Terry Hancock 18 Dec '02

18 Dec '02

>From the DTML inside of a ZSQL method, is it possible to interrogate the list of arguments? Examing the source, I've tried various combinations of _ context.arguments self._arg self.argument_src argument_src _.argument_src and so on, but nothing seems to be understood. In particular, "_" is defined, but seems to be empty (at least a repr(_) doesn't render anything into the query. It doesn't seem that this information is made available to the DTML code in a ZSQL method. I'm asking because I have a fairly wide table that I want to be able to update on essentially any field with optional arguments. There's nothing equivalent to the <dtml-sqltest ... optional> structure for controlling input, so I'm left with something like: <dtml-if arg1> SET arg1 = <dtml-sqlvar arg1 type="string">, </dtml-if> for a couple dozen arguments, which is sort of tiresome, especially since this would change if the schema changes. It'd be nice to be able to code this as a loop, but it's awkward without being able to handle the arguments as a structure. I can of course do some cut and paste in my editor and solve the problem, but I wondered if there's a more elegant solution. Cheers, Terry -- Terry Hancock ( hancock at anansispaceworks.com ) Anansi Spaceworks http://www.anansispaceworks.com "Some things are too important to be taken seriously"

2 1

Permissions question
by Kevin Carlson 18 Dec '02

18 Dec '02

I am searching a catalog based on the following criteria: I have the following folder structure: Root Folder | - Folder 1 | - Folder 2 | - Folder 2.1 | - Folder 2.2 | - Folder 3 | - Catalog I have images in each of the subfolders of the root folder. There is an acl_users folder in root as well as in Folder 2.1. The Catalog contains references to each of the image objects in each folder. If I log in as a user that has access to the Root Folder, all is well. However, when I log in as a user that is listed in the acl_users folder contained in Folder 2.1, catalog searches are getting fouled up. When I search the catalog on a text index and check each object to see if the AUTHENTICATED_USER has the 'View' permission, I am getting several results in the result set that shouldn't appear. Only the images that match the search AND appear in Folder 2.1 should be returned for all the users listed in Folder 2.1's acl_users but I am getting back images in other folders as well. My permissions are set up to allow 'View' access only to 'Authenticated' users. I am searching the catalog with the following python script: -------------------- request = container.REQUEST RESPONSE = request.RESPONSE keywordFields = ('title', 'desc') docList = {} if keyword != None and keyword.strip() != "": for field in keywordFields : for item in context.photoCatalog({field : keyword}) : if request['AUTHENTICATED_USER'].has_permission('View', item) : docList[item.id] = item #convert to list docList = docList.values() return docList ---------------------- The line that calls has_permission is returning 1 for pictures outside of the folder in which the user is defined. However, when I render the results page from the docList variable, the images are correctly shown as inaccessible to this user and the login dialog box is displayed. What I'm trying to do is avoid this login by confining result items to those that are viewable by the currently logged in user. Anyone have any ideas as to why this is happening? Kevin

2 1

Getting a Mysqldb.Connection objetct form ZMySAQLDA
by Gilles Lenfant 18 Dec '02

18 Dec '02

Hi, Is it possible to get a MySQLdb.Connection object from a ZMySQLDA object ? I need this because my Python product builds the query string dynamically and a ZSQL Method is not suitable for this. Or should I parse the connection string and build my own Connection object ? Thanks in advance for your help --Gilles

2 1

FW: Delete user and users folder
by John Paul 18 Dec '02

18 Dec '02

-----Original Message----- From: John Paul [mailto:rmpconsult2@mydestiny.net] Sent: Monday, December 16, 2002 12:10 PM To: Zope Mailing List Subject: Delete user and users folder Hi, can somebody tell me how to delete a user and its members folder in python script.

2 1

CMF Article and DC Workflow Problem
by John Paul 18 Dec '02

18 Dec '02

Hi I just set up a CMF portal with a couple of custom types and noticed that CMF Article in private and pending status are viewable if the Reviewer knows the URL for them unlike other content types like News Item and Document which notifies the reviewer when a certain news items or document are in pending mode.

3 2

bug? type error unicode creating zclass in zope2.6.1b1
by Bakhtiar A Hamid 18 Dec '02

18 Dec '02

hi when creating zclass in zope2.6.1b1, i have this error[1] it works if i use zope 2.6.0 -- [1] traceback TypeError Sorry, a site error occurred. Traceback (innermost last): * Module ZPublisher.Publish, line 150, in publish_module * Module ZPublisher.Publish, line 114, in publish * Module Zope.App.startup, line 182, in zpublisher_exception_hook * Module ZPublisher.Publish, line 102, in publish * Module Zope.App.startup, line 200, in commit * Module ZODB.Transaction, line 236, in commit * Module ZODB.Transaction, line 352, in _commit_objects * Module ZODB.Connection, line 388, in commit __traceback_info__: (('ZClasses.ZClass', 'ZClass'), '\x00\x00\x00\x00\x00\x02Ie', '') TypeError: expected string or Unicode object, None found -- http://www.kedai.com.my/ http://www.kedai.com.my/eZine http://www.zope.org/Members/kedai http://www.my-zope.org use Zope? you got HOPE

2 1

Netscape 4, cookies and domains
by Chris Muldrow 18 Dec '02

18 Dec '02

We're using ZEO to feed two Zope clients and we're using Sessions with a packless storage to keep track of session info. It works great except for one problem related to Netscape 4 that I've seen referenced before in other contexts. I've got browseridmanager set to feed cookies with a domain of .mydomain.com. So www1.mydomain.com and www2.mydomain.com and www.mydomain.com all work fine. But mydomain.com doesn't get a browser ID set. If I take off the domain setting in the browser ID manager, it works with Netscape 4 with mydomain.com but of course doesn't work on any of the other domains and doesn't share domain info across the board. Is there any workaround for this short of forcing them to a www.mydomain.com URL? Thanks! - Chris

2 3

Error handling and Zpublisher type casts ?
by Andreas Martin 18 Dec '02

18 Dec '02

Hallo ! I would like to ask how I can catch an error produced by a Zpublisher type cast. If I have an zpt with a html form with input box <input type="text" name="number:int"> then the Zpublisher tries to convert the string I typed in into an integer number. If this fails, e.g. if I type in an string "aaa" that cannot be converted instead of a number "123", then I get this error: Zope Error Zope has encountered an error while publishing this resource. Error Type: ValueError Error Value: An integer was expected in the value 'aaa' How can I catch this error ? Thank you Andreas Martin

2 1

Help with Tables
by Lindstrom Greg - glinds 18 Dec '02

18 Dec '02

Greetings- I am in the process of designing three (count 'em 3) projects in Zope and have spotted a common theme running through them. I have pages which lists information stored in a Gadfly (for now) table via a ZSQLMethod. I would like to add the following features to my tables; 1. The ability to click on the column header to sort the table by that column (member number, name, etc.) 2. The ability to click on an entry in the table to bring up more information about the particular item. For example, clicking on a member number might bring up a form showing more information about the member. Is there documentation as how to go about doing this? Or can one of you point me to a page that does it already? Thanks! --greg Greg Lindstrom The limits of language are the limits of one's world --Ludwig von Wittgenstien ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

2 1