- Zope - Zope lists

Help Needed - Case for Zope
by Samir Mishra 02 Mar '03

02 Mar '03

Hello all, My manager has requested comments on whether Zope "performs like a dog". I'm doing some digging around at the moment, but, in the meantime, if anyone has any links to recommend, benchmarks, experiences to share, that I can use to counter his 'assertion', it would be much appreciated. Thanks. Regards, Samir.

4 3

Returning a random image from a folder
by David Mitchell 01 Mar '03

01 Mar '03

Going mad with this one... I'm trying to write a Python script to return a random image from a specified folder. For example, here's how I may want to call it from a ZPT page: <span tal:replace="randomImage('Advertisements/BannerAds') / > My randomImage Python script is as follows (where 'directory' is the parameter being passed to the script): import string import random directory_context = string.replace("/", ".", directory) return directory + "/" + random.choice(context.directory_context.objectValues('Image')) Some of you may recognize this as being almost an exact copy of the script on p151 of "The Zope Book", with the only difference being that I'm trying to pass a folder name as a parameter. I'm pretty sure I need to do the directory_context step, but I can't get it to work either with or without it. Where I'm really struggling is in getting my head around the context stuff. Can anyone offer me some assistance? Thanks in advance Dave Mitchell

3 2

management_page_charset
by Milos Prudek 01 Mar '03

01 Mar '03

Hi, What are the acceptable values for management_page_charset ? Where should this property be placed, so that it applies for the whole site ? -- Milos Prudek

1 0

RE: [Zope] List subfolders within any folder
by Samir Mishra 01 Mar '03

01 Mar '03

I had a similar problem. The tree does not seem to work if called from a DTML document, but is OK when called from a DTML Method. Try calling the original __DTML Method__ from another __DTML Method__. Dieter Maurer pointed me in the right direction. There are more details on this in the original mail. Also, another recent thread recommends using "ZUtils" for site trees. Samir. -----Original Message----- From: Michael Fox [mailto:Michael@CenturySoftware.com.au] Sent: Friday, February 28, 2003 08:33 To: zope(a)zope.org Subject: [Zope] List subfolders within any folder Hi *, I'm having problems with a relatively easy task. I have a DTML Method which contains: <dtml-in expr="objectValues('Folder')" sort="title" skip_unauthorized> <li><a href="&dtml-absolute_url;"><dtml-var title_or_id></a></li> </dtml-in> Which when I "view" on it's own happily lists the folders within my root folder. Yet somehow when I reference this object with another DTML Document, it list nothing?! Any help appreciated. Regards, Michael _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

1 0

Fwd: ANN: eGenix mxODBC Zope Database Adapter, Version 1.0.0
by Dylan Reinhardt 28 Feb '03

28 Feb '03

