Any suggestions, anyone ?
How to extract data from BLOB ?
среда, 3 мая 2017 г., 22:02:12 UTC+3 пользователь Scorpa написал:
>
> Hello folks !
>
> I have database that's have BLOB type to store any kind of data (it's
> should be binary ?):
>
> Field('f_blob', type='blob',
> label=T('blob object')),
>
>
> I'm inserting new records with:
>
> db.t_cache.insert(f_name='processed_' + request.vars.filename, f_blob= data)
>
>
> Where data is pandas object which is covnerted to CSV:
>
> data = StringIO.StringIO()
> source.to_csv(_tmp_data)
> data.seek(0)
>
>
> In database DATA record appears. but i can't fnd any information about
> retrieving this object from db.
>
>
> I tried RETRIEVE method (where the hell documenation about this ? no comments
> in source)
>
> Such as:
>
> db.t_cache.f_blob.retrieve(db.t_cache[ID].f_blob).f_blob gives =
> {TypeError}Can't retrieve <StringIO.StringIO instance at 0x03BD95A8> file
> properties
>
>
> db.t_cache.f_blob.retrieve(db.t_cache[ID]) = {TypeError}expected string or
> buffer
>
>
> So how to get back BLOB object from databse and use it later ?
>
>
--
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
