January 2001 - Zope - Zope lists

MySQL
by Piotr Kozbial 27 Jan '01

27 Jan '01

I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were broken.Thus I have installed latest ZMySQLDA-2.0.4 and MySQLdb 0.3.1. Ufter upgrade it does not work. I am able to search pages, ie.: http://arete.ibb.waw.pl/html/leksykon/cd_rom_report_en?nazwa_angielska=b but I am unable to display single records, ie.: http://arete.ibb.waw.pl/html/leksykon/single_record_report_hasla2?nazwa_ide… Traceback (innermost last): File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /opt/www/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /opt/www/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: NowehaslaReplyForm) File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: NowehaslaReplyForm) File /opt/www/zope/lib/python/OFS/DTMLDocument.py, line 189, in __call__ (Object: NowehaslaReplyForm) File /opt/www/zope/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__ (Object: NowehaslaReplyForm) File /opt/www/zope/lib/python/DocumentTemplate/DT_In.py, line 711, in renderwob (Object: single_id_hasla2) KeyError: (see above) I am unable to use TIMESTAMP from database ie.: Traceback (innermost last): File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /opt/www/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /opt/www/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: search_report_pl) File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: search_report_pl) File /opt/www/zope/lib/python/OFS/DTMLMethod.py, line 189, in __call__ (Object: search_report_pl) File /opt/www/zope/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__ (Object: search_report_pl) File /opt/www/zope/lib/python/DocumentTemplate/DT_In.py, line 480, in renderwb (Object: simple_search_pl) File /opt/www/zope/lib/python/Shared/DC/ZRDB/DA.py, line 488, in __call__ (Object: simple_search_pl) File /opt/www/zope/lib/python/Shared/DC/ZRDB/DA.py, line 435, in _cached_result (Object: simple_search_pl) File /opt/www/zope/lib/python/Products/ZMySQLDA/db.py, line 231, in query File /opt/www/zope/lib/python/Products/ZMySQLDA/db.py, line 104, in _mysql_timestamp_converter ValueError: (see above) -------------------------------- What is wrong. Is is MySQL or ZOPE or ZMySQLDA problem? Regards, Piotr -- _____________________________________ Piotr Kozbial http://arete.ibb.waw.pl

2 1

DTML namespace puzzle
by Ron Bickers 27 Jan '01

27 Jan '01

Just when I thought I was catching on to everything, I ran into this. I'm using Zope 2.3.0 (final). I don't know if this worked the same with 2.2 because I didn't try this until today. SQLSession is handling the SESSION stuff, and I haven't had any problems with it. I have a Python Script (sendOrder) that calls a DTML method (orderMessage) as follows: container.orderMessage(num=num, SESSION=SESSION) orderMessage contains the following: <dtml-with "SESSION['info']" mapping> Order Number: <dtml-var num> Blah blah other session variables that work fine. </dtml-with> I get a KeyError on num. If I modify orderMessage to contain the following, it works: <dtml-let num=num> <dtml-with "SESSION['info']" mapping> Order Number: <dtml-var num> Blah blah other session variables that work fine. </dtml-with> </dtml-let> This seems strange to me. What am I missing? _______________________ Ron Bickers Logic Etc, Inc. rbickers(a)logicetc.com

1 0

PythonScripts documentation
by Gerald Gutierrez 26 Jan '01

26 Jan '01

Where is the latest documentation for PythonScripts located? The closest I found is http://www.zope.org/Members/4am/PythonMethod but it is dated and contains minimal information. I'm specifically interested in what I can do with them and what I cannot do with them. Thanks.

6 5

Re: [Zope] EMail with uploaded attachments, Part II
by Dieter Maurer 26 Jan '01

26 Jan '01

Klaus Herrmann writes: > ... > How do I determinate the filename and mime-type of the uploaded file? > > i have > <input type=file size=18 maxlength=3000000 name=attached_file> > and can get my data with attached_file.read(), but how do i do it when i want > to have filename and mime-type correctly filled in in > <dtml-boundary type=??? encode=base64 filename=??? name=???> Maybe, you should look at the source documentions for "ZPublisher.HTTPRequest.FileUpload". You will see there, that "FileUpload" objects have attributes 'filename' and 'headers'. In headers, you will find the "Content-Type", provided that your browser has send this information (as it should). Then, you need to know, that "dtml-boundary" has "*_expr" argument variants that allow to provide expressions as values rather than fixed constants. That's all you should need. Dieter

1 0

Re: [Zope] SQL-based LoginManager and subtransactions
by Oliver Bleutgen 26 Jan '01

26 Jan '01

> I haven't been following this discussion, but it sounds like there's > the potential for SQL operations performed by LoginManager to > interfere with other SQL operations such as logging uploaded files, in > the case where the database system does not support nested (sub-) > transactions. Correct? No, but I'm really not familiar enough with the ZODB machinery and zope internals to tell do much more than wild guesses. The problem seems to be that the ZODB and things like Zcatalog know about subtransactions (you can disable them with the latter one), but some (the most) zope db-adapters don't. Now zope seems to use subtransactions internally and to expect the DAs to provide them also (commit_sub), but for now it seems to not completly clear when and why - see the thread "subtransactions". For file-uploads the threshold may be <~ 120kb, that is which bites people with loginmanager/postgres. The workaround from I cited should at least solve the zope-error, but I have no idea if it can hurt. The best thing would be to properly implement the missing methods in the DAs, I guess, unfortunately this is above my head for now. PS: the sybase DA seems to know about commit_sub cheers, oliver

