Web2py: How should I display an uploaded image that is stored in a database?

Is there a web2py way of displaying images from a database table?

Example:

The model:

db.define_table=('images',Field('pict开发者_如何学JAVAure', 'upload' ))

The controller:

def somefunction(): to get the image.

How exactly should I "read" a picture from the database?

The view:

<img src="{{somefunction}}" />

As is, your model will not store the image in the database -- instead, it will store the image on the filesystem, with its new filename stored in the database (in the 'picture' field). If you want to store the image itself in the database, use the following:

db.define_table('images',
    Field('picture', 'upload', uploadfield='picture_file')
    Field('picture_file', 'blob'))

Whether you store the images on the filesystem or in the database, you can use the same method to retrieve them. The 'welcome' scaffolding application includes the following download() action in the default.py controller:

def download():
    return response.download(request, db)

To retrieve an image, just do something like:

<img src="{{=URL('default', 'download', args=picture_name)}}" />

where picture_name is the value stored in the 'picture' field of the 'images' table for the particular image you want to retrieve.

For more details, see here and here.

If you need further help, try asking on the mailing list.

Alternatively, if you use web2py's default way of uploading images as files, you can use:

In models:

db.define_table('images',Field('picture','upload'))

In controllers:

def somefunction():
    pic = db(db.images).select().first().picture   #select first picture
    return dict(pic=pic)

And in the default/somefunction.html view:

{{extend 'layout.html'}}
<img  src="{{=URL( 'download', args=pic)}}" />

I know this is a while after the original question but thought it might be useful as it took me a while to figure out.