September 2000 - Zope-Dev

Re: [Zope-dev] ZSQL Methods from Python?
by Jim Fulton 22 Sep '00

22 Sep '00

"Phillip J. Eby" wrote: > > At 12:49 PM 9/22/00 -0400, Jim Fulton wrote: > >"Phillip J. Eby" wrote: > >> > >> Ty and I have put together a Stored Procedure method for Sybase; it > >> requires a minor patch to ZSybaseDA, however, to allow for the status code > >> return. I'm not sure how useful it would be to anyone else, though, since > >> all we ever do with stored procedures is process the return value, and > >> ignore any actual SELECT results. > > > >I think it would be useful. Can you get multiple return values? > > > > By "return value", I mean the "return status" code which is an integer > returned by the Sybase "RETURN" statement. Sybase also can generate its > own, negative-numbered return statuses, which indicate a Sybase error. > These error codes can include ones that mean the current transaction has > already been aborted. > > Apart from the "return value", a Sybase stored procedure can execute > SELECT's which result in rows being returned. We have never used this > capability, so I'm not sure what would need to be done for it to be > practical. We ordinarily use stored procedures only to perform inserts, > updates, deletes, and other things that only need a integer result if > anything. (Eg: get next counter value to assign an object identifier.) Ah, too bad. Can Sybase *only* return values through selected rows? Oracle's stored procedures are much more like traditional procedures and therefore extremely useful even when no results are returned. Jim -- Jim Fulton mailto:jim@digicool.com Python Powered! Technical Director (888) 344-4332 http://www.python.org Digital Creations http://www.digicool.com http://www.zope.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.

1 0

ZSQL Methods from Python?
by Monty Taylor 22 Sep '00

22 Sep '00

Hey, is there any doco about using ZSQL Methods from Python Products? Also, does anyone know of any work done to extend ZSQL Methods to allow stored-procedure calls? I know I can do an Oracle Procedure call from DCOracle that returns a cursor, but I'd love to combine that with the caching/pluggable brains of ZSQL Methods. Is there anything out there on this or am I going to have to roll my own? Thanks, Monty

3 4

Re: [Zope-ZEO] Advice
by Andy McKay 22 Sep '00

22 Sep '00

> > One of the reasons our group is moving away from Zope is that it has > > very poor support (if any) for the development/staging/live model. We > > like this model. We think it's a good thing. But sync'ing code across > > multiple Zope installations is a royal PITA. > > I'd like to hear more about the problems you've had and how > you overcome them in a different system. > > > And no, versions are *not* the answer. > > Well, they are a pretty good answer for lots of applications > in my experience. Version can work for small changes, but they certainly dont for large numbers of changes across lots of objects. And since the catalog is a key component for our site, its a real problem.

2 1

Re: [Zope-dev] I feel your Wiki Pain ;-)
by Simon Michael 22 Sep '00

22 Sep '00

I like where you're going with this Martijn. Spurred on by your concrete examples, how about this: every wiki page has an email address and functions as a "mailing list". Eg: I could subscribe or send edits to ZWikiWeb:FrontPageNews@joyful.com StructuredTextWiki:CurrentStatus@dev.zope.org ProposalsWiki(a)dev.zope.org (defaults to the front page) A zwikiweb could be seen as a hierarchy of very lightweight mail lists. When I subscribe to a page(list), I would also receive edits(mail) to its child pages(lists) by default. Implementation: a sufficiently smart mail server, or (better?) build on the "mail into zope" project for an all-zope solution. Eg: I might install and configure the "ZWikiMail" product, and suddenly my existing wikis are mail-enabled.. Comments ? -Simon

1 0

Shared Libraries and Persistent Objects
by Monty Taylor 22 Sep '00

22 Sep '00

