How can I insert image in HTML from database?

[Константин Комков]

I do like that:

row = db().select(db.recipes.IMAGE).first()
image = '<img src="'+URL('default','download',args=row.file)+'"/>'

I get error:

Версия

web2py™	Version 2.18.5-stable+timestamp.2019.04.08.04.22.03
Python	Python 3.7.3: C:\Python\python.exe (prefix: C:\Python)

Traceback

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23.

Traceback (most recent call last): File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\packages\dal\pydal\objects.py", line 116, in __getattr__ return self.__getitem__(k) File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\packages\dal\pydal\objects.py", line 103, in __getitem__ raise KeyError(key) KeyError: 'file' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\applications\Recipes\controllers/default.py", line 176, in <module> File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\globals.py", line 421, in <lambda> self._caller = lambda f: f() File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\applications\Recipes\controllers/default.py", line 12, in index recipes = selectRecipes() File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\applications\Recipes\controllers/default.py", line 111, in selectRecipes image = '<img src="'+URL('default','download',args=row.file)+'"/>' File "C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\packages\dal\pydal\objects.py", line 118, in __getattr__ raise AttributeError AttributeError

Error snapshot 

AttributeError()

inspect attributes

Frames

• File C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\restricted.py in restricted at line 219 код аргументы переменные

• File C:\Users\kkomkov.TIMACAD\Desktop\web2py\applications\Recipes\controllers\default.py in <module> at line 176 код аргументы переменные

• File C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\globals.py in <lambda> at line 421 код аргументы переменные

• File C:\Users\kkomkov.TIMACAD\Desktop\web2py\applications\Recipes\controllers\default.py in index at line 12 код аргументы переменные

• File C:\Users\kkomkov.TIMACAD\Desktop\web2py\applications\Recipes\controllers\default.py in selectRecipes at line 111 код аргументы переменные

File C:\Users\kkomkov.TIMACAD\Desktop\web2py\gluon\packages\dal\pydal\objects.py in __getattr__ at line 118 код аргументы переменные

Function argument list

(self=<Row {}>, k='file')

Code listing

113.
114.
115.
116.
117.
118.
119.
120.
121.
122.

    def __getattr__(self, k):
        try:
            return self.__getitem__(k)
        except KeyError:
            raise AttributeError

    def __copy__(self):
        return Row(self)

Variables

• builtinAttributeError <class 'AttributeError'>
  
• If I do like that:
rows = db().select(db.recipes.ALL)
for row in rows:
    if row.recipes.IMAGE is None:
        image = ''
    else:
        image = '<img src="'+URL('default','download',args=row.recipes.IMAGE)+'"/>'
• I get HTML without image:
• <img src="/Recipes/default/download/%3Cfdb.fbcore.BlobReader%20object%20at%200x04E09C50%3E"/>
• 
  

[António Ramos]

what is your model ?

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/a782e7f9-ff3d-4d0c-affb-5f80bd94f480%40googlegroups.com.

[Константин Комков]

What do you want to know?

tables.py

db.define_table(
    'recipes',
    Field('NAME',length=512),
    Field('IMAGE'),
    migrate=False
)

It's my database connection in db.py:

db = DAL('firebird://sysdba:masterkey@localhost/C:/HR.fdb', ignore_field_case=True, entity_quoting=False, pool_size=1, migrate_enabled=False, db_codec='UTF-8')

[António Ramos]

maybe -> Field('IMAGE', 'upload'),

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/3cf73bb8-3c63-47c3-88db-8f9c654798c7%40googlegroups.com.

[Константин Комков]

Didn't work, errors was like in my first message. I had tried it already.

[Dave S]

You probably have to stream the object in the response.

def getmyblob():
    import cStringIO
    import os, shutil
    # print request
    if len(request.args) == 0 or not request.args[0]:
      raise HTTP(404, "unknown file not found")
    row = db(db.mypics.pname == request.args[0]).select().first()
    blob = db[somethingsomething].[copyblobltotmpfile]

    dst = os.path.join(request.env.web2py_path, "application", blob.tmpname)
    if not os.access(dst, os.F_OK):
            print dst
            raise HTTP(404,"funny, that's not here")
    imstat = os.stat(dst)    filedata=open(dst,"rb").read()
    response.headers['Content-Type']='image/jpeg'
    response.headers['Content-Length']=imstat.st_size
    return response.stream(cStringIO.StringIO(filedata))

