March 2000 - Zope - Zope lists

how to get the fields returned SQL method
by Eric BARROCA 24 Mar '00

24 Mar '00

Hello, I'm trying to get a list of fields returned by a dynamic SQL query. I've found a howto telling me to write something like : <dtml-in SQL.names> <dtml-var sequence-item> </dtml-in> But it doesn't work : I get the error "Attribute Error : names". I've tried with .items, .keys and .fields too. I'd like to do the same for an LDAP query. Any idea ? I think it's very useful and that an easy way exists but I can't find it. Thanks, EB.

3 2

Re: [Zope-dev] Re: [ZIP] dtml-var syntax revisited
by Stephan Richter 24 Mar '00

24 Mar '00

I think a translator should implemented using a flag in dtml-var: syntax: <dtml-var VARIABLE translate> and <dtml-var VARIABLE translate="de"> for example. Short form: &dtml.translate-VARIABLE; By default it chooses the root folder's (or even Zope's?) language setting, but the programmer can also choose the language. This syntax is very similar to the "missing" flag. This way you do not a separate phrasebook and word translator. All that is in the background.... Then there is a generic translate product which handles all the translation stuff and administrates the languages. One can easily drop languages into the product, by installing simply the dictionary for this language into some standard location and specifying some admin info. I think that would be the cleanest way to implement ZIP. What do you guys think? Comments? Regards, Stephan -- Stephan Richter - (901) 573-3308 - srichter(a)cbu.edu CBU - Physics & Chemistry; Framework Web - Web Design & Development PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391

1 0

Zope hanging: internal ZODB error?
by Darran Edmundson 24 Mar '00

24 Mar '00

I recently took the site I have been developing online and have been beta testing with several users. I have a problem which is preventing a user from viewing his home page; any attempt I make to isolate the problem hangs Zope, stops anyone accessing my site, and requires a forced unix kill. The user's page is: http://rsphysse.anu.edu.au/optics/people/jdl124 Users are implemented as a Person ZClass. One of their contained objects is a PublicationFolder ZClass, itself a container class for Journal ZClass instances. So above: optics (folder) people (folder) jdl124 (Person) publications (PublicationFolder) article1 (Journal) article2 (Journal) . . article69 (Journal) jdl124's home page is dying when it tries to iterate over the results from a search of the ZCatalog publicationCatalog.  Traceback (innermost last): File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 2 14, in publish_module File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: jdl124) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: index_html) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: index_html) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: index_html) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: index_html) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: publicationCatalog.recentPublications(_.None,_,FirstName=FirstName,LastName=LastName)) (Info: FirstName) File <string>, line 0, in ? File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/OFS/DTMLMethod.py, line 141, in __call__ (Object: recentPublications) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: recentPublications) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/DocumentTemplate/DT_In.py, line 493, in renderwb (Object: publist) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/DocumentTemplate/DT_In.py, line 710, in sort_sequence (Object: publist) File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/Products/ZCatalog/Lazy.py, line 190, in __getitem__ File /tmp_mnt/users/optics/www124/Zope-2.1.4-src/lib/python/Products/ZCatalog/Catalog.py, line 181, in __getitem__ KeyError: (see above) The problem isn't in the publicationCatalog however, the following DTML snippet locks up my Zope completely: <dtml-with jdl124> <dtml-with publications> <dtml-in "objectValues()"> <dtml-var id><br> </dtml-in> </dtml-with> </dtml-with> I can deal with this during solo testing but my users' budding confidence in the system I have created has been mildly rocked by this situation. Needless to say, jdl124 is none too impressed. Any help you can offer is most appreciated. Cheers, Darran.

2 1

error with ptk
by Omar RABHI 24 Mar '00

24 Mar '00

I began to download and to install PTK's last version recently. I installed the product by following procedure described in the file " Read Me ", and I so obtained three new elements in the section products. But when I try to create a new element "Portal", Zope sends back me an error. I search so the details of the installed products and I notice that in the part " DemoPortal " certain elements are broken: It is a question of: . " DemoPortal / Portal " . " DemoPortal / PortalWizard " . " DemoPortal / Wizard " In fact they are all the DemoPortal's ZClass which are lacking. Can it involve a conflict with another product? Is it necessary to settle PTK on Zope's clean version? I work with: Zope version: Zope 2.1.2 (binary release, python 1.5.2 , win32-x86) on Win NT4 / sp4, as well as with Zope 2.1.4 on Linux Mandrake 7.0. (on whom I did not test PTK because it is my working environment, and I do not wish to pollute it). Thank you for advices. I intervene only rarely. What is well , it is that major subjects and basic questions were approached in depth, repeatedly, what allows to avoid resting the same questions. By getting back this information, the people of the ZDP make a formidable job. That has the taste of object oriented thinking... Greetings Omar RABHI The Old Zope Book in French http://www.zope-france.org:8080/sujets/Documentation/zbook Zope & XML http://www.zope-france.org:8080/sujets/XML/xmlconf Gain Zope Enlightenment By Grokking Object Orientation: http://www.zope-france.org:8080/sujets/Documentation/grokking/

