November 1999 - Zope-Dev

SOLVED: Using recursion with a SQL method
by Jim Cain 30 Nov '99

30 Nov '99

I finally figured this out for myself. Apparently something like: <dtml-var "some_object(parameter_name=value)"> results in a namespace stack in some_object that has *only* parameter_name defined, and no other namespaces may be accessed. As a result, using this for recursion fails. The solution was to call some_object this way instead: <dtml-with "_.namespace(parameter_name=value)"> <dtml-var some_object> </dtml-with> This creates a new namspace on the stack with the proper value of parameter_name, but other namespaces, including the one containing other Zope objects, are still accessible. An alternative method is: <dtml-call "REQUEST.set('parameter_name', value)"> <dtml-var some_object> but this is slightly different in that parameter_name is now defined within the scope of the object calling some_object, not just during the call to some_object. It seems that I'm finally getting the hang of the namespace stack. It is similar to dictionaries in PostScript, from what I can remember of them. If I have explained something incorrectly, I would appreciate being enlightened. :-) Cheers, Jim ---Original Message--- All, I have a MySQL table "category" with the following schema: id number name char parent_id number The table is self-referencing in that the parent_id points back to an ID. This structure renders a hierarchical listing of categories, with the root categories having a parent_id of -1. I have a SQL method to select category names and IDs by their parent ID: ID: Query_category_by_parid Arguments: parent_id:required:int Query: select id, name from category where <dtml-sqltest parent_id type=int> order by name I have a DTML method which calls itself recursively to find a list of categories starting with the specified parent: ID: list_categories <dtml-in "Query_category_by_parid(parent_id=parent_id)"> <p><dtml-var name> (<dtml-var id>)</p> <dtml-var "list_categories(parent_id=id)"> </dtml-in> This however, doesn't work. It appears that the second call to Query_category_by_parid, within the second call to list_categories, fails. Here is the URL: /list_categories?parent_id=-1 This is the error I receive: Error Type: NameError Error Value: Query_category_by_parid And here is the traceback: [snip] I have a feeling I'm missing something obvious, such as a problem with the namespaces. Any help would be greatly appreciated. Cheers, Jim

1 0

RE: [Zope-dev] automatically doing a Catalog search as part of ob ject traversal...
by Michel Pelletier 30 Nov '99

30 Nov '99

> -----Original Message----- > From: Anthony Baxter [mailto:anthony@interlink.com.au] > Sent: Tuesday, November 30, 1999 1:19 AM > To: zope-dev(a)zope.org > Subject: [Zope-dev] automatically doing a Catalog search as part of > object traversal... > > > Say I have a catalog HelpCatalog, with a bunch of documents that have > unique IDs. I want to be able to do something like > HelpCatalog/by-id/SomeUniqueID > and have it return the document SomeUniqueID. > > Do Catalogs support any sort of Direct Traversal like this? No but it's not a bad idea. > Or am I going > to have to do it myself with a mixin class? You could allways submit a patch. ;) Note that ZTopics, in a way, does this genericly, it executes canned queries based on traversal, it might need to be fondled a bit to get it to do exactly this however. -Michel

1 0

Sorting on multiple values?
by Benno Rice 30 Nov '99

30 Nov '99

I've got a bunch of objects that are ZCataloged and I want to get a list back that's sorted on more than one of the indexes. Is this doable? I'm not averse to using dtml-in to do some of the sorting, I'd just like to know if there's a simple way of doing it before I go charging off to do it in python. -- Benno Rice "No, no. We're *sweet* and XNFP Aries Dark Subculture- *innocent* evil bastards." friendly Internet Geek benno(a)netizen.com.au "Defend your joy"

2 3

Re: [Zope-dev] automatically doing a Catalog search as part of ob ject traversal...
by Anthony Baxter 30 Nov '99

30 Nov '99