Then your IMG tag looks like

<IMG src="getmyblob/{{=blobrowid}} alt="image file for {{=blobrowid"}} title="={{blobrowid}}">

Sorry for the hacky look of this, I don't have much experience handling blobs; the code I use is for an image as an ordinary file in the filesystem.  (My app tags pictures transferred from my camera.)

The field type "upload", combined with the default/user/download() function, hides much of this from you, but has something similar under the hood.

Good luck!

/dps

[Константин Комков]

Dave, I don't understand what means that string:

blob = db[somethingsomething].[copyblobltotmpfile]

Is your example only for '.jpeg' files or for another expansions too? 

[Константин Комков]

Hello! I can get image like that:

import codecs
base64_data = codecs.encode(row.recipes.IMAGE.read(), 'base64')
base64_text = codecs.decode(base64_data, 'ascii')
image = '<img src="data:image/png;base64, %s" />' % base64_text

Thank all!

[Dave S]

I think you figured out the important stuff below, but the line you quote is just a hand-waving attempt to suggest retrieving the blob from the DB and putting it in a temporary file.

 /dps

[Val K]

Set field type to 'upload' as Ramos suggests and
in your first example it should be row.IMAGE instead of row.file

[Константин Комков]

Val K, it is my table.py file:

db.define_table(
    'recipes',
    Field('NAME',length=512),

    Field('IMAGE','upload'),
    migrate=False
)

It's code in my default.py file:

row = db().select(db.recipes.IMAGE).first()

image = str(dir(row))

>>>

['IMAGE', '__bool__', '__call__', '__class__', '__contains__', '__copy__', '__delattr__', '__delitem__', '__dict__', '__dir__', '__doc__', '__eq__', '__format__', '__ge__', '__getattr__', '__getattribute__', '__getitem__', '__gt__', '__hash__', '__init__', '__init_subclass__', '__int__', '__iter__', '__le__', '__long__', '__lt__', '__module__', '__ne__', '__new__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__setitem__', '__sizeof__', '__str__', '__subclasshook__', '__weakref__', 'as_dict', 'as_json', 'as_xml', 'clear', 'copy', 'get', 'has_key', 'items', 'iteritems', 'iterkeys', 'itervalues', 'keys', 'pop', 'update', 'values']

image = str(dir(row.IMAGE))

>>>

['_BlobReader__blob_get', '_BlobReader__blobid', '_BlobReader__bytes_read', '_BlobReader__charset', '_BlobReader__closed', '_BlobReader__db_handle', '_BlobReader__ensure_open', '_BlobReader__index', '_BlobReader__is_text', '_BlobReader__mode', '_BlobReader__open', '_BlobReader__opened', '_BlobReader__pos', '_BlobReader__python_charset', '_BlobReader__reset_buffer', '_BlobReader__tr_handle', '__class__', '__del__', '__delattr__', '__dict__', '__dir__', '__doc__', '__eq__', '__format__', '__ge__', '__getattribute__', '__gt__', '__hash__', '__init__', '__init_subclass__', '__iter__', '__le__', '__lt__', '__module__', '__ne__', '__new__', '__next__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__sizeof__', '__str__', '__subclasshook__', '__weakref__', '_blob_handle', '_isc_status', 'blob_charset', 'blob_id', 'charset', 'close', 'closed', 'flush', 'get_info', 'is_text', 'mode', 'next', 'read', 'readline', 'readlines', 'seek', 'tell']

I can not do row.file.row.IMAGE

[Dave S]

On Monday, August 5, 2019 at 11:28:43 PM UTC-7, Константин Комков wrote:

Val K, it is my table.py file:

db.define_table(
    'recipes',
    Field('NAME',length=512),
    Field('IMAGE','upload'),
    migrate=False
)

It's code in my default.py file:

row = db().select(db.recipes.IMAGE).first()

image = str(dir(row))

>>>

row.keys() is more interesting than dir(row)
 

image = str(dir(row.IMAGE))

>>>

['_BlobReader__blob_get', '_BlobReader__blobid', '_BlobReader__bytes_read', '_BlobReader__charset', '_BlobReader__closed', '_BlobReader__db_handle', '_BlobReader__ensure_open', '_BlobReader__index', '_BlobReader__is_text', '_BlobReader__mode', '_BlobReader__open', '_BlobReader__opened', '_BlobReader__pos', '_BlobReader__python_charset', '_BlobReader__reset_buffer', '_BlobReader__tr_handle', '__class__', '__del__', '__delattr__', '__dict__', '__dir__', '__doc__', '__eq__', '__format__', '__ge__', '__getattribute__', '__gt__', '__hash__', '__init__', '__init_subclass__', '__iter__', '__le__', '__lt__', '__module__', '__ne__', '__new__', '__next__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__sizeof__', '__str__', '__subclasshook__', '__weakref__', '_blob_handle', '_isc_status', 'blob_charset', 'blob_id', 'charset', 'close', 'closed', 'flush', 'get_info', 'is_text', 'mode', 'next', 'read', 'readline', 'readlines', 'seek', 'tell']

I can not do row.file.row.IMAGE

row.file probably doesn't exist, because it would have to be row.keys() (it's not in the attributes, as you've shown), and then looking in a putative row.files for row key or attribute doesn't seem sensible.

I don't have any experience with BLOBs, but I believe default/user/download is able to handle them.

For a file-based upload field, the upload field is a string that default/user/download uses to locate the file. That is, it is the obfuscated file name, and the rest of the path is defined by the uploadfolder value (default, myapp/uploads), as well as uploadseparate and uploadfs.  For BLOBs, you've instead set uploadfield to true.  In my case, the file-base one, the attributes are those of a string, but I don't have to do much with it except return it in hrefs.

default/users/download will use the path name or the blob field to figure out what to stream.  There are times when it is desirable to set up the streaming in your code, and I thought this was one of those times, but Ramos and Val K have pointed out how to use the out-of-the-box tool to do this.

/dps

[Константин Комков]

Dave S, maybe I don't see the out-of-the-box tool. I did all what were suggest Rumos and Val K like I understood:

row = db().select(db.recipes.IMAGE).first()
image = '<img src="'+URL('default', 'download', args=row.IMAGE)+'"/>'

and

tables.py

db.define_table(
    'recipes',
    Field('NAME',length=512),
    Field('IMAGE','upload'),
    migrate=False
)

After that I don't have error, but picture is unavailable.

HTML:

<img src="/Recipes/default/download/%3Cfdb.fbcore.BlobReader%20object%20at%200x07E810D0%3E">

Also I tried do like that:

row = db().select(db.recipes.IMAGE).first()
stream = row.IMAGE
image = '<img src="'+URL('default', 'download', args=stream.read())+'"/>'

And I have that HTML:

<img src="/Recipes/default/download/b%27%5Cxff%5Cxd8%5Cxff%5Cxe0%5Cx00%5Cx10JFIF%5Cx00%5Cx01%5Cx01...">

[Val K]

to make it works, files should be loaded using web2py interface (SQLFORM or programmatically - see the book). As far as I can see you have legacy database with already srored images in it, no? If so you can try to use 'uploadfield' option, i.e. you should have 2 fields in your model (upload and blob type) - the first one will use the second to store file instead of FS - see 'more on uploads' in the DAL chapter

[Константин Комков]

Val K, yes, I have database which contain images. I tried use blob ↓.

I don't know why but if I do like that I have error:

table.py

db.define_table(
    'recipes',
    Field('NAME',length=512),

    Field('IMAGE','blob'),
    migrate=False
)

and query in controller:

db().select(db.recipes.IMAGE).first()

Версия

web2py™	Version 2.18.5-stable+timestamp.2019.04.08.04.22.03
Python	Python 3.7.3: C:\Program Files (x86)\Python37-32\python.exe (prefix: C:\Program Files (x86)\Python37-32)

Traceback

1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23.

24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34.

Traceback (most recent call last

): File "C:\web2py\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\web2py\applications\test\controllers/default.py", line 61, in <module> File "C:\web2py\gluon\globals.py", line 421, in <lambda>

self._caller = lambda f: f

() File "C:\web2py\applications\test\controllers/default.py", line 9, in index db().select(db.recipes.IMAGE).first() File "C:\web2py\gluon\packages\dal\pydal\objects.py", line 2395, in select return adapter.select(self.query, fields, attributes) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 763, in select return self._select_aux(sql, fields, attributes, colnames) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 742, in _select_aux return processor(rows, fields, colnames, cacheable=cacheable) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 306, in parse for row in rows File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 303, in <listcomp> self._parse( File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 232, in _parse value = self.parse_value(value, fit, ft, blob_decode) File "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 199, in parse_value return self.parser.parse(value, field_itype, field_type) File "C:\web2py\gluon\packages\dal\pydal\parsers\__init__.py", line 100, in parse return self.registered[field_itype](value, field_type) File "C:\web2py\gluon\packages\dal\pydal\parsers\__init__.py", line 75, in __call__ return self.call(value, field_type) File "C:\web2py\gluon\packages\dal\pydal\parsers\__init__.py", line 72, in _call return self.f(self.parser, value) File "C:\web2py\gluon\packages\dal\pydal\parsers\base.py", line 37, in _blob decoded = b64decode(to_bytes(value)) File "C:\web2py\gluon\packages\dal\pydal\_compat.py", line 131, in to_bytes raise TypeError('Expected bytes') TypeError: Expected bytes

Error snapshot 

TypeError(Expected bytes)

inspect attributes

Frames

• File C:\web2py\gluon\restricted.py in restricted at line 219 код аргументы переменные

• File C:\web2py\applications\test\controllers\default.py in <module> at line 61 код аргументы переменные

• File C:\web2py\gluon\globals.py in <lambda> at line 421 код аргументы переменные

• File C:\web2py\applications\test\controllers\default.py in index at line 9 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\objects.py in select at line 2395 код аргументы переменные

  Code listing

  2390.
  2391.
  2392.
  2393.
  2394.
  2395.
  2396.
  2397.
  2398.
  2399.
                                      attributes.get('join', None),
                                      attributes.get('left', None),
                                      attributes.get('orderby', None),
                                      attributes.get('groupby', None))
          fields = adapter.expand_all(fields, tablenames)
          return adapter.select(self.query, fields, attributes)
  
      def iterselect(self, *fields, **attributes):
          adapter = self.db._adapter
          tablenames = adapter.tables(self.query,

• File C:\web2py\gluon\packages\dal\pydal\adapters\base.py in select at line 763 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\adapters\base.py in _select_aux at line 742 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\adapters\base.py in parse at line 306 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\adapters\base.py in <listcomp> at line 303 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\adapters\base.py in _parse at line 232 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\adapters\base.py in parse_value at line 199 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\parsers\__init__.py in parse at line 100 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\parsers\__init__.py in __call__ at line 75 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\parsers\__init__.py in _call at line 72 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\parsers\base.py in _blob at line 37 код аргументы переменные

• File C:\web2py\gluon\packages\dal\pydal\_compat.py in to_bytes at line 131 код аргументы переменные

  Function argument list

  (obj=<fdb.fbcore.BlobReader object>, charset='utf-8', errors='strict')

  Code listing

  126.
  127.
  128.
  129.
  130.
  131.
  132.
  133.
  134.
  135.
              return None
          if isinstance(obj, (bytes, bytearray, memoryview)):
              return bytes(obj)
          if isinstance(obj, str):
              return obj.encode(charset, errors)
          raise TypeError('Expected bytes')
  
      def to_native(obj, charset='utf8', errors='strict'):
          if obj is None or isinstance(obj, str):
              return obj

Is it bug of DAL or it's normal?

[Dave S]

That looks like a Python2 vs Python3 issue.    And it's happening in the _compat.py module, which I believe is for P3 support.

/dps
 

[Константин Комков]

Ok, I will register issue on github.

[Val K]

Try this:

#default.py
def img():
    row = db(<query based on request.args/vars>).select(db.recipes.IMAGE).first()
    if row:
        return response.stream(row.IMAGE)

Usage: =URL( 'default', 'img', args=..., vars=...)

[Константин Комков]

def img():
    row = db().select(db.recipes.IMAGE).first()
    if row:
        return response.stream(row.IMAGE)
image = '<img src="'+URL( 'default', 'img')+'"/>'

>>> on HTML page no image.

<img src="/Recipes/default/img"/>

[Val K]

I believe that any object that has
read(chunk) and close() methods can be streamed. Open the browser console, refresh the page and check for errors

[Константин Комков]

In console was printed - GET http://127.0.0.1:8000/Recipes/default/img 500 (Server Error).

[Константин Комков]

Hmm, I restart web2py and now message is - GET http://127.0.0.1:8000/Recipes/default/img 404 (NOT FOUND).

[Val K]

Remove 'blob' from IMAGE field definition, if it causes an error.

[Константин Комков]

I use upload becouse if I will do query to blob field I have error and can't load page. In console was written - GET http://127.0.0.1:8000/Recipes/default/img 500 (Server Error). Previos message (GET http://127.0.0.1:8000/Recipes/default/img 404 (NOT FOUND).) was becouse I put img function inside index function.

[Val K]

I mean revert model to the state when you can retrieve images using base64, i.e. instead of encoding image you can stream it. If row.IMAGE.read() will work, stream will work as well

[Val K]

Also you can inspect server error using appadmin

[Константин Комков]

Full code which is work:

def index():
    row = db().select(db.recipes.IMAGE).first()
    import codecs
    base64_data = codecs.encode(row.IMAGE.read(), 'base64')

    base64_text = codecs.decode(base64_data, 'ascii')

    image = XML('<img src="data:image/png;base64, %s" class="card-img-top" alt="..."/>' % base64_text)
    return dict(image=image)

Full code which isn't work:

def index():
    image = XML('<img src="'+URL( 'default', 'img')+'" class="card-img-top" alt="..."/>')
    return dict(image=image)

def img():
    row = db().select(db.recipes.IMAGE).first()
    if row:
        return response.stream(row.IMAGE)

Console - (GET http://127.0.0.1:8000/Recipes/default/img 500 (Server Error))

[Константин Комков]

It is from appadmin print screen

[Val K]

Under inspect error I mean the following:

go to http://127.0.0.1:8000/admin/default/errors/Recipes/old

You will see all errors that were  - the first is the latest - click on it to see what is going on the server when trying to stream images

[Константин Комков]

If I have error I show it here. In case when I see error in console - "GET http://127.0.0.1:8000/Recipes/default/img 500 (Server Error)" I don't have errors in (http://127.0.0.1:8000/admin/default/errors/Recipes/old). And if I try go to http://127.0.0.1:8000/Recipes/default/img I don't have error in (http://127.0.0.1:8000/admin/default/errors/Recipes/old) too. On page I have message Server Error.

[Val K]

OK, it seems that something is crashing while streaming (db connection or something else). I met the similar problem when I tried to yield records from db using iterselect. Try just 'return row.IMAGE.read()' instead of response.stream(...)

[Константин Комков]

Val K, that case is work!)

def index():
    image = XML('<img src="'+URL( 'default', 'img')+'" class="card-img-top" alt="..."/>')
    return dict(image=image)

def img():
    row = db().select(db.recipes.IMAGE).first()
    if row:

        return row.IMAGE.read()

It seems very strange that return row.IMAGE.read() from img function work, but URL( 'default', args=row.IMAGE.read()) don't work.

I have not one image and get it in cycle. Are there variant use img function for it?

rows = db().select(db.recipes.IMAGE)
    for row in rows:

[Val K]

I don’t quite understand what do you mean 'in cycle', do you want to include all images  in one html page?

to make img() more useful you can do this (for example)    

def img():
        id =request.args(0)
    if id:

        row = db(db.recipes.id == id).select(db.recipes.IMAGE).first()
        if row:

                    return row.IMAGE.read()
        

def index():

    #show the first ten images

    img_list = DIV()

    rows = db().select(db.recipes.id, limitby = (0, 10))

    for row in rows:

        img_list.append(IMG(_src = URL('default', 'img', args = [row.id])))

    return dict(img_list = img_list)

[Константин Комков]

Yes, I want get from database many images (maybe not all, but 100 or 50 pictures). In your case for creating 1 page I need to do 101 or 51 query to database. I want have one query and transfer row.recipes.IMAGE as variable in img function. Somthing like that (but it's not work):

def index():
    image = ''

    rows = db().select(db.recipes.IMAGE)
    for row in rows:

        image += '<img src="'+URL( 'default', 'img', args = [row.recipes.IMAGE])+'" class="card-img-top" alt="..."/>'
    image = XML(image)
    return dict(image=image)

def img():
    image = request.args(0)
    if image:
        return image.read()

[Val K]

100 images per page? What do your images look like? Are these icons? What size?
To prevent db scratching there is Cache-Control

[Константин Комков]

Size of picture maybe like max size of pictures in instagram. I want to get something like on picture.

[Константин Комков]

If I use cache, for example:

def putRecipesInCache():
    recipesCache = cache.ram('recipes', lambda: db().select(db.recipes.IMAGE), time_expire=60*60*24)
    return recipesCache


def index():
    rows = putRecipesInCache()
    image = ''
    for row in rows:
        if row.IMAGE is None:
            image += ''
        else:

            import codecs
            base64_data = codecs.encode(row.IMAGE.read(), 'base64')
            base64_text = codecs.decode(base64_data, 'ascii')

            image += '<img src="data:image/png;base64, %s" class="card-img-top" alt="..."/>' % base64_text
    return XML()

I get error:

Error snapshot 

DatabaseError(('Cursor.read_output_blob/isc_open_blob2:\n- SQLCODE: -904\n- invalid database handle (no active connection)', -904, 335544324))

inspect attributes

Frames

• File C:\web2py\gluon\restricted.py in restricted at line 219 код аргументы переменные

• File C:\web2py\applications\Recipes\controllers\default.py in <module> at line 226 код аргументы переменные

• File C:\web2py\gluon\globals.py in <lambda> at line 421 код аргументы переменные

• File C:\web2py\applications\Recipes\controllers\default.py in index at line 74 код аргументы переменные

• File C:\web2py\applications\Recipes\controllers\default.py in selectRecipes at line 146 код аргументы переменные

• File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py in read at line 4764 код аргументы переменные

• File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py in __ensure_open at line 4658 код аргументы переменные

• File C:\Program Files (x86)\Python37-32\lib\site-packages\fdb\fbcore.py in __open at line 4667 код аргументы переменные

  Function argument list

  (self=<fdb.fbcore.BlobReader object>)

  Code listing

  4662.
  4663.
  4664.
  4665.
  4666.
  4667.
  4668.
  4669.
  4670.
  4671.
                             bs([ibase.isc_bpb_version1, ibase.isc_bpb_type, 1,
                                 ibase.isc_bpb_type_stream]))
          if db_api_error(self._isc_status):
              raise exception_from_status(DatabaseError,
                                          self._isc_status,
                                          "Cursor.read_output_blob/isc_open_blob2:")
          # Get BLOB total length and max. size of segment
          result = ctypes.cast(ctypes.create_string_buffer(20),
                               buf_pointer)
          api.isc_blob_info(self._isc_status, self._blob_handle, 2,

[Val K]

I am not sure, but I think that the problem has the same root as in the case of streaming: when lambda is invoked db is already wasted/rotten. So you can try to make a module with function that will fetch the rows from current.db and return them. Then you can import this module in the controller and pass module.function to cache.ram.
Also I think that the best place for static images in the static folder, not in the db.