February 2000 - Zope-Dev

Computed fields in ZCatalog
by Kevin Dangoor 07 Feb '00

07 Feb '00

Hi, Looking at the ZCatalog code, if an index or metadata field is callable for a particular object, then that function will be called. However, it isn't called with *any* parameters. Is there any way to make that metadata value based upon other values in the object? For example, if I wanted to create a method that would return Property1+Property2 and have that value show up in the Catalog, can that be done? Kevin

1 0

Scheduler product, anyone?
by Loren Stafford 07 Feb '00

07 Feb '00

At one time there was talk on this list (or zope(a)zope.org) of building a scheduler product -- something that would automatically execute specified methods at specified times or time intervals. Does anyone have such a product in the works? ...or is it time for me to roll up my sleeves and get to work? -- Thanks -- Loren

6 8

Again... Fw: [Zope] DCOracle/ZOracleDA not returning floats!!!
by Karl Putland 07 Feb '00

07 Feb '00

Looking for others to confirm that this is indeed a problem. ----- Original Message ----- From: "Karl Putland" <kputland(a)servicemagic.com> To: "Zope@Zope. Org" <zope(a)zope.org> Sent: Thursday, February 03, 2000 3:49 PM Subject: [Zope] DCOracle/ZOracleDA not returning floats!!! > >>> sql = """select sysdate, 0.111, 1234.123456, 123, 1234, > (sysdate-to_date('2000-02-03','YYYY-MM-DD')) DateDiff from dual""" > >>> c.execute(sql) > >>> c.description > (('SYSDATE', 'DATE', 75, 7, 0, 0, 1), ('0.111', 'NUMBER', 40, 3, 0, 0, 1), > ('1234.123456', 'NUMBER', 40, 6, 0, 0, 1), ('123', 'NUMBER', 40, 3, 0, 0, > 1), ('1234', 'NUMBER', 40, 3, 0, 0, 1), ('DATEDIFF', 'NUMBER', 40, 22, 0, 0, > 1)) > >>> pprint.pprint(c.fetchone()) > (dbiDate('2000-02-03 15:38:23'), 0, 1234, 123, 1234, 0) > >>> > > > A similar query executed through ZOPE has the same effeect. > > Z SQL Method at /db / prod / Oracle / Test_Junk > > -------------------------------------------------------------------------- -- > ---- > SYSDATE 0.111 DATEDIFF > 2000/02/03 15:36:35 US/Mountain 0 0 > > -------------------------------------------------------------------------- -- > ---- > SQL used: > > select sysdate, 0.111, (sysdate-to_date('2000-02-03','YYYY-MM-DD')) DateDiff > from dual > > > -------------------------------------------------------------------------- -- > ---- > > > > > The same query executed though ODBC returns the desired result > > Z SQL Method at /db / prodODBC / Oracle / Test_Junk > > -------------------------------------------------------------------------- -- > ---- > SYSDATE 0.111 DATEDIFF > 2000/02/03 15:41:12 US/Mountain 0.111 0.653611111111 > > -------------------------------------------------------------------------- -- > ---- > SQL used: > > select sysdate, 0.111, (sysdate-to_date('2000-02-03','YYYY-MM-DD')) DateDiff > from dual > > > -------------------------------------------------------------------------- -- > ---- > > > Please help. > > -Karl > > > _______________________________________________ > 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 ) >

1 0

Database connections
by Stephan Richter 07 Feb '00

07 Feb '00

Hello everyone, My client went live with a site today and we are having huge problems with the DB connections. Every one out of five times the request will time out. We are heavily using DB tables for our data storage. (We are using PostGres.) My client has read that other people experienced the same issue, since only 7 DB connections are allowed at a given time. She read that you can hack the python code somewhere. I am sure you guys know how to do this. If you could send me a set of instructions of how to fix it, that would be great. Regards, Stephan -- Stephan Richter srichter(a)cbu.edu CBU - Physics, Chemistry and Electrical Computer Engineering Web2k - Technical Designs, Programming & Project Management

1 0

[PATCH] Improved Lynx managing experience
by Petru Paler 07 Feb '00

07 Feb '00

In the hope that I'm not the only one using Lynx with Zope often enough to get irritated by the double links in the Folder contents manage screen, I attach this patch. PS: usage info: save this message into a text file then cd into you Zope install dir and do a 'patch < file_name'. PPS: it does not affect in any way the management interface when used with any other browser than Lynx. text-ly yours, -Petru --- lib/python/OFS/main.dtml.org Mon Feb 7 15:24:18 2000 +++ lib/python/OFS/main.dtml Mon Feb 7 15:25:39 2000 @@ -16,7 +16,7 @@ <INPUT TYPE="CHECKBOX" NAME="ids:list" VALUE="<dtml-var sequence-key html_quote>"> </TD> <TD ALIGN="LEFT" VALIGN="TOP"> - <dtml-if icon> + <dtml-if "icon and _.string.find(HTTP_USER_AGENT, 'Lynx') == -1"> <A HREF="<dtml-var sequence-key url_quote>/manage_workspace"> <IMG SRC="<dtml-var SCRIPT_NAME>/<dtml-var icon>" ALT="[<dtml-var meta_type>]" BORDER="0"></A>