Saw this in comp.lang.python, thought it might be of interest hereabouts. Haven't used it myself. Dylan >From: "M.-A. Lemburg" <mal(a)lemburg.com> >Organization: eGenix.com Software GmbH >To: "Python List @ Python.org" <python-list(a)python.org> >Subject: ANN: eGenix mxODBC Zope Database Adapter, Version 1.0.0 >Date: Fri, 28 Feb 2003 21:59:37 +0100 > >________________________________________________________________________ >ANNOUNCEMENT > > EGENIX.COM > > mxODBC Zope Database Adapter > > Version 1.0.0 > (for Zope 2.5 and 2.6) > >________________________________________________________________________ >INTRODUCTION > >The eGenix mxODBC Zope Database Adapter (Zope DA) allows you to easily >connect your Zope installation to just about any database backend on >the market today, giving you the reliability of the commercially >supported eGenix.com product mxODBC and the flexibility of the ODBC >standard as middle-tier architecture. > >Unlike Zope's ZODBC Zope DA, the mxODBC Zope DA works on Windows >XP/NT/2000/98/95, Linux and Solaris using the same interface on all >platforms. > >The mxODBC Zope DA implements thread-safe connection pooling and >multiple physical connects per logical Zope connection. You can safely >run Z SQL Methods in parallel, achieving a much better performance >than ZODBC Zope DA or similar Zope database adapters under heavy load. >This makes it ideal for deployment in Zope Clusters and Zope hosting >environments where stability and high performance are a top priority. > >________________________________________________________________________ >FEATURES > >* Zope Level 3 Database Adapter: the mxODBC Zope DA is fully > multi-threaded and can handle multiple connections to multiple > databases. > >* Fully compatible to Z SQL Methods. > >* Fully compatible to the Znolk SQL Wizard Product and other similar > products relying on the common database schema access methods > .tables() and .columns(). > >* Connection Pooling: physical database connections are pooled and > kept open, to reduce the connection overhead to a minimum. This is > especially important for high latency database connections and ones > like Oracle which take a considerable amount of time to setup > >* Parallel Execution of Queries on a single logical connection: the > mxODBC Zope DA can manage any number of physical connections on a > single logical connection. This enables running truly parallel Z SQL > Method queries -- a feature not available in other Zope DAs. > >* Robust Mode of Operation: connections which have timed out or go > away due to network problems are automatically reconnected. > >* Cross-platform Connection Objects: The Zope DA will automatically > choose the right platform specific ODBC manager for you. > >* Per Connection Adjustable ODBC Interface: mxODBC comes with many > different subpackages to choose from on Unix. The Zope DA allows you > to select these subpackages on a per-connection basis. > >* Per Connection Error Handling: you can tell each connection whether > it should report ODBC warnings or not; furthermore all warnings and > errors are made available as list .messages on the DatabaseConnection > object. > >* Transaction safe automatic reconnect: when the DA finds that a > connection has timed out, it automatically tries a reconnect > and replays the transaction on the connection (unlike other DAs > which break the transaction scheme by doing a reconnect without > replay). > >* Built-in Schema Cache: this results in improved performance under > heavy load. > >* Database Schema Access: all ODBC catalog methods are made available > for much better database schema inquiry. The catalog methods allow > building generic database interrogation or manipulation tools and > facilitates writing database independent Zope products. > >________________________________________________________________________ >MORE INFORMATION > >For more information on the mxODBC Zope DA, licensing and download >instructions, please visit our web-site: > > http://www.egenix.com/ > >________________________________________________________________________ > >Thank you, >-- >Marc-Andre Lemburg >eGenix.com > >Professional Python Software directly from the Source (#1, Feb 28 2003) >>>>Python/Zope Products & Consulting ... http://www.egenix.com/ >>>>mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ >________________________________________________________________________ >Python UK 2003, Oxford: 32 days left >EuroPython 2003, Charleroi, Belgium: 116 days left > > > >-- >http://mail.python.org/mailman/listinfo/python-list >

1 0

urgent! wrong query results on next/previous urls in ZSQL/Zsearch
by k0878290＠tiscali.de 28 Feb '03

28 Feb '03

Hi folks, I'm 3 days before rollout of my first Zope project and now discover my ZSQL / Z Search Interface yields wrong query results! Only the first 20 query results are o.k., navigating around with next/previous "forgets" the user search form inputs constructing the SQL WHERE clause. Details: 1. I Use Zope 2.6.0 with python 2.1.3 and mysql 3.23-48. 2. First I created a zsql method: select * from usertable <dtml-sqlgroup where> <dtml-sqltest Userid op=like type=nb optional> <dtml-and> <dtml-sqltest Nachname op=like type=nb optional> <dtml-and> <dtml-sqltest Vorname op=like type=nb optional> </dtml-sqlgroup> 3. Then I added an Z Search Interface, which produced the following page templates: ########################################################## ... <form action="fp1b" method="get"> <h2 tal:content="template/title_or_id">Title</h2> Enter query parameters:<br><table> <tr><th>Userid</th> <td><input name="Userid" width=30 value=""></td></tr> <tr><th>Nachname</th> <td><input name="Nachname" width=30 value=""></td></tr> <tr><th>Vorname</th> <td><input name="Vorname" width=30 value=""></td></tr> <tr><td colspan=2 align=center> <input type="SUBMIT" name="SUBMIT" value="Submit Query"> ... ########################################################## ... <body tal:define="results here/fp1user_query_sqlmethode_argu; start request/start|python:0; batch python:modules['ZTUtils'].Batch(results, size=20, start=start); previous python:batch.previous; next python:batch.next"> <p> <a tal:condition="previous" tal:attributes="href string:${request/URL0}?start:int=${previous/first}" href="previous_url">previous <span tal:replace="previous/length">20</span> results</a> <a tal:condition="next" tal:attributes="href string:${request/URL0}?start:int=${next/first}" href="next_url">next <span tal:replace="next/length">20</span> results</a> </p> <table border> <tr> <th>Userid</th> <th>Vorname</th> <th>Nachname</th> </tr> <div tal:repeat="result batch" > <tr> <td><span tal:replace="result/Userid">Userid goes here</span></td> <td><span tal:replace="result/Vorname">Vorname goes here</span></td> <td><span tal:replace="result/Nachname">Nachname goes here</span></td> </tr> ... <a tal:condition="previous" tal:attributes="href string:${request/URL0}?start:int=${previous/first}" href="previous_url">previous <span tal:replace="previous/length">20</span> results</a> <a tal:condition="next" tal:attributes="href string:${request/URL0}?start:int=${next/first}" href="next_url">next <span tal:replace="next/length">20</span> results</a> </p> ... ######################################################### 4. A direct test of the ZSQL in the test tab works perfectly, e.g. searching all userids starting with C produces 20 results, you click "next 20 results" and get the next 20 hits and so on. 5. When using the Zope-generated Z Search page templates, you can also choose your query parameter C% and get the first 20 hits correctly. BUT: IF YOU NOW PRESS NEXT 20 RESULTS, YOU GET THE 20 VERY FIRST ROWS OF THE WHOLE TABLE! 6. A MySql Trace shows that the first query is SELECT * FROM usertable WHERE userid LIKE C%; this is fine clicking the "next url" yields another query with SELECT * FROM usertable; 7. Obviously something must be wrong with the "next url": <a tal:condition="next" tal:attributes="href string:${request/URL0}?start:int=${next/first}" It does not know about the SQL query parameters from the first call!? 8. Any ideas how to navigate correctly through this ZSQL result ? When I compare to the ZSQL test tab, there a much longer url is composed when going to the "next 20 results" link. Regards Peter __________________________________________________________________ Tiscali Mobile NEU! Die neuesten Klingeltöne, Logos, Mailboxsprüche, Bildmitteilungen und Screensaver für alle Handytypen. Einfach und günstig! Klicken Sie hier: http://www.tiscali.de/mobile/

