November 2001 - Zope

Multiple queries in a ZSQL method (MySQLda)
by Gilles Lenfant 27 Nov '01

27 Nov '01

Hi, I've been trying to execute 2 SQL queries in one ZSQL method with the traditional ";" separator I always got a syntax error when both queries work perfectly from MySQL command line !? I made a workaround with 2 distincts ZSQL method and a python script to make the glue but that's heavy. Is there a workaround to have those 2 SQL queries in one ZSQL method ? Thanks in advance. --Gilles

1 0

Zope spinning out of control... FTP bug?
by Chris Keyes 27 Nov '01

27 Nov '01

1 0

Re: [Zope] Generating thumbnails on the fly using PIL
by Lennart Regebro 27 Nov '01

27 Nov '01

From: "Pieter Claerhout" <Pieter_Claerhout(a)CreoScitex.com> > Hope that somebody can help with this. Well, you can look at the attached product, it is an subclass of Image that has thumbnails. Actually, if you remove EasyResourcse and EasyDublinCore from the constructor of the product, it should work in a standard Zope environment. The code that does the resizing is this part: def makeimage(self, maxx=0, maxy=0, ratio=1, ftype='JPEG'): """Creates an image from the orginal with specified size.""" if self.orig_data == None: tmpdata = self.data else: tmpdata = self.orig_data file = StringIO(str(tmpdata)) if maxx <> 0 and maxy <> 0: im = PIL.Image.open(file) if ratio==1: # keep aspect-ratio aspectx = float(im.size[0]) / float(maxx) aspecty = float(im.size[1]) / float(maxy) if aspectx > aspecty: maxy = float(im.size[1]) / aspectx if aspectx < aspecty: maxx = float(im.size[0]) / aspecty maxx = int(maxx) maxy = int(maxy) if im.mode!='RGB' and im.mode!='CMYK': im = im.convert("RGB") im.load() im = im.resize((maxx, maxy), PIL.Image.BICUBIC) newfile = StringIO() im.save(newfile, ftype, optimize=1) return newfile.getvalue(), TYPEINFOMAP[ftype]['content_type'], im.size[0], im.size[1] return None, '', 0, 0 Hope it helps.

1 0

RE: [Zope] FTP access via mc
by Pieter Claerhout 27 Nov '01

27 Nov '01

Have you tried: cd ftp://<user>:password@<zopehost>:8021/ Should work like a charm... Pieter -----Original Message----- From: Tille, Andreas [mailto:TilleA@rki.de] Sent: Tuesday, November 27, 2001 1:27 PM To: Zope user list Subject: [Zope] FTP access via mc Hello, I like the Emacs feature to access Zope via FTP. Now I wanted to try it with MidnightCommander using cd ftp:<user>@<zope-host>:8021/ but it failed. Any hint how to do that? Kind regards Andreas. _______________________________________________ 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

FTP access via mc
by Tille, Andreas 27 Nov '01

27 Nov '01

Hello, I like the Emacs feature to access Zope via FTP. Now I wanted to try it with MidnightCommander using cd ftp:<user>@<zope-host>:8021/ but it failed. Any hint how to do that? Kind regards Andreas.

1 0

Tarversal Issue
by Stadtverwaltung Schwarzenberg 27 Nov '01

27 Nov '01

Hi there... I got a little Problem with Zope (d'uh - what else would I wite this mail for ;-) ). I am trying to create a new website on an already existing Zope Server which alread hosts another site. So I created a new Folder (let's call it "bar") on the root Folder of this other server added a SiteRoot Objcet, etc.... Now there is one Problem: this old server defines a property "foo" in its root Folder. By accident I use the same name for an HTML form value. So what happens is that every time I submit this form my REQUEST.form['foo'] is overwritten by the other servers root folder "foo" property because Zope first traverses the ZODB and only then scans the REQUEST object. So if I write <dtml-var foo missing=""> I get the value of root.foo instead of REQUEST.form['foo']. Now it would be easy to rename my foo attribute but I used it in quite a lot of places, so I this would mean a lot of work. But what I thought about is, if it is possible to somehow tell zope to stop traversal once it reached my the "bar" folder, one level beforereching the root folder. Is there any way to achieve this? Falk

2 1

RE: [Zope] Generating thumbnails on the fly using PIL
by Pieter Claerhout 27 Nov '01

27 Nov '01

