- Zope - Zope lists

MySQL Adapter for Zope Trouble
by CURTIS David 17 Feb '00

17 Feb '00

Greeting, I get getting a broken product witht the Zope MySQL Adapter. Is there an updated Adpater that works with the newer version of MySQL? I really don't want to test all version but would like to know. Dave

1 0

document repository product?
by Sean Kelley 17 Feb '00

17 Feb '00

I am very new to Zope and am looking for a way to set up an internal web server (on Windows) in my office to provide a way to allow my users to upload a document (word/excel/pdf/etc) and give it name, provide a description, provide the ability to delete the entry, and revise existing entries by modifying the descriptions as well as uploading replacement documents. I could map a drive to the folder and allow users to copy their files to and from it at the OS level, but then they still need to add it to the web page. I am trying to make it as simple as possible without teaching anyone how to use Zope or html. A one step solution. Making the repository searchable or at least provide categories would be an added plus. Sean Kelley EPC Identification Systems/ Q-Cee's Product Corporation Direct: (707) 360-2347 Phone: (707) 575-3336 ext. 2347 Fax: (707) 575-3337 www.epc1.com www.q-cees.com

1 0

Why does the MySQL adapter not work with MySQL and Zope
by CURTIS David 17 Feb '00

17 Feb '00

Hi, Recently I needed to upgrade my MySQL version and now my Zope database connection is broken. Is there a newer patch for the MySQL adapter? Using ZMySQLDA-1.1.3-nobin.tar.gz and ZMySQLdb-0.1.0. I used the Alan Progman instructions to install. Perhaps there is a better database that I can use that is less Zope fussy? It seems problamatic. Is there any hope of an improved Adapter installation method also? Thanks in advance.

1 0

Wrong mailing list description?
by Oscar Picasso 17 Feb '00

17 Feb '00

on http://www.zope.org/Resources/MailingLists you can read: >Zope-Mozilla [Archives] Discussions about the development of the new Mozilla-based management interface. > >Zope-PTK [Archives] Discussions about the development of the new Mozilla-based management interface. > It seem the last description is wrong. Doesn't it? ****************************************************** Oscar Picasso picasso(a)videotron.ca ******************************************************

1 0

Re: [Zope] user created folders and local owner role problem in 2.1.3
by Tres Seaver 17 Feb '00

17 Feb '00