1 0

Re: [Zope] "Hiding" a Zope object from URL accesses
by Dieter Maurer 26 Jan '01

26 Jan '01

Rik Hoekstra writes: > AFAIK there is no way of hiding an object in Zope In Zope 2.3, there is a way, at least for all forms of scripts: The REQUEST object has a new key "PUBLISHED". It contains the published object. A script can check whether it itself was the published object and raise an exception in this case. Dieter

1 0

Re: [Zope] Problem : ZCatalog (plain-text email this time)
by Dieter Maurer 26 Jan '01

26 Jan '01

Fabien Germain writes: > I have a ZCatalog with lots of entries. I added the index "absolute_url" in > order to search by the files url. > > Why ? > 'cause I have files in organized folders like that : > ........./language_name/country_name/city_name/element > > I'd like to do a search on "#language_name and #country_name and #city_name" > in my catalog, so I use the absolute_url. > But the problem is that the search only looks the end of the absolute_url > string, that's to say "element" in my exemple. It is strange that you apparently see it looking at the end as Splitter("abcd/bcde/cdef") = ["abcd/bcde/cdef"] i.e. it should only look at the complete URL. Probably, you should not use a textindex for your purpose, as it does not split at '/'. You should go for a keyword index. It expects a sequence of keywords rather than a string. Thus, you should replace "absolute_url" by "getPhysicalPath". This will probably work nice, unless you use virtual hosts. Dieter

1 0

Re: [Zope] http protocol
by Dieter Maurer 26 Jan '01

26 Jan '01

Oliver Vecernik writes: > I'd like to write an http client for an embedded system to get > information from Zope. For debugging I want to see the traffic between > the client and Zope (http protocol). How can this be achieved? Shane's TCPWatch Dieter

1 0

Re: [Zope] "Acquisition Algebra"; interaction of containment and acquisition is confusing
by Dieter Maurer 26 Jan '01

26 Jan '01

Fred Yankowski writes: > .... > <http://www.digicool.com/releases/ExtensionClass/Acquisition.html>? > I think I understand how the various "complex expressions" relate to > the equivalent expression in terms of the '__of__' operator, except > for the very last case, "a.b.c.x". I just can't follow why the > equivalent expression isn't > > x.__of__(a).__of__(c.__of__(b.__of__(a))) > > rather than the more complex answer given: > > x.__of__(a).__of__(b.__of__(a)).__of__(c.__of__(b.__of__(a))) Acquisition wrappers are ExtensionClass instances with an "__of__" method. Whenever, you look up an attribute in an ExtensionClass instance, "i", and the directly looked up object, "o", (!) has an "__of__" method, the result is not "o" but "o.__of__(i)". In your example, "x" is looked up in "c.__of__(b.__of__(a))". If we assume, that "x" has a "__of__" method, the result will be: "x1.__of__(c.__of__(b.__of__(a))" with "x1" the result of directly looking up "x" in "c.__of__(b.__of__(a))". "x" is first looked up in "c". As it is not found there, it is looked up in "b.__of__(a)". Thus, we have "x1=(b.__of__(a)).x" As "b.__of__(a)" is an ExtensionClass instance (and we assumed "x" has an "__of__" method). The result will be "x2.__of__(b.__of__(a))" with "x2" the result of directly looking up "x" in "b.__of__(a)". "x" is first looked up in "b". As it is not found there, it is looked up in "a". Thus, we have "x2= a.x" If "a" is an ExtensionClass instance, then "a.x" is "x.__of__(a)". Put things together and you will get the complex result. Dieter

1 0

"Acquisition Algebra"; interaction of containment and acquisition is confusing
by Fred Yankowski 26 Jan '01

26 Jan '01

Can anyone help me understand what's going on in the last example of the main "Acquisition" document, <http://www.digicool.com/releases/ExtensionClass/Acquisition.html>? I think I understand how the various "complex expressions" relate to the equivalent expression in terms of the '__of__' operator, except for the very last case, "a.b.c.x". I just can't follow why the equivalent expression isn't x.__of__(a).__of__(c.__of__(b.__of__(a))) rather than the more complex answer given: x.__of__(a).__of__(b.__of__(a)).__of__(c.__of__(b.__of__(a))) When I run the test cases given in the document I see that the latter does match the behavior, but I find that baffling. In particular, why is the effective search order x-a-b-c rather than x-a-c-b? It almost looks like the effective search order could be described as "up through the containment heirarchy, then down through the remaining acquired path", but I'm not at all sure if that's a valid generalization. Can anyone shed some light on this for me? -- Fred Yankowski fred(a)OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA

2 3