- Zope - Zope lists

ER: [Zope] Looking if a record with a given key exists in a database several times, in dtml
by Igor Leturia 20 Feb '02

20 Feb '02

Hi Steve! I've tried your suggestion (and I think I've done it correctly), but I get an error: Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: key Any idea? Igor Leturia >-----Jatorrizko mezua----- >Nondik: Steve Spicklemire [mailto:steve@spvi.com] >Bidalia: Igandea, 2002.eko otsailak 17 21:13 >Nora: Igor Leturia >Cc: Steve Spicklemire; zope(a)zope.org >Gaia: Re: [Zope] Looking if a record with a given key exists in a >database several times, in dtml > > >Your idea sounds reasonable.. are you asking how to implement >it, or is >there some other problem? I would think you could create a >python script >that returns a dictionary that could be used to lookup results. >Something like: > >buildCache with argument "results" > >cache_dict = {} > >for result in results: > cache_dict[result.key] = result > >return cache_dict >----------------- > >called from DTML as: > ><dtml-let theCache="buildCache(results=yourQuery())"> ><dtml-in ....> ><dtml-if "theCache.has_key(yourTestKey)"> ><dtml-let theResult="theChache[yourTestKey]"> >Do something with "theResult".. ></dtml-let> ></dtml-if> ></dtml-in> ></dtml-let> > >Does that help? >-steve > >On Sunday, February 17, 2002, at 02:42 PM, Igor Leturia wrote: > >> Hi all! >> >> I have a problem: in dtml, I have to iterate through a >very big list >> and for each item I must look if there is a record with that key in a >> database. I can't run a 'select' ZSQLMethod for each, >because it would >> take too long. What I want to do is run the 'select' >ZSQLMethod once and >> load the results in a variable (an array or dictionary) >which then will >> be faster to look up in, or look up in the results of that >query in some >> fast way. >> >> I have searched zope.org, but found nothing. Any ideas? >> >> Igor Leturia >> >> _______________________________________________ >> 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 ) > >

2 2

System Error from Zope Book Example
by Dan Shafer 20 Feb '02

20 Feb '02

On page 157 of the Zope Book is an example of using an external Python script to create thumbnails of graphic images. The main makeThumbnail script works fine. Creating the Python script makeThumbnails and running it generates a System Error "bad argument to internal function." Here's the script I've written, which I am pretty sure matches the one in the book: for image in context.objectValues('Image'): if not image.hasProperty('original_id'): context.makeThumbnail(image.getId()) Here's the dump portion of the error message page:. I'd appreciate any input you have for me. I'm completely bewildered. Traceback (innermost last): File /home/dshafer/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /home/dshafer/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/dshafer/Zope-2.3.3-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /home/dshafer/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/dshafer/Zope-2.3.3-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: makeThumbnails) File /home/dshafer/Zope-2.3.3-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: makeThumbnails) File /home/dshafer/Zope-2.3.3-src/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: makeThumbnails) File /home/dshafer/Zope-2.3.3-src/lib/python/Shared/DC/Scripts/Bindings.py, line 354, in _bindAndExec (Object: makeThumbnails) File /home/dshafer/Zope-2.3.3-src/lib/python/Products/PythonScripts/PythonScript.py, line 336, in _exec (Object: makeThumbnails) (Info: ({'script': <PythonScript instance at 8bb3a30>, 'context': <Folder instance at 89c6c20>, 'container': <Folder instance at 89c6c20>, 'traverse_subpath': []}, (), {}, None)) File Script (Python), line 4, in makeThumbnails (Object: ssdrawing.jpeg) File /home/dshafer/Zope-2.3.3-src/lib/python/Products/ExternalMethod/ExternalMethod.py, line 269, in __call__ (Object: makeThumbnail) (Info: (('ssdrawing.jpeg',), {}, (128,))) File /home/dshafer/Zope-2.3.3-src/Extensions/Thumbnail.py, line 16, in makeThumbnail (Object: Traversable) SystemError: (see above) -- Dan Shafer, Personal Creativity Trainer and Consultant Trained Hartman Value Profile Analyst http://www.danshafer.com/valueprofile.html

8 15

Re: [Zope] inserting form value to the table
by H.de.Wit＠SFK.NL 20 Feb '02

20 Feb '02

>I want to be able to extract the values enter through a form and >store it in a dbase. Read Zope book chapter 12 formerly known as chapter 10: http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml Hans de Wit Stichting Farmaceutische Kengetallen Postbus 30460 2500 GL DEN HAAG Tel. 070-3737448 Fax 070-3737445

1 0

htmllib and my little remote webcache project
by Ed Colmar 20 Feb '02

20 Feb '02

Hey all! So, I've started on my little remote webcache project. Thanks for all the suggestions and ideas. Mostly I think it'll be a fun adventure, not because it has any real practical value. I'm messing around with htmllib, to parse out the page and (hopefully) rewrite the URLs to what they should be. I'm having trouble with it though. I havent fully grasped how it works. If someone could take a quick look at my code and see if I'm doing anything obviously wrong, that would be great! Essentially it's parsing ok, but I haven't figured out how to replace values, or how to get the data back out when it's finished. =========================== class ImageParser(htmllib.HTMLParser): def __init__(self, verbose=0): self.images = [] # Make some kind of storage class to hold the new values f = formatter.NullFormatter() # Not sure what this is for htmllib.HTMLParser.__init__(self, f, verbose) # Initialize the parser def handle_image(self, src, alt, *args): """This is called everytime we get an Image throught the parse """ print "[got image] %s" % src # Yay newimageid=createId() # Get a unique id for this image self.parsedfiletemp = self.parsedfiletemp + newimagetag # move the new image data into the new file def handle_data(self, data): """This is the data between the parsed cells """ print "got data %s" % data # YAY!! self.parsedfiletemp = str(self.parsedfiletemp) + str(data) # move the data into the new file def flush(self): """ The end of the parse? """ print "[got Flush] " # YAY!! # save the data or something. +++++++++++++++++++++++ Mostly this does what it should but it gives: Error Type: IOError Error Value: [Errno 5] Input/output error File /usr/local/dc/zope/Extensions/localpagecache.py, line 72, in handle_data Is there another way that I should be keeping track of the data after it goes through the parser? THANKS! -ed-