3 3

Inserting an object automagically on folder creation
by Nicolas Évrard 28 Feb '03

28 Feb '03

Hello everyone, A long time ago I posted some question and finally made it to the creation of my first product, now I'm back I'm still thinking on how I will design my product but here are some caracteristics I'd like my product to have A) I'd like to create two way to represent data. In the first one the data is stored in in ZODB, in the second one the data is stored in a (possibly) remote database server. So I intend to do it this way : - Zpeople `- ZpeopleItemContainer (inheriting from Folder) `- ZpeopleItem (inheriting from SimpleItem) `- ZpeopleSQL (any pointer on how I can do this) I'd like ZpeopleSQL and ZpeopleItemContainer to have the same contract (ie: a search method with different flavour of search). Last but not least, 'a' being a ZpeopleSQL instance and 'b' being a ZpeopleItemContainer instance. Is it possible through some clever use of acquisition to acces the same kind of internal information by the same kind of url ? Example: localhost/folder/a/p1/name -> name of people whose id is p1 (DB version) localhost/folder/b/p1/name -> name of people whose id is p1 (ZODB version) B) I'd like to insert on a Product creation three objects. I use this code : def __init__(self, args) : self.clientsDB = ZpeopleSQL('clientsDB', dbConnection) self._setObject('clientsDB', self.clientsDB) is it gonna work ? Or maybe I should use this less elegant (at least IMHO) version : self.manage_addProduct['ZpeopleSQL'].manage_addPT(id='dkfj', db=dbConnection) Any help, flame, pointer appreciated ... -- (°> Nicolas Évrard / ) Liège - Belgique ^^

2 2

mySQLUserFolder/FTP question
by pskipworth＠touchcorp.com 28 Feb '03

28 Feb '03

Hi, I have a mysqlUserFolder in /my/folder, and have tried FTPing to my Zope server with username user@my/folder with the correct password, but it will not authenticate me. I've also tried user@/my/folder, which doesn't work either. Any ideas ? Cheers, P PETER SKIPWORTH SYSTEM ADMINISTRATOR TOUCHCORP LTD TELEPHONE 03 9635 2626 www.touchcorp.com

2 1

Re: Zope digest, Vol 1 #2626 - 24 msgs
by Matt Young 28 Feb '03

28 Feb '03

Re: [Zope] Approval of documents I haven't been brave enough to adjust the workflow yet, but I have read about DCWorkflow. Seems to be very logica. Take a look: http://www.zope.org/Members/hathawsh/DCWorkflow_docs/DCWorkflow_doc.pdf Matt

1 0

escape double quotes in page templates
by Mark Gibson 28 Feb '03

28 Feb '03

I've spent way too much time looking for this. Can I escape double-quotes in a python expression in page templates: <div tal:replace="python:'And he said, "Hi there".'"></div> How do I do this? Thanks, Mark

2 1