March 2005 - Zope - Zope lists

Long transactions and conflict errors
by Pascal Peregrina 01 Mar '05

01 Mar '05

Hi, During a long transaction that reads lots of ZODB objects in order to generate a report, I get Conflict Errors, which is not a suprise as other users keep accessing some of the same objects. I would like to know if during a transaction there is a way to "unlock" objects from which I read some values but that I don't need anymore for the rest of the transaction execution. Thanks. Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

5 4

Relations between objects in zope?
by Somhorst JJT 01 Mar '05

01 Mar '05

Hi there all, For a project to learn working with Zope I want to use relations between several zope objects. for instance. I have a trainee form. On this form I create a new course for people to take. This course has some prerequisites. Somehow I want to link this new course to the 'old' courses in the system. With mysql i just create a new table call it course to preq and fil it with the usefull stuf. But in zope I dont have ... clue how to accomplish this task. Do i need to fall back by using an Relational Database like Mysql OR can I achieve this with Zope? Yours sincerely, J.somhorst

2 1

Event handling problem
by prabuddha ray 01 Mar '05

01 Mar '05

I'm using mysql database in my zope 2.7. While creating a page i needed to get data in one combobox after selecting data from another combobox. for this i need to do "page reload " using something like onChange() of javascript. Javascript won do DTML being a server side lang. I How do handle such events in zope in dtml. plz give a solution.

2 1

Re: [Zope] blob image from MySql
by Adriano 01 Mar '05

01 Mar '05

Phillip, Thanks for your kindness, you got a point. I checked and the first row of the file "downloaded" starts with "array('c', ... and then all the strange chars Also, I tried to put an external method like this: ##bind container=container ##bind context=context ##bind namespace= def makeImage(self, photo): return photo[0].iconblob.tostring() (notice the ".tostring()" in the end) and call this external method from my python script In this case the downloaded file does not start like that but still results not recognizable. I tried to open it with Safari abd it shows a empty withe screen Well, at least the tostring() changed the output but still I can't see the pic. I saw a page suggesting to use an external methos like that and I wonder why the http://www.zope.org/Members/murphy/MySQL-BLOBs page doesn't suggest this too. The fact is - I don'y understand the difference in the output. Thanks, anyhow Catonano >On Tue, 1 Mar 2005 01:04:53 +0100, Adriano <adriano(a)euma.com> wrote: >> Dear Zope friends, > > >> I can't manage my Zope to correctly serve an image retrieved from a >> MySql table. >> >> If the thing has been discussed already, I'm sorry, but I couldn't >> find so much help, on line. >> >> I followed indications at http://www.zope.org/Members/murphy/MySQL-BLOBs >> >> I have the following ZSQLMethod, named "trovaImmagine" (in Italian >> that means findImage) >> >> select iconmimetype, iconblob from webs where >> <dtml-sqltest id op="eq" type="int"> >> >> Then, I have a Python script (displayImage2) >> >> # Return a string identifying this script. >> record = context.trovaImmagine(id = 1) >> data = record[0].iconblob >> contentType = record[0].iconmimetype >> >> RESPONSE.setHeader('content-type', contentType) >> return data >> #return len(data) >> #return contentType >> >> The commented returns are some tests I made. >> When I comment the "return data" part and uncomment the "return >> contentType" OR "return len(data)", it seems to work correctly >> >> BUT >> >> when I try to return "data" I obtain a message error from FireFox, saying: >> >> "The image "http://localhost:8080/sql/displayImage2" cannot be >> displayed, because it contains errors." > > >> I tyied with Safari and it downloads a "displayImage2" file , I >> rename it to displayImage2.jpg, I try to open it with the Apple >> viewer (Anteprima in Italian, I don't remember in English) AND it >> says me that the file is not a jpeg file as it seems. >> >> Internet Explorer shows a broken QuickTime icon. >> >> What's going on ? >> >> I'm trying to convince a company to port their little app made of >> JSPs to Zope and I am doing some tests. >> They have the pictures in some blob fields so this is unavoidable, I think >> > >It sounds like it's returning some extra data before or after the >image. In FireFox you can view source on the page and see the raw >image data, it may give you some clues. >-- >Phillip Hutchings >http://www.sitharus.com/ >sitharus(a)gmail.com / sitharus(a)sitharus.com -- " One of the tricks here is to get away from thinking that programs have to be composed with only a simple text editor " - Alan Kay - "Java and C++ make you think that the new ideas are like the old ones. Java is the most distressing thing to hit computing since MS-DOS". - Alan Kay - "The computer revolution hasn't started yet. Don't be misled by the enormous flow of money into bad defacto standards for unsophisticated buyers using poor adaptations of incomplete ideas". -Alan Kay -

2 1

blob image from MySql
by Adriano 01 Mar '05

01 Mar '05

Dear Zope friends, I can't manage my Zope to correctly serve an image retrieved from a MySql table. If the thing has been discussed already, I'm sorry, but I couldn't find so much help, on line. I followed indications at http://www.zope.org/Members/murphy/MySQL-BLOBs I have the following ZSQLMethod, named "trovaImmagine" (in Italian that means findImage) select iconmimetype, iconblob from webs where <dtml-sqltest id op="eq" type="int"> Then, I have a Python script (displayImage2) # Return a string identifying this script. record = context.trovaImmagine(id = 1) data = record[0].iconblob contentType = record[0].iconmimetype RESPONSE.setHeader('content-type', contentType) return data #return len(data) #return contentType The commented returns are some tests I made. When I comment the "return data" part and uncomment the "return contentType" OR "return len(data)", it seems to work correctly BUT when I try to return "data" I obtain a message error from FireFox, saying: "The image "http://localhost:8080/sql/displayImage2" cannot be displayed, because it contains errors." I tyied with Safari and it downloads a "displayImage2" file , I rename it to displayImage2.jpg, I try to open it with the Apple viewer (Anteprima in Italian, I don't remember in English) AND it says me that the file is not a jpeg file as it seems. Internet Explorer shows a broken QuickTime icon. What's going on ? I'm trying to convince a company to port their little app made of JSPs to Zope and I am doing some tests. They have the pictures in some blob fields so this is unavoidable, I think Thanks so much Catonano -- " One of the tricks here is to get away from thinking that programs have to be composed with only a simple text editor " - Alan Kay - "Java and C++ make you think that the new ideas are like the old ones. Java is the most distressing thing to hit computing since MS-DOS". - Alan Kay - "The computer revolution hasn't started yet. Don't be misled by the enormous flow of money into bad defacto standards for unsophisticated buyers using poor adaptations of incomplete ideas". -Alan Kay -

1 0