1 0

Expressions like <dtml-var this url> bail out contrary to intuition -- proposed fix enclosed
by Jarkko Kniivilä 07 Feb '00

07 Feb '00

Hi fellow Zopistas! While upgrading a Zope 2.1.0 beta installation recently to 2.1.3, I discovered that a recent change made to 'DT_Var.py' rendered DTML expressions like <dtml-var this url> and &dtml.url-this; inoperative. I had been relying on them for a default action url on my forms (in DTML methods). Especially the entity reference syntax is quite a nice abbreviation for the more explicit <dtml-var "this().absolute_url()"> which still continues to work. The enclosed fix simply acknowledges that 'this' isn't a ZODB namespace object but a method encapsulating python 'self' and thus always needs to be invoked. I'm not quite on the top of things why the previous behavior was changed in the first place (Jim? Anyone?). I'll file this to the Collector if there's no objection by you. Copyright to the patch is hereby transfered to Digital Creations to be used freely. Cheers, // Jarkko Kniivila, CTO, Ambient Factor New Media, Hameenlinna, Finland

1 0

Expressions like <dtml-var this url> bail out contrary to intuition -- proposed fix enclosed
by Jarkko Kniivilä 07 Feb '00

07 Feb '00

Hi fellow Zopistas! While upgrading a Zope 2.1.0 beta installation recently to 2.1.3, I discovered that a recent change made to 'DT_Var.py' rendered DTML expressions like <dtml-var this url> and &dtml.url-this; inoperative. I had been relying on them for a default action url on my forms (in DTML methods). Especially the entity reference syntax is quite a nice abbreviation for the more explicit <dtml-var "this().absolute_url()"> which still continues to work. The enclosed fix simply acknowledges that 'this' isn't a ZODB namespace object but a method encapsulating python 'self' and thus always needs to be invoked. I'm not quite on the top of things why the previous behavior was changed in the first place (Jim? Anyone?). I'll file this to the Collector if there's no objection by you. Copyright to the patch is hereby transfered to Digital Creations to be used freely. Cheers, // Jarkko Kniivila, CTO, Ambient Factor New Media, Hameenlinna, Finland

1 0

Is there a way to find out where a method is defined?
by Andrew Wilcox 07 Feb '00

07 Feb '00

While browsing through Zope and product Python source code, I often see a method being called on an object and want to find out what it's doing and look up the definition. Because Zope objects often have many superclasses, I end up scanning through many class definitions. (My most recent experience was finally finding the definition of this() in the Item class, and saying, oh yes, that's correct, it doesn't do anything :-) And, there's always a danger that I'll miss a definition in a subclass or a superclass that gets inherited first, and be looking at the wrong method definition for the particular object. Is there a way in the runtime or in the debugger, perhaps through the magic of Python reflection, to ask "when I call this method on this object, this is the class providing the definition?"

2 1

Re. Scheduler product, anyone?
by Jerry.Spicklemire＠IFLYATA.COM 06 Feb '00

06 Feb '00

I had to do this just yesterday, and the urllib.py module made it absolutely painless. Here's the simplistic little script I came up with, which could be called by cron, or some other task manager. This ia probably way less cool than the answer you're looking for, but it might give someone else some ideas . . . Later, Jerry S. --------------------------------------------------- """ urlgrabr.py is a simple script to hit an URL, capture the generated output, and manipulate it, based on parameters. e.g. save it as a file, python urlgrabr.py http://server/folder/object file=filename.html Default is simply to request the URL, and exit, dumping all data. """ import urllib import sys import string c_url = sys.argv[1] c_action = None u_url = urllib.urlopen(c_url) if len(sys.argv) > 2 : c_action = sys.argv[2] if string.lower(c_action[:5]) == "file=" : f_action = open(c_action[5:], "w") # file name for l in u_url.readlines() : if string.strip(l[:-1]) : f_action.write(l) f_action.close()

3 2

Zope componentry
by Jeff Bauer 05 Feb '00

05 Feb '00

Hi All. Andrew Kuchling posted the following message on comp.lang.python about his nght2html.py module. His message reminded me that it's a bit of a hassle maintaining code that relies on one or more of the Zope components, compared to the relatively simple way of dealing with Bobo code. [ amk ] > It's perfectly possible to use DTML outside of Zope; > nght2html, the templating system I use for my Web > pages, uses DocumentTemplate because I didn't want > to write and maintain Yet Another templating syntax, > and DocumentTemplate has practically all the bells > and whistles you need. > http://www.mems-exchange.org/software/python/nght2html/ Zope appears to be presently distributed as a single, monolithic package. It was formerly available as downloadable components. (Is there a link to older versions available?) I can understand that Digital Creations does not have the available bandwidth to continue to support distributing individual components. However, I'm interested in developing a long-term strategy that will allow me to continue to use Zope components (ZODB, ZTemplate, etc.) in a portable, low-maintenance kinda way. Jeff Bauer Rubicon Research

2 1