"Cornelis J. de Brabander" <brabander(a)fsw.leidenuniv.nl> wrote: > To: "zope" <zope(a)zope.org> > Subject: [Zope] user created folders and local owner role problem in 2.1.3 > Date: Thu, 17 Feb 2000 11:04:02 +0100 > charset="iso-8859-1" > > Silence was my part after an ealier effort, so I'll give it another try. > I have a application for web supported learning, basically a platform where > teachers and students can exchange information. It runs in zope 2.0.0. Users > may create documents or folders by means of a dtml-method that wraps > manage_clone. In version 2.0.0 the user automatically acquires a local role > of owner in the context the folder or document involved. > When I was upgrading to zope version 2.1.3 I noticed this automatisme did > not apply anymore to folders, but only to documents: users are not given the > local owner role in he context of a folder they create. Bug or feature? > It is a problem, because what users ar permitted to do depends to a certain > extent on ownership. Please help me out. > tia, cb Ok, from the horse's mouth ("Trust the source, Luke!"): [/home/tres/Zope2/lib/python/OFS] $ \ cvs diff -u -r Zope-2_0_0-src -r Zope-2_1_3-src ObjectManager.py Index: ObjectManager.py =================================================================== RCS file: /cvs-repository/Zope2/lib/python/OFS/ObjectManager.py,v retrieving revision 1.80 retrieving revision 1.82 diff -u -r1.80 -r1.82 --- ObjectManager.py 1999/07/22 19:19:22 1.80 +++ ObjectManager.py 1999/11/04 19:34:20 1.82 @@ -84,9 +84,9 @@ ############################################################################## __doc__="""Object Manager -$Id: ObjectManager.py,v 1.80 1999/07/22 19:19:22 jim Exp $""" +$Id: ObjectManager.py,v 1.82 1999/11/04 19:34:20 brian Exp $""" -__version__='$Revision: 1.80 $'[11:-2] +__version__='$Revision: 1.82 $'[11:-2] import App.Management, Acquisition, App.Undo, Globals, CopySupport, Products import os, App.FactoryDispatcher, ts_regex, Products @@ -230,12 +230,15 @@ self._setOb(id,object) object=self._getOb(id) object.manage_afterAdd(object, self) - # Try to give user the local role "Owner". + + # Try to give user the local role "Owner", but only if + # no local roles have been set on the object yet. if hasattr(self, 'REQUEST') and hasattr(object, '__ac_local_roles__'): - user=self.REQUEST['AUTHENTICATED_USER'] - name=user.getUserName() - if name != 'Anonymous User': - object.manage_setLocalRoles(name, ['Owner']) + if object.__ac_local_roles__ is None: + user=self.REQUEST['AUTHENTICATED_USER'] + name=user.getUserName() + if name != 'Anonymous User': + object.manage_setLocalRoles(name, ['Owner']) return id def manage_afterAdd(self, item, container): @@ -526,8 +529,7 @@ mtime=self.bobobase_modification_time().timeTime() # get owner and group owner=group='Zope' - for r in self.get_local_roles(): - user,roles=r + for user, roles in self.get_local_roles(): if 'Owner' in roles: owner=user break At a guess, the folder that you clone has local roles attached? I think you would be best off to just force the ownership yourself after the clone: <dtml-let username="AUTHENTICATED_USER.getUserName()"> <dtml-call "manage_setLocalRoles( username, [ 'Owner' ] )"> </dtml-let> -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

Accessing Objects in a ZClass from an Instance
by Jason Spisak 17 Feb '00

17 Feb '00

Zopists, Is there any way to access (objectValues() doesn't work) the methods or objects inside a ZClass from inside and instance of that ZClass? All my best, -- Jason Spisak 444(a)hiretechs.com

1 0

Re: [Zope] StructuredDocuments
by Tres Seaver 17 Feb '00

17 Feb '00

Jeff Hoffman <jeff(a)goingv.com> wrote: > > Hey, guys. > > For what it's worth, I got a simple StructuredDocument ZClass to work, > even when used as index_html. Here's how: > > I created a Python product called StructuredDocumentBase that included a > class of the same name. This class is defined as follows: > > from OFS.DTMLDocument import DTMLDocument > from StructuredText.StructuredText import html_with_references > > class StructuredDocumentBase: > """Mix-in for StructuredDocument ZClass.""" > def __call__(self, client = None, REQUEST = {}, RESPONSE = None, > **kw): > """Render the document given a client object, REQUEST mapping, > response, and keyword arguments.""" > header = apply(self.standard_html_header.__call__, > (client, REQUEST), > kw) > body = html_with_references(apply(DTMLDocument.__call__, > (self, client, REQUEST), > kw)) > footer = apply(self.standard_html_footer.__call__, > (client, REQUEST), > kw) > return '%s%s%s' % (header, body, footer) > > Then, I created another product called StructuredDocument, this time > through the web. In this product, I created a ZClass called > StructuredDocument, which inherits first from StructuredDocumentBase and > then from DTMLDocument. > > Then, I placed an instance in a folder, navigated to the URL, and it > worked. > > I would package it up and upload it as a product, but a part of it is > broken--I can't rename the instance. This has nothing to do (AFAICT) with > the __call__ voodoo above, but seems to be due to my inheriting from > DTMLDocument; I created a simple ZClass that did nothing except inherit > from DTMLDocument and it exhibited the same behavior. > > Anyways, Tres (or anyone using Tres's product), if you want to take this > idea and integrate it into your STX_Document class that'd be cool. If not, > I'll make a more complete (and tested) implementation when I can find the > time. Ooops, I didn't read far enough forward. I just posted a modification to the ZClass solution which uses Lalo's RenderableZClass product to fix the problem. I haven't uploaded the modified STX_Document product, because I'm still wrestling with whether to force the dependency on Lalo's product. Tres. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