I had a look at this yesterday, but apparently, you need both an external method and a Python script, and I prefer to have only an external method. Pieter -----Original Message----- From: Tom Cameron [mailto:tom@cameron.to] Sent: Tuesday, November 27, 2001 12:29 PM To: Pieter Claerhout; zope(a)zope.org Subject: RE: [Zope] Generating thumbnails on the fly using PIL have you read the example on this page http://www.zope.org/Members/michel/ZB/ScriptingZope.html it does not create the thumbnails on the fly, but it does show you how to get the data into stringIO Tom => -----Original Message----- => From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of => Pieter Claerhout => Sent: Tuesday, 27 November 2001 9:21 PM => To: 'zope(a)zope.org' => Subject: [Zope] Generating thumbnails on the fly using PIL => => => Hi all, => => I'm trying to make an external method that creates a thumbnail => of an image => on the fly. I want to give it the url of the image and return the image => data. It should look something like: => => <dtml-var "MakeThumb('/path/to/my/image.jpg', (64, 32))"> => => I figured out already that I should use a StringIO object to => store the raw => image data in, so that PIL has an object to work with. The only => two things => I'm struggling with still are: => => - How do you get the data of the image in the StringIO object? => - How do you return the thumbnail image? => => Hope that somebody can help with this. => => Cheers, => => => Pieter => => => _______________________________________________ => 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

webalizer and several Zope sites
by Gitte Wange 27 Nov '01

27 Nov '01

Hello out there, I have been following the posts about Webalizer and how to create statistics for your sites .... I have about 10 CMF sites with a SiteRoot in each. They all have their own domain. We are using Apache in front of Zope and are using ProxyPass to point to the right CMF instances. My questions is: The data that webalizer will need ... is it still placed in Z2.log or is it placed in the various access_logs for the sites (they all have 2 log entries in the apache conf) ... -- Gitte Wange Jensen Sys Admin, Developer and a lot more MMmanager.org Aps, Denmark Phone: +45 29 72 79 72 Email: gitte(a)mmmanager.org Web: www.mmmanager.org Quote of the day: "Did you mean: abuse Zope" - Google's suggestion when searching for 'aq_base zope', Michel Pelletier pointed this out, Monday, July 9, 2001

2 1

Re: [Zope-dev] More signal 11 restarts....
by Gilles Lavaux 27 Nov '01

27 Nov '01

Hello, I was convinced they was something called Zdeamon which is restarting zope in case of crash. Am I wrong?? Gilles -----Original Message----- From: Daniel Duclos <daniduc(a)hiper.com.br> To: zope-dev(a)zope.org <zope-dev(a)zope.org> Date: Monday, November 26, 2001 18:29 Subject: [Zope-dev] More signal 11 restarts.... > > > > I have a zope that is dumping signal 11 every 40 minutes or so. I have >tried >recompile python 2.1.1 with-threads without-pymalloc, recompile Zope with it, >recompile ZPAtterns, recompile and instal MYSQL for Python 0.9.1, upgraded to >Zope 2.4.3, all this on a Debian Linux box. > Nothing changed... still restarting... > Anybody, please, has any ideia on this matter? > Please, let me know if there's any relevant info that I forgot to mention >abot my case! > Thanks in advance!! > >-- >daniel lobato duclos -- daniduc(a)hiper.com.br -- http://www.hiperlogica.com.br >--------------------------------------------------------------------------- -- > >_______________________________________________ >Zope-Dev maillist - Zope-Dev(a)zope.org >http://lists.zope.org/mailman/listinfo/zope-dev >** No cross posts or HTML encoding! ** >(Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope ) > > >

1 0

Display titles of containing folders
by Milos Prudek 27 Nov '01

27 Nov '01

How can I display titles of folder, its parent folder etc. that contain a given ZClass if I iterate over a Catalog? Catalog_Art is a catalog of Articles. Given the following dtml method I would like to display the "path" to the article. Path means the titles of folders that the Article instance is located in: <table> <dtml-in Catalog_Art> <tr><td><dtml-var mypath></td></tr> </dtml-in> </table> mypath is a Python Script that I cannot find a way to create :-( I head a good start: fullpath=context.getpath(context.data_record_id) fullpath=fullpath[1:] fullpath=string.replace(fullpath,"/",".") subfolder=fullpath[0:string.rfind(fullpath,".")] folder=subfolder[0:string.rfind(subfolder,".")] at this point folder=="folder_a" and subfolder=="folder_a.folder_aa". But what next? I cannot run folder_title=getattr(folder,"title"), because getattr does not work that way, and I cannot run eval(), because it is not allowed in Python Scripts. -- Milos Prudek

2 2