>>> Toby Dickenson wrote > > Say I have a catalog HelpCatalog, with a bunch of documents that have > > unique IDs. I want to be able to do something like > > HelpCatalog/by-id/SomeUniqueID > > and have it return the document SomeUniqueID. > > I looked at doing something like this just after the release of 2.0, but ran > across a problem. Catalog.getobject calls HTTPRequest.resolve_url, which > starts its resolving process from REQUEST.PARENTS[0]. > I could get around this problem by storing the ids, and performing the > search on demand. This worked for me since I wanted the searched-for > objects to be parameters to the request. I will not quite work for you since > you want the request to be handled by the searched-for object. I'm getting there - I've now got a dtml-tree populated from a Catalog (I'm using a PythonMethod in there, which is cheating, I guess :) > > Do Catalogs support any sort of Direct Traversal like this? > > Or am I going > > to have to do it myself with a mixin class? > > oh yes. That's 'oh yes, I'm going to have to do it with a mixin'? Hm, wonder what happens when I traverse across a pythonmethod... Anthony

1 0

RE: [Zope-dev] automatically doing a Catalog search as part of ob ject traversal...
by Toby Dickenson 30 Nov '99

30 Nov '99

> -----Original Message----- > From: Anthony Baxter [mailto:anthony@interlink.com.au] > Sent: 30 November 1999 06:19 > To: zope-dev(a)zope.org > Subject: [Zope-dev] automatically doing a Catalog search as part of > object traversal... > > > Say I have a catalog HelpCatalog, with a bunch of documents that have > unique IDs. I want to be able to do something like > HelpCatalog/by-id/SomeUniqueID > and have it return the document SomeUniqueID. I looked at doing something like this just after the release of 2.0, but ran across a problem. Catalog.getobject calls HTTPRequest.resolve_url, which starts its resolving process from REQUEST.PARENTS[0]. However REQUEST.PARENTS is not available until after the original url traversal is complete, therefore it is not possible to use ZCatalog.getobject (or resolve_url) as part of url traversal. (actually, REQUEST.PARENTS is available, however its elements are in a reversed order). I could get around this problem by storing the ids, and performing the search on demand. This worked for me since I wanted the searched-for objects to be parameters to the request. I will not quite work for you since you want the request to be handled by the searched-for object. > Do Catalogs support any sort of Direct Traversal like this? > Or am I going > to have to do it myself with a mixin class? oh yes.

1 0

Zope directory path + modif control panel
by Stefan Langerman 30 Nov '99

30 Nov '99

Hi, How can I, from a python module, know the absolute path of the main zope directory? Is there a variable that contains it? or a method that returns it? Also (I asked that before, but got no answer) is it possible to add an entry to the control panel? (at the same level as "DB Management", "Version Management", "Product Management") Thanks a lot, Stefan.

1 0

[Fwd: first disregarding and then complaining about missing </noframes>]
by Hannu Krosing 30 Nov '99

30 Nov '99

After playing with tidy from w3.org I complained to them about an issue with zope's management frameset page and this is what I got back.

1 0

patch to allow importing through file upload
by Ava 30 Nov '99

30 Nov '99

Hello, I've written a patch to allow one to upload files in the export/import tab. the file limit is set to 64Kb. I hope this is useful Again, comments are welcome (please send them to minf7(a)educ.univ-reunion.fr instead of ava(a)dde.equipement.gouv.fr) Regards, Jephte CLAIN There are 2 patches, one against ObjectManager.py, one against importExport.dtml, both located in lib/python/OFS Cordialement,

1 0

automatically doing a Catalog search as part of object traversal...
by Anthony Baxter 30 Nov '99

30 Nov '99

Say I have a catalog HelpCatalog, with a bunch of documents that have unique IDs. I want to be able to do something like HelpCatalog/by-id/SomeUniqueID and have it return the document SomeUniqueID. Do Catalogs support any sort of Direct Traversal like this? Or am I going to have to do it myself with a mixin class? Thanks, Anthony

1 0

copy&past question about zdiscussions
by sdf 30 Nov '99

30 Nov '99

I found that the ZDiscussions componet can't be copy&paste with ZDItems in it,because the ZDItem is not a addable object out of the ZDtopic. I manage to pull the ZDItem out of the ZDTopic,and the ZDTopic can work well as before.but when I add a ZDItem in a Folder,the system reports an error,anyone else notice the problem?

1 0