Re: optimized HTML for the manage interface
by Robb Shecter 17 Feb '00

17 Feb '00

Hi, I saw that the html in my first post got mangled, so I am attching the lib/python/OFS/main.dtml file as an attachment... - Robb

1 0

RE: [Zope] Determining Success or Failure status on SQL update in ZSQL Metho d d
by Ira Hochman 17 Feb '00

17 Feb '00

Thanks for the response. It sounds right to me, but the sql method seems to return an object. My skill with Zope or Python is not quite at the level where I know how to interrogate this object for a record count. When I use the following test code (where upd is the id of the SQLMethod) <dtml-let foo="upd()"> foo is <dtml-var foo> </dtml-let> I get back foo is <Shared.DC.ZRDB.RDB.DatabaseResults instance at e7fef0> Right now I am trying out a SELECT with a <dtml-raise> prior to issuing the update. It's non-atomic and thus not ideal, but is an acceptable workaround until I can find a production worthy solution. I am still open to any and all suggestions. BTW, once I figure this out, I am definitely going to write it up. Would this be a tip or a howto? --ira -----Original Message----- From: Matthew Parslow [mailto:matt@umd.com.au] Sent: Wednesday, February 16, 2000 11:33 PM To: Ira Hochman; zope(a)zope.org Subject: Re: [Zope] Determining Success or Failure status on SQL update in ZSQL Metho d d what about <dtml-let "rows_affected=sql_query(params=param)">? and then check if rows_affected is >0 Regards, Matthew Parslow On Thu, 17 Feb 2000, you wrote: > Hello, > > A search of prior discussion threads shows this question occasionally > appears without resolution. Perhaps someone has found an answer to it since > then, so here it is... > > Using a ZSQL method, how do I detect if any rows have been affected when > performing a SQL UPDATE. I do not need to know how many rows, just whether > the statement affected 0 rows or more than 0 rows. > > My environment is Oracle (7 & 8) and with other programmatic interfaces to > Oracle, one can capture a (non-error) return status that indicates if no > rows were affected. This is supported in the ODBC API for Oracle and other > databases as well. Is there a way to capture this return status even though > it is not flagged as an error? > > No dtml-try since it's only a return code, not an error code > > As a workaround I've tried to do a select count, but to do this I need to > 1) execute the select and update in the same transaction and > 2) run the select before the update, store the value, then return it at the > end (the update may or will change at least one of the fields referenced in > the where clause, so I cannot run it after) > > So, inside of a SQL method, I can do #1, but cannot see a way to do #2. > > Is there a secret trick to this or is it a case of adding code to the > existing DAs? Please please tell me it's the former. > > Thanks in advance, > Ira > > _______________________________________________ > 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 1

Apache + ZServer + SiteAccess
by Meng Kuan 17 Feb '00

17 Feb '00

Hi, I was previously using the fastcgi solution but recently switched to use anser's solution as given in the how-to: http://www.zope.org/Members/anser/apache_zserver Everything has been working solidly (and fast!) until I found out that it can't seem to do a recatalog properly. Details are: Zope 2.1.4 + apache 1.3.9 on Debian potato. Zope is served off http://myserver.com/Zope/. I have a product called Sample that subclasses ZCatalog and reindexes its objects when edited. However, now when I tried to perform an edit, the following error message results: Error Type: ValueError Error Value: Uncatalog of absent id 'Zope/Sample/Object1'  My guess is that it was previously catalogued as 'Sample/Object1' but ZCatalog now gets the uid of the object as 'Zope/Sample/Object1'. Is there anything that I can do to overcome this? Will installing a SiteRoot in Catalog (my default catalog object) itself help? Any help is appreciated, Thanks Meng Kuan

2 1