[reportlab-users] Image from MySQL table and drawImage

[dimitri pater]

Sorry that I keep replying to myself, but this might be helpful to
someone in the future. Anyway I fixed the drawImage problem (which was
a rather silly of me...):
c.drawImage("temp.jpg", 35*mm, PAGE_HEIGHT-220*mm, width=None,
height=None, mask=None)


On 9/5/07, dimitri pater <dimitri.pater at gmail.com> wrote:

> ah, sorry

> a+=1 should be after 'Do stuff here'  of course...

>

> On 9/5/07, dimitri pater <dimitri.pater at gmail.com> wrote:

> > Okay thanks both,

> >

> > this is what I came up with and it works inserting images in tables:

> > (result4 is a query result)

> > a=0

> > for i in result4:

> >             cfoto = StringIO()

> >             cfoto.write(result4[a][9].tostring())

> >             dfoto = cfoto.getvalue()

> >             fileFoto = open(str(a)+'temp.jpg','wb')

> >             fileFoto.write(dfoto)

> >             fileFoto.close()

> >             foto = Image(str(a)+'temp.jpg')

> >             a+=1

> >

> >            Do stuff here (insert the Image)

> >

> > The problem with this code is that I need to create a unique file

> > (str(a)+'temp.jpg'), I tried to use a single temp.jpg but it kept

> > using the data from the first record. Tried flush(), truncate(0), but

> > it didn't work. (My mistake probably ;-)

> > But the images show in the PDF so that's fine for now.

> > Another problem is that:

> > c.drawImage(fotogebouw, 35*mm, PAGE_HEIGHT-220*mm, width=None,

> > height=None, mask=None) raises this error:

> > File "C:\Python24\lib\site-packages\reportlab\platypus\flowables.py",

> > line 367, in __getattr__

> >     raise AttributeError(a)

> > AttributeError: getRGBData

> >

> > thanks,

> > Dimitri

> >

> >

> >

> > On 9/5/07, Dennis Lee Bieber <wlfraed at ix.netcom.com> wrote:

> > > On Wed, 5 Sep 2007 10:16:33 +0200, "dimitri pater"

> > > <dimitri.pater at gmail.com> declaimed the following in

> > > gmane.comp.python.reportlab.user:

> > >

> > > > Sorry, I really should apologize...

> > > > inserting the image into the table doesn't work either. The text:

> > > > <StringIO.StringIO instance at 0x01443EB8>

> > > > is inserted into the table, not the image. I have no clue how to fix this...

> > > >

> > > > I thought it worked, but I had some 'old' code still uncommented, that

> > > > did the job

> > > > stupid of me, sorry about that

> > > >

> > > > On 9/5/07, dimitri pater <dimitri.pater at gmail.com> wrote:

> > > > > Hello,

> > > > >

> > > > > I use this code to insert an image (BLOB) from MySQL into a table:

> > > > > from StringIO import StringIO

> > > > > foto=StringIO(result[0][1])

> > > > > foto.seek(0)

> > >

> > >         According to the documentation, a StringIO instance /starts at/

> > > position 0, so that .seek() looks redundant.

> > >

> > >         Do you ever "get" the value of the StringIO object?

> > >

> > >         thePhoto = foto.getvalue()

> > >

> > > (followed, perhaps, by foto.close() )

> > >

> > > > > c.drawImage(fotogebouw, 35*mm, PAGE_HEIGHT-220*mm, width=None,

> > > > > height=None, mask=None)

> > > > >   File "C:\Python24\lib\site-packages\reportlab\pdfgen\canvas.py",

> > > > > line 584, in drawImage

> > > > >     rawdata = image.getRGBData()

> > > > > AttributeError: StringIO instance has no attribute 'getRGBData'

> > > > >

> > >

> > >         Well, as it says, you passed it a StringIO /instance/, not the

> > > filename of an image file, or whatever. Perhaps you need to pass:

> > > fotogebouw.getvalue()  {presuming "image" can read a string as the

> > > data?}

> > >

> > >         ReportLab UG states that .drawImage() takes a filename, or of PIL

> > > Image object... So, I guess the next step would be how to convert the

> > > StringIO instance to an Image object instance.

> > >

> > >         Ah...  PIL Image.open

> > >

> > >         What do you get from:

> > >

> > > from PIL import Image

> > > foto = Image.open(StringIO(result[0][1]))

> > > --

> > >         Wulfraed        Dennis Lee Bieber               KD6MOG

> > >         wlfraed at ix.netcom.com           wulfraed at bestiaria.com

> > >                 HTTP://wlfraed.home.netcom.com/

> > >         (Bestiaria Support Staff:               web-asst at bestiaria.com)

> > >                 HTTP://www.bestiaria.com/

> > >

> > > _______________________________________________

> > > reportlab-users mailing list

> > > reportlab-users at reportlab.com

> > > http://two.pairlist.net/mailman/listinfo/reportlab-users

> > >

> >

> >

> > --

> > ---

> > You can't have everything. Where would you put it? -- Steven Wright

> > ---

> > please visit www.serpia.org

> >

>

>

> --

> ---

> You can't have everything. Where would you put it? -- Steven Wright

> ---

> please visit www.serpia.org

>



-- 
---
You can't have everything. Where would you put it? -- Steven Wright
---
please visit www.serpia.org