Hey guys, I've got a question about how Zope deals with shared libraries. Say I have a 2Meg shared library that I've generated with SWIG. (I know it's big, but for sake of argument) Say then that I create a Python Class that imports this library and provides a front-end for each of its exported methods. Then, I instantiate this class 2000 times within a Zope instance. My question is, the library code is loaded into memory once, right? That seems to be what should happen, but I want to make sure before I start selling people here on SWIGing a few utilities and bundling them into one of our Zope objects instead of doing fork/execs to call an executable. I'm not shifting the burden from loading time to storage size, am I? Thanks, Monty

2 1

Chameleon
by Joachim Schmitz 22 Sep '00

22 Sep '00

Hi, I just tried to use the chameleon product with zope 2.2.1 under SuSE 7.0. After adding a new chameleon folder, I can't enter that folder, cause there is always the authorisation-box opened. And I am not able to authorize. Can the chameleon product work with 2.2.x at all ? Mit freundlichen Grüßen Joachim Schmitz AixtraWare, Ing. Büro für Internetanwendungen Hüsgenstr. 33a, D-52457 Aldenhoven Telefon: +49-2464-8851, FAX: +49-2464-905163

1 0

Previous versions of persistent objects
by Robin Becker 22 Sep '00

22 Sep '00

Are there any methods to get access to previous versions of persistent objects without actually carrying out the undo? -- Robin Becker

1 0

FTP behaviours
by Robin Becker 22 Sep '00

22 Sep '00

Has anyone done any work in the area of ftp controlled behaviours? I want to do something like check if an object is of a specific sort before overwriting/creating and then take some additional actions. -- Robin Becker

1 0

Help - Unexpected context behaviour?
by Bernie Rossi 22 Sep '00

22 Sep '00

I am relatively new to Zope and Python and am trying to convert a Zope 'product' from version 2.1.4 (working okay) to 2.2.2 (the latest) and I'm having the following Zope Error when trying to publish the resource; Error Type: AttributeError Error Value: 'string' object has no attribute 'has_key' The code in question appears below (with non-important stuff taken out); Python code; def getContext(self): # return the list of parents up to the project level in reverse order . . . def getAbsoluteURL(self, REQUEST): """ Attempt to get the absolute URL of this object by building it manually""" print "Self : ", self.title print "Request : ", REQUEST . . . if REQUEST.has_key( 'URL1' ) : str = REQUEST['URL1'] . . . DTML Code; <dtml-in "getContext()"> <option value="<dtml-var expr="getAbsoluteURL(REQUEST)">/manage_container" <dtml-if expr="currId==getId()"> SELECTED </dtml-if> > . . . </option> </dtml-in> The function getContext does infact return a list of object instances (tested and okay) and also therefore the related REQUEST (I've assumed?). So that when we loop through the list (in the DTML), the 'context' of the 'current' object should change. Thus we can interrogate each instance and do whatever we want (certainly in previous versions of Zope). But what in fact I'm getting is the following (unexpected) debug information; Self : 'Object Name' Request : <Special Object Used to Force Acquisition> (and the Zope error as mentioned above) with the error line number pointing to the ' if REQUEST.has_key( 'URL1' ) :' statement. If I hack the code to avoid the above test (for the first instance only) the code works (?), in that the next item in the object list is processed correctly (only two objects in the list). So it appears that the REQUEST object (since it hasn't got a method 'has_key') is invalid for the parent object (which Zope thinks is a 'String' object rather than a REQUEST?) but okay for the other. I don't understand this behaviour, is this due to the changes in security implemented in the latest version or due to some other changes? Any help or advice would be appreciated. Regards Bernie Rossi.

2 1

Question about Labels
by Andre Schubert 22 Sep '00

22 Sep '00

Hi, I have a Product with a Label called Foo. Now what can i do, that when anyone clicked on the tab Foo first the function bar() is called and after that the HTML-File is displayed. as manage_options =({'label':'Foo', 'action':'manage_propertiesForm'},) def bar(self): do anything before displaying the HTMLFile def manage_propertiesForm(self,REQUEST): """ doc string """ self.bar() return HTMLFile('edit_NetzwerkForm', globals())

1 0