1 0

iplanet enterprise web server 6.0 on Solaris 5.8
by jbr＠FIZ-Karlsruhe.DE 20 Feb '02

20 Feb '02

Hello, I have searched for information how to connect zope to iplanet server but found only documents related to apache. Here at our site we are running iplanet enterprise web server 6.0 on SUN Solaris 5.8 Does anybody know how to connect this webserver to the zope server ? Is it done by URL Forwarding ? Thanks in advance. With kind regards, Juergen Berger

2 1

ZSQL and last_insert_id
by Chad Nantais 20 Feb '02

20 Feb '02

What is the right syntax for getting the id of the last recorded inserted with ZSQL methods? I tried this: SELECT LAST_INSERT_ID() AS last_insert_id The resulting error is: Traceback (innermost last): File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/2.4.4b1/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: last_insert_id) File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_test) File /usr/local/zope/2.4.4b1/lib/python/Shared/DC/ZRDB/DA.py, line 400, in manage_test (Object: last_insert_id) File /usr/local/zope/2.4.4b1/lib/python/Shared/DC/ZRDB/DA.py, line 378, in manage_test (Object: last_insert_id) File /usr/local/zope/2.4.4b1/lib/python/Shared/DC/ZRDB/DA.py, line 493, in __call__ (Object: last_insert_id) File /usr/local/zope/instance/Products/ZMySQLDA/db.py, line 252, in query OperationalError: (1064, "You have an error in your SQL syntax near 'last_insert_id LIMIT 1000' at line 1"

4 3

Error(200): python exceptions
by Cornelis J. de Brabander 20 Feb '02

20 Feb '02

I have a Zope server serving several applications. Some applications are still in use, though their authors have left the scene. I am plagued regularly by python exceptions of which below is an example. I simply do not know where to start looking. Can anybody give me a hint? Current setup: Windows NT Zope 2.4.3 2002-02-19T16:14:42 ERROR(200) ZServer uncaptured python exception, closing channel <zhttp_channel connected 62.234.42.8:1113 at 2bbb72c channel#: 6080 requests:> (exceptions.ValueError:unpack list of wrong size [E:\zope\243\bin\lib\asyncore.py|poll|95] [E:\zope\243\bin\lib\asyncore.py|handle_read_event|383] [E:\zope\243\ZServer\medusa\asynchat.py|handle_read|113] [E:\zope\243\ZServer\medusa\http_server.py|found_terminator|456] [E:\zope\243\ZServer\medusa\http_server.py|found_terminator|152] [E:\zope\243\ZServer\HTTPServer.py|found_terminator|174] [E:\zope\243\ZServer\HTTPServer.py|continue_request|309] [E:\zope\243\ZServer\HTTPServer.py|get_environment|287]) This was the last exception I caught. I remember that before I upgraded from Zope 2.1.6 the exception was not a value error but an attribute error: exceptions.AttributeError:'int' object has no attribute 'send' TIA Cornelis J. de Brabander ========================================== Department of Education, Leiden University P.O.Box 9555, NL-2300 RB Leiden +31 71 527 3422/3401 brabander(a)fsw.leidenuniv.nl ==========================================

2 2

Re: Anyone know of a product that can...
by Tim Owen 20 Feb '02

20 Feb '02

Sorry about the @#%$^* previous non-text email. Got to figure out a way to turn the formatted email off by default... Regards. ----- Original Message ----- From: Tim Owen To: zope(a)zope.org Sent: Wednesday, February 20, 2002 10:00 AM Subject: Anyone know of a product that can... manage a directory of businesses for a local chamber of commerce (read this as very little $$$ to spend). Want it to be somewhat self managing (create a listing and manage a listing by the businesses themselves using a predefined format) but retaining the review and publish rights for manager of the site. Basic listing is no cost, but upgraded listings (extended information, link to another web site, inclusion of logos, etc.) would have a cost. Other functions required: category, location, and other criteria based searches, potentially include banner ads, email integration for information requests. Site could just use ZODB since the number of listings should be under 1000, but might grow to 5000. I suppose Gadfly or MySQL could be used if this seems large for ZODB. I was thinking about Formulator, Metapublisher, CMF, etc. but was not sure the best route to go. Thoughts? Thanks in advance, Tim Owen This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies.

1 0

Anyone know of a product that can...
by Tim Owen 20 Feb '02

20 Feb '02

manage a directory of businesses for a local chamber of commerce (read this as very little $$$ to spend). Want it to be somewhat self managing (create a listing and manage a listing by the businesses themselves using a predefined format) but retaining the review and publish rights for manager of the site. Basic listing is no cost, but upgraded listings (extended information, link to another web site, inclusion of logos, etc.) would have a cost. Other functions required: category, location, and other criteria based searches, potentially include banner ads, email integration for information requests. Site could just use ZODB since the number of listings should be under 1000, but might grow to 5000. I suppose Gadfly or MySQL could be used if this seems large for ZODB. I was thinking about Formulator, Metapublisher, CMF, etc. but was not sure the best route to go. Thoughts? Thanks in advance, Tim Owen This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies.

1 0

login manager on 2.5.0
by honey bee 20 Feb '02

20 Feb '02

1 0