November 2002 - Zope

ID generator for ZODB
by Oliver Marx 05 Nov '02

05 Nov '02

In PostgreSQL we have the sequence. Is there something like that for ZODB or do I make a counter with a little piece of MUTEX code? MUTEX in Python, can that be done? \Oliver

2 1

File system cataloging product
by Isokangas, Erik HTC/DE/FRA 05 Nov '02

05 Nov '02

Hi, I'm looking for a product or products that will allow me to catalog/index files that are added into a specific network directory - something like LocalFS with WebDAV support and cataloging. The intent is to provide a search engine for documents/files stored by users (possibly in a directory tree structure on the network). Thanks for your suggestions. Regards, Erik Isokangas

2 1

ZPT, standard_error_message and error_value
by Richard Wesley 05 Nov '02

05 Nov '02

I am having a rather surreal time here. I am attempting to write a ZPT version of standard_error_message under Zope 2.5.0 and I find that I cannot display the options/error_value field. If I dump out the entire options dictionary, error_value is there and gets displayed as something like <Products.PageTemplates.TALES.Undefined instance at 0x831c384>, but if I attempt to render it in ZPT (just using what the CMF folks did) I get a generic error message of some kind. DTML has no trouble rendering the same thing as a file/line type error message but ZPT blows chunks. Any hints greatly appreciated. TIA, Sincerely, Richard Wesley Co-President, Electric Fish, Inc. <http://www.electricfish.com/> (v) +1-206-493-1690x210 (f) +1-206-493-1697

2 1

dtml date comparsion help
by Kelley, Sean 05 Nov '02

05 Nov '02

Hi, Trying to get more familiar with dtml... How do I do a date comparison with dtml-in? I have: <dtml-in "portal_catalog.searchResults( meta_type='CMF Event' , sort_on='Date' , sort_order='reverse' , Subject='All Utilities' , review_state='published' )" size="10"> Some stuff </dtml-in> I want to insert a dtml statement so that only the CMF events that are on or after today show up. Do I do my date comparison in the first line somehow or with a dtml-if a little later? I am trying to say if Date (date mm/dd/yy) >= ZopeTime (date mm/dd/yy) do something. Problem is that I it seems I need to use the fmt attribute on the date comparison so I am a little comfused about syntax. tried something like: <dtml-if expr="Date fmt='%m/%d/%Y' >= ZopeTime fmt='%m/%d/%Y'"> but I do not have the syntax right.

2 1

Page Template: how to reference objects in the folder above this one?
by Skip Montanaro 05 Nov '02

05 Nov '02

If I have the following objects /dcII /dcII/add_contact /dcII/add_contact/index_html /dcII/standard_footer /dcII/standard_header and .../index_html is a page template, how to I reference /dcII/standard_{header,footer}? I tried both of the following: <span tal:replace="/dcII/standard_html_header">header</span> <span tal:replace="here/../standard_html_header">header</span> -- Skip Montanaro - skip(a)pobox.com http://www.mojam.com/ http://www.musi-cal.com/

6 9

zope server error
by Hamzat Kamal 05 Nov '02

05 Nov '02

Hi, I notice of recent that my zope server performance become slower than necessary. When I check the error log msg this is what is their. Can these error msg be the cause of the problem? Nov 4 05:36:18 web start: POSKeyError: 0000000000001e6e Nov 4 05:36:18 web start: Nov 4 05:36:18 web start: Nov 4 05:36:25 web start: ------ Nov 4 05:36:25 web start: 2002-11-04T13:36:25 ERROR(200) ZODB Couldn't load sta te for '\x00\x00\x00\x00\x00\x00\x1en' Nov 4 05:36:25 web start: Traceback (innermost last): Nov 4 05:36:25 web start: File /usr/local/zope/2-5-1/lib/python/ZODB/Connecti on.py, line 447, in setstate Nov 4 05:36:25 web start: File /usr/local/zope/2-5-1/lib/python/ZODB/FileStor age.py, line 582, in load Nov 4 05:36:25 web start: (Object: /usr/local/zope/2-5-1/var/Data.fs) Nov 4 05:36:25 web start: File /usr/local/zope/2-5-1/lib/python/ZODB/FileStor age.py, line 557, in _load Nov 4 05:36:25 web start: (Object: /usr/local/zope/2-5-1/var/Data.fs) Nov 4 05:36:25 web start: POSKeyError: 0000000000001e6e Nov 4 05:36:25 web start: Nov 4 05:36:25 web start: Nov 4 05:51:55 web start: ------ Nov 4 05:51:55 web start: 2002-11-04T13:51:55 ERROR(200) ZServer uncaptured pyt hon exception, closing channel <ZServer.HTTPServer.zhttp_channel connected 64.11 0.76.183:2540 at 0x9c0c51c channel#: 35233 requests:> (socket.error:(110, 'Conne ction timed out') [/usr/local/zope/2-5-1/ZServer/medusa/asynchat.py|handle_read| 82] [/usr/local/zope/2-5-1/ZServer/medusa/http_server.py|recv|420] [/usr/local/z ope/2-5-1/ZServer/medusa/asyncore.py|recv|357]) Nov 4 07:55:52 web start: ------ Nov 4 07:55:52 web start: 2002-11-04T15:55:52 ERROR(200) ZServer uncaptured pyt hon exception, closing channel <ZServer.HTTPServer.zhttp_channel connected 198.1 46.86.155:1721 at 0x94cd024 channel#: 37282 requests:> (socket.error:(110, 'Conn ection timed out') [/usr/local/zope/2-5-1/ZServer/medusa/asynchat.py|handle_read |82] [/usr/local/zope/2-5-1/ZServer/medusa/http_server.py|recv|420] [/usr/local/ zope/2-5-1/ZServer/medusa/asyncore.py|recv|357]) Pls i need your advise on what can be done to get it back to normal. Thanks. ===== Hamzat kamaldeen Ishola Dnet Systems Limited. 223 Ikorodu Road, Lagos. Nigeria. 234 1 7749381, 234 08033011305 --- If Mistake is an opportunity to see better,�then do not fear it, but ready to admit it. NOTE: Sentimental decisions are not mistakes but failures !!!� __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/

