- Zope - Zope lists

Traversal of ZODB
by David Trudgett 03 Jul '00

03 Jul '00

I wonder if anyone has a sample Python script that traverses the ZODB to query or perform arbitrary operations on the objects found in it? My present requirement is to write a script that goes through and does some automated updating of several dozen DTML documents. Thanks. David Trudgett

2 1

Re: [Zope] MySQL Select Statements
by Dieter Maurer 03 Jul '00

03 Jul '00

Michael Blewett writes: > Select Column1, Column2 etc > from TableA. > > Instead I must use the AS statement ie > > Select Column1 AS Column1, Column2 AS Column2 > from TableA. Zope should not be responsible for this strange behaviour. It simply executes the SQL statement and asks the result for the result column names. It then wraps each result row in an object that allows to access a column value as attribute under the respective column name. You could try: <dtml-let SQLresult=SQLMethod> <dtml-var "SQLresult.names()"> </dtml-in> to get the list of column names your Z SQL Method "SQLMethod" returns. This may give you a hint how your database names result columns. I recently found out that Oracle returns column names converted into all uppercase. I needed about 2 hours to analyse this weird behaviour. Dieter

2 1

Re: [Zope] calling standard_html_header from external methods
by Dieter Maurer 03 Jul '00

03 Jul '00

Daryl Tester writes: > Dieter Maurer wrote: > > > The __call__ function of DTML methods gets the following > > arguments: client=None, mapping=None, **kw. > > > > You therefore may call it: "self.standard_html_header(self,REQUEST)" > > or "self.standard_html_header(None,REQUEST)". > > And what's the difference between passing in self or None? What > does the client parameter actually do? When you pass 'None', the DTML method can only use the content of REQUEST. If you pass "self", it can additionally use the direct and acquired attributes of "self". Dieter

2 1

Proxy role bug (or feature)
by Ng Pheng Siong 03 Jul '00

03 Jul '00

Hi, I have encountered a problem with proxy roles with my product GuardedFile. A GuardedFile is a File that is accessible by proxy only. When a GuardedFile is created, all acquired permissions are unset and a proxy role is created in its container with the sole permission 'view'. In all other aspects a GuardedFile behaves like a File. Typically, the GuardedFile creator next creates a DTML method and assigns to it the associated proxy role. Anonymous and other users access the GuardedFile via the DTML method. I've discovered a problem with the product setup: Suppose user 'ngps' exists in the top-level user folder, and has the default roles 'owner' and 'manager'. 1. ngps creates a folder called 'junk' somewhere within Zope. 2. ngps switches to the folder 'junk'. 3. ngps creates a GuardedFile 'agf'. A proxy role 'proxy_for_agf' is automatically created in 'junk'. 4. ngps creates a DTML method 'view_agf' to access 'agf'. When ngps tries to assign the role 'proxy_for_agf' to 'view_agf', the following error is generated: (Slightly reformatted for readability.) You are not authorized to change 'view_agf' because you do not have proxy roles. Traceback (innermost last): File C:\pkg\Zope220b3\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\pkg\Zope220b3\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\pkg\Zope220b3\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: view_agf) File C:\pkg\Zope220b3\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\pkg\Zope220b3\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_proxy) File C:\pkg\Zope220b3\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_proxy) File C:\pkg\Zope220b3\lib\python\OFS\DTMLMethod.py, line 273, in manage_proxy (Object: view_agf) File C:\pkg\Zope220b3\lib\python\OFS\DTMLMethod.py, line 266, in _validateProxy (Object: view_agf) Forbidden: (see above) The following works around this: 1. ngps creates a user folder in 'junk'. 2. ngps adds a user in 'junk' called 'user2', with roles 'owner', 'manager' and 'proxy_for_agf'. 3. Login as 'user2'; 'user2' is now able to assign the role 'proxy_for_agf' to the above-mentioned DTML method 'view_agf'. This proxy role handling seems unwieldy, in that 'ngps' cannot assign the proxy role but can create another user 'user2' that _can_ assign said proxy role. Is this a bug or a feature? Cheers. -- Ng Pheng Siong <ngps(a)post1.com> * http://www.post1.com/home/ngps

2 1

New for download: Image.py that is border-aware
by Jon Franz 03 Jul '00

03 Jul '00

The subject says it all... no more <dtml-var "foo.tag(border=0)"> type schtuff... http://www.zope.org/Members/Coventry/Border_aware_image Note: this was created, and tested, on Zope 2.1.6 - newer installations, or those with modifications to thier Image.py file in <zope-home>/lib/python/OSF should Not use the new file - they should compare the file and apply the changes by hand to thier Image.py to avoid version troubles.

1 0

Re: [Zope] ZCatalog pointing to wrong object.
by Dieter Maurer 03 Jul '00

03 Jul '00

Bart Holthuijsen writes: > I have been having some problems with ZClasses and the Catalog. > I made a new Catalogaware External Product, based mostly on the Boring and > Photo products. When I add an instance to a folder the Catalog is updated, > but doesn't point to the right object. ZCatalog has a set of bugs. You may find interesting information in the Collector URL:http://classic.zope.org:8080/Collector or in the zope mailing list archives (May 2000). Search for "lexicon". Dieter

1 0

medusa question
by Frank McGeough 03 Jul '00

03 Jul '00

Where does medusa look for html files by default? I have regular old html files that I'd like to make available without fiddling with Zope. Is that possible?

4 5

Re: [Zope] medusa question
by Adam Karpierz 03 Jul '00

03 Jul '00

>Where does medusa look for html files by default? I have regular old html >files that I'd like to make available without fiddling with Zope. Is that >possible? Yes , but through use Medusa as standalone server. Look at http://www.nightmare.com/medusa/index.html Download http://www.nightmare.com/medusa/medusa-src-20000601.tar.gz and look at and /docs directory, INSTALL.txt and especially, start_medusa.py. Adam Karpierz karpierz(a)alpha.pl

1 0

Local user groups (Virginia)
by J. Michael Mc Kay 03 Jul '00

03 Jul '00

Does anyone here know of a local (Virginia, Richmond, Fredericksburg area) ZOpe/Python users group....? ......checking for plain text setting. Yep....send. Thanks, J. Michael Mc Kay http://www.virginiaweb.com (under recon)

2 1

Zope/Apache Question.
by Angel R. Rivera 03 Jul '00

03 Jul '00

I would like to thank Bryan Stillwell <arcane(a)verinet.com> for his help-that is what i needed. I have Zope and Apache working together->except for the URL rewriting so I can use http://localhost/Zope and get it to launch... I am still reading docs but have multiple versions of RewriteRule. Any pointers greatly appreciated. Angel R. Rivera, angel(a)wolf.com -------------------------------------------------------------------------- Website: http://www.wolf.com Our Wolf: http://www.wolf.com/Ookami.html -------------------------------------------------------------------------- "The Quality of a person's life is in direct proportion to their commitment to excellence, regardless of their chosen field of endeavor." Vincent T. Lombardi

3 3