1 0

dtml-with in a pythonMethod?
by Darran Edmundson 24 Mar '00

24 Mar '00

I have a container ZClass Person. Person has a (string) property CurrentPosition which gives the id of a ZClass instance contained in Person. Example: DarranEdmundson (Person) bsc_degree (Degree) phd_degree (Degree) fellow (Academic) fujitsu (employment) vizlab (employment) where DarranEdmundson.CurrentPosition = "vizlab" I am having problems accessing the CurrentPosition object in a pythonMethod. list = [] for person in self.objectValues('Person'): position = _.getitem(person.CurrentPosition) list.append(person.LastName, position.anyProperty)) I can do it in DTML via <dtml-in "objectValues('Person')"> <dtml-with "_.getitem(CurrentPosition)"> <dtml-var LastName> <dtml-var anyProperty> </dtml-with> </dtml-in> I think the question really comes down to: how does one achieve <dtml-with name> in a pythonMethod? Cheers, Darran.

2 1

ZEO app architecture options
by Jimmie Houchin 24 Mar '00

24 Mar '00

Hello, In light of ZEO becoming open source, I'm still extremely excited, I want to revisit some questions I threw out in a previous thread about Zope's scalability. Can I architect a website like this using different Zope Storage Servers for the various directories or 'would be' tables in an RDBMS? Yes, I understand the impact of the OS filesystem concerning ZODB size. Say for example I have a large database. Like this: ZAuto ZAuto/parts/ ZAuto/manufacturers/ ZAuto/distributors/ ZAuto/distributors/...(orders, address, preferences, etc.) ZAuto/resellers/...(orders, address, preferences, etc.) ... Let's say that ZAuto/parts is a 5+gb directory which is reasonably stable updated monthly. ZAuto/manufacturers isn't as large but is also stable with periodic updates. ZAuto/distributors and ZAuto/resellers are much more dynamic with changes and additions. ZAuto/parts could be optimized for search performance. It only needs to be backed up periodically when bulk changes are made. It will relatively almost never need packed. It could sit on it's own drive, own machine, etc. It would be nice to be able to partition the database into stable/volatile files. Since the stable partition is also the largest, it seems this would also help performance of the more dynamic section. Also, when comments are made about Zope's ZODB or ZSS not being appropriate for heavy write apps, does this refer to apps doing "updates" on objects or doing "inserts" or both using SQL terminology? Would structuring an app like above help in write situations? I am trying to determine the desirability or necessity of an RDBMS for my idea. I like keeping it in Zope if reasonable and ZEO can definitely help. If need be I'll go to an RDBMS for certain data. Thanks for any help or clues. Jimmie Houchin

2 1

Catalog search merges
by R. David Murray 24 Mar '00

24 Mar '00

OK, so I read the Advanced Catalog Search HowTo, and I am left with a couple of questions. I'm concerned here with "or"ing the searches on two fields. The first question is, once I do the OR is the result (which may be close to a thousand records) cached? Otherwise I don't think this is going to work. Even if it is cached, I'm thinking it may not work. Is there any way to do an OR without loading both result sets into memory? The other question is, when I do the OR, how do I reduce the composed list to just unique records? The HowTo seems to just do a sequence join, which would leave me with duplicated records for those items that matched on both search columns. --RDM

1 0

dtml-boundary is killing me!!! HELP!!!!
by Hugo Ramos 23 Mar '00

23 Mar '00

yellow, As I was trying to send an attachment via Zope to whatever(a)somewhere.com i wanted the dtml-boundary tag to do something like this: <dtml-boundary type=application/octet-stream disposition=attachment encode=base64 name="_['file.filename']"> but I just can't get this to work... the only way it works is to use the attribute name=file The result is an attachment file.dat I want Zope to send the attachment with the real filename. HELP??? thanks -------------------------------------------------------------- Hugo Ramos - hramos(a)ruido-visual.pt Ruido Visual

2 1

how do I generate html for a given number of items
by sathya 23 Mar '00

23 Mar '00

sinde dtml does not provide a " for loop " structure how can I generate form fields equivalent to the number of catalog items somebody has choosen i.e <form> <for noOfTimes> <input type="text" name= ... </for> </form> The dtml-in tag only accepts lists and such -- ########################## necessity is the mother of invention ##########################

2 1

RE: [Zope] how do I generate html for a given number of items
by Baker, Dennis (sjmr) 23 Mar '00

23 Mar '00

Try this http://yyy.zope.org/Members/jpenny/variable_length_forms -----Original Message----- From: sathya [mailto:linuxcraft@redspice.com] Sent: Thursday, March 23, 2000 2:52 PM To: zope(a)zope.org Subject: [Zope] how do I generate html for a given number of items sinde dtml does not provide a " for loop " structure how can I generate form fields equivalent to the number of catalog items somebody has choosen i.e <form> <for noOfTimes> <input type="text" name= ... </for> </form> The dtml-in tag only accepts lists and such -- ########################## necessity is the mother of invention ########################## _______________________________________________ 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