2 1

Close But No Cigar (Formulator/ZPT)
by beno 05 Nov '02

05 Nov '02

Hi (again); Okay, in DTML, when one calls a Formulator form via a DTML document, the DTML document to which one sends the POST is able to render variables from the form thus: <dtml-var my_variable_from_the_form> Now, I'm trying to do this via a Python script (which I promise I will furnish for other dummies like me via a HowTo): form = context.email_us_formulator i = 0 myField = [] for field in form.get_fields(): myField.append(field.get_value('title')) WHAT DO I DO HERE?? i = i + 1 try: mailhost=getattr(context, context.superValues('Mail Host')[0].id) except: raise AttributeError, "cant find a Mail Host object" mTo = 'beno(a)thewebsons.com' mFrom = YourEmail mSubj = 'subject' message = "Hi, Mike! You've just been sent an email from your Web site!\n\n" message += "Sender's name: " + YourName + "\n" message += "Sender's phone: " + YourPhone + "\n" message += "Sender's email: " + YourEmail + "\n\n" message += "Sender's comments: " + YourMessage + "\n" mMsg = message mailhost.send(mMsg, mto=mTo, mfrom=mFrom, subject=mSubj) where the *WHAT DO I DO HERE??* needs to call the values from the form. (I may be mistaken with the line above that, too.) Can you help me? TIA, beno

2 2

Python -> ZopePython cheat sheet?
by Skip Montanaro 05 Nov '02

05 Nov '02

I am *so* used to just being able to explore around my Python interpreter and having everything I need documentation-wise in the global module index of the library reference manual that I am finding the whole Zope experience incredibly frustrating. Is there no equivalent of dir() or type() which I can use from a Python script to find out what the heck I've been passed? Assuming there is some way to find out what I've gote, is there something like Python's global module index where I can just click on "Formulator" or "container" and get some documentation useful to a Python programmer? frustrated-in-evanston... -- Skip Montanaro - skip(a)pobox.com http://www.mojam.com/ http://www.musi-cal.com/

5 10

Re: [Zope] Trigger/Auto ID on Gadfly DB
by andy47＠halfcooked.com 05 Nov '02

05 Nov '02

Michael, > Miche=E1l Healy wrote: > > > Hi all, > > > > Is it possible to set a trigger on a gadfly database table? I would > > like to automatically generate an Id on a table each time I insert. > > In Oracle, I would create a sequence and then create a trigger on the > > table in question based on the sequence. I something similar possibl= e > > with Gadfly? > > > > TIA, > > > > Miche=E1l > > > Erm. > > No. > > Gadfly is a very light-weight database. It accepts SQL commands, but i= t > isn't a "full" database like you might think. > > I dont know if it has automatic sequence numbers -- that's your real > question. Each RDBMS tends to do automatic sequence number differently. > Oracle actually does it the most awkward way, by requiring you to set = a > trigger on inserts. Most other RDBMS will let you specific an > auto-increment column some way. > > Granted, I could be wrong about Gadfly -- I only spent about 90 seconds > grepping the source for a likely auto-increment column operator. But I > do not believe Gadfly does this for you. > > -- > Matt Kromer > Zope Corporation http://www.zope.com/ > Matt is absolutely correct. Gadfly does not support auto increment columns. Nor does it support triggers, or strict column data types. For more information can I suggest you check the documentation which is provided with the source. Failing that it is on the web site at http://gadfly.sourceforge.net/. If you find any errors or omissions please contact the documentation maintainer who is currently, er, me. Regards, Andy

1 0

Python 2.2 and Zope 2.6.0
by Timothy Burt 05 Nov '02

05 Nov '02

I downloaded Zope 2.6.0 and in the readme (if I recall) it says "DO NOT USE Python 2.2" Use Python 1.5. Some further research seems to indicate a problem with zope 2.6.0 and Python 2.2 on Solaris. So I installed Python 1.5, and now I have problems with one of the products which is requiring features in Python 2.2. Question..... Does Zope 2.6.0 require Python 1.5 on a Linux Box? Or does Python 2.2 work OK? Thanks for the reply.. I am looking forward to being a frequent contributor to the list. -- -------------------- Timothy Burt General Manager Arbor Group LLC Los Angeles, Calif. USA

5 5