December 2003 - Zope

Another Python Script Question
by Tim Zegir 05 Dec '03

05 Dec '03

How would I go about using a statement like 'on-error' in a python script? Eg. For item in object: context.somescript on-error: print error skip return printed Thanks Tim Zegir

2 2

Probably too much to hope for but...
by Goldthwaite, Joe 05 Dec '03

05 Dec '03

Anyone know how to get a number rounded to a whole number and formatted with commas between the thousands and parens around negative numbers? In other words, how to get this; -1234567.55 To this: (1,234,568) I can see in The Zope Book that you can use Python string formats like; <p tal:content="python:'%0.0f' % item.YTDCurrent") That rounds it to the nearest dollar but I can't find where to put the parens and commas.

2 1

Scripting for Python Errors
by Tim Zegir 04 Dec '03

04 Dec '03

Hello List, I am porting data from an old postgresql (7.3.2) database to a new mysql (4) Database. I have this python script to do the mappings from one table to another, Line 1 --- for object in context.get_all_from_postgres(): Line 2 --- context.insert_into_mysql(id=object.id, name=object.name, code=object.code, home=object.home, map=object.map, posx=object.posx, posy=object.posy, enabled=object.enabled, mobile=object.mobile, email=object.email) Line 3 --- Line 4 --- return 'Done' Get_all_from_postgres and insert_into_mysql are zsql objects. This scrip works fine except when it gets near the end of the table entry's it gives me this error, Error Type: OperationalError Error Value: (1054, "Unknown column 'None' in 'field list'") Does anyone have any ideas??? Thanks From Tim Zegir

1 0

Newbie: db handling question
by fowlertrainer＠anonym.hu 04 Dec '03

04 Dec '03

Hello , As you write in this week, the DA is commit/rollback automatically. If an error occured, the zope shows it's error page, and I can redefine it. This way is good to the normal web pages, but not too good for others. If I want catch these errors, and show, then two problem I get: try: apply set error=0 except: set error=1 The html page is structured to when error is 1, then it is show normal page with little red errormessage - and it's don't use zope's error page. - In this case I catch the exception, but because not raised again, the DA transaction is committed, not rollbacked. It is wanted to call the rollback directly. - I don't have the exception's errormessage, only if I use traceback module. Can I use that normally in threaded app like Zope ? Thanx for any answers !!! And thanx for answers before this email. -- Best regards, fowlertrainer mailto:fowlertrainer@anonym.hu

2 1

ZOracleDA: where to get a dco2.pyd for python23 and windows?
by Elena Schulz 04 Dec '03

04 Dec '03

Hi, does anybody know, where to get a dco2.pyd for python2.3 and windows? I did not find any place where to get it, so any hint would be great. -- Thanks, Elena

2 1

Releasing the database connection after processing a request
by Florian Reiser 04 Dec '03

04 Dec '03

Hello Zopistas, from time to time, I have to access my database exclusive. So I shutdown zope, do my database work, and then start zope. Can I convince Zope to release the database connection each time, it has processed a request successfully? So I won't have to shutdown zope to do my administration work? Regards Florian Reiser

4 3

Rv: Re: [Zope] delete catalog entry by rid
by Yurj 04 Dec '03

04 Dec '03

--------- Messaggio Originale -------- Da: Dieter Maurer <dieter(a)handshake.de> Per: Carrer Yuri <yurj(a)alfa.it> Cc: zope(a)zope.org Oggetto: Re: [Zope] delete catalog entry by rid Data: 03/12/03 19:44 > > Carrer Yuri wrote at 2003-12-3 11:17 +0100: > > I've the rid of an unexistent object in the catalog. How can I delete > > the catalog entry by rid (record id)? > > "Update Catalog" in the catalog's "Advanced" tab should clean > the catalog from any object references that do not exist. With 6000 zclasses in it, it takes a lot of time. Last time it was 30 minutes... :( ________________________________________________ Message sent using ALFANET Caorle WEBMAIL 1.0

2 1

RE: [Zope] RedHat Alternative...
by kittonian 04 Dec '03

04 Dec '03

Charlie: I run Zope on the Debian platform and I can honestly tell you that Debian is always the way to go for the most stable and secure Linux systems. At least IMHO it is. No flaming please :) LOL! Joshua -----Original Message----- From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On Behalf Of Charlie Jones Sent: Thursday, December 04, 2003 2:44 PM To: zope(a)zope.org Subject: [Zope] RedHat Alternative... With the recent departure of Redhat Linux from the "free" distros, can somebody recommend a version that is stable with the latest release of production releases of Zope/Plone. charlie _______________________________________________ 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 )

3 2

Re: passing context using expr="dtml_method()"?
by John Withers 04 Dec '03

04 Dec '03

Maik, Thanks for your help. I had actually seen the section of the book you referenced and was trying to pass it as : <dtml-var expr="mymethod(_)"> instead of passing it as <dtml-var expr="mymethod(None, _)"> or <dtrml-var expr="mymethod(callingDoc)">. Thanks for your help in pointing me back to this section and understanding it. jpw Maik wrote: >John Withers wrote: > > Newbieish question. > >Please read the Zope-Book for self-answering newbiesih questions. > ><http://zope.org/Documentation/Books/ZopeBook/2_6Edition>http://zope.org/Documentation/Books/ZopeBook/2_6Edition > > > When I am calling a dtml method using a dtml tag such as <dtml-var > > mymethod> it appears to pass the namespace of the calling document. > > > > However, when I am calling a dtml method using the expr syntax, such as > > <dtml-var expr="mymethod()"> it doesn't. > >Taken from the Zope-Book: ><http://zope.org/Documentation/Books/ZopeBook/2_6Edition/ScriptingZope.stx>http://zope.org/Documentation/Books/ZopeBook/2_6Edition/ScriptingZope.stx > >"""Note that DTML Methods and Documents take optional client and REQUEST >parameters. If a client is passed to a DTML Method, the method tries to >resolve names by looking them up as attributes of the client object. By >passing our context as a client, the method will look up names in that >context. Also, we can pass it a REQUEST object and additional keyword >arguments - the DTML Method will first try to resolve names in them.""" > >Use <dtml-var expr="mymethod(None, _)"> > >Cheers, Maik

1 0

RE: [Zope] RedHat Alternative...
by kittonian 04 Dec '03

04 Dec '03

We built it from source. It's rock solid stable and we even built a couple of start and stop scripts into the mix for our configuration which makes things really easy to admin. -----Original Message----- From: Terry Hancock [mailto:hancock@anansispaceworks.com] Sent: Thursday, December 04, 2003 3:13 PM To: zope(a)zope.org Cc: kittonian(a)macgenius.net Subject: Re: [Zope] RedHat Alternative... On Thursday 04 December 2003 01:52 pm, kittonian wrote: > I run Zope on the Debian platform and I can honestly tell you that > Debian is always the way to go for the most stable and secure Linux > systems. At least IMHO it is. No flaming please :) LOL! Do you run with the Debian "zope" package, or one installed from source? I've been doing the latter for some time. The Debian "zope" package seems really non-standard to me (probably in the interest of preserving FHS). I find that really disconcerting, and have not tried to really understand how the Debian installation is setup. Actually this is my development machine I'm thinking of -- my production site runs on FreeBSD (but I didn't pick that). Cheers, Terry -- Terry Hancock ( hancock at anansispaceworks.com ) Anansi Spaceworks http://www.anansispaceworks.com

1 0