[Zope] blob image from MySql

bobb rawsystems at gmail.com
Mon Feb 28 22:31:54 EST 2005


My post from July 2004... hope it helps...

http://mail.zope.org/pipermail/zope-db/2004-July/003356.html

bobb



----- Original Message -----
From: "Adriano" <adriano at euma.com>
To: <sitharus at sitharus.com>
Cc: "Zope Americana" <zope at zope.org>
Sent: Monday, February 28, 2005 8:42 PM
Subject: Re: [Zope] blob image from MySql


> 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 at 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 at gmail.com / sitharus at 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 -
>
> _______________________________________________
> Zope maillist  -  Zope at 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 )



More information about the Zope mailing list