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.