Database administration - db upload field

[ab]

Hi

I found issue in database administration module and blob field for
files storage

When model is defined as below

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

there is no problem with inserting new records using 'database
administration'

but when model is defined to store files in database as below

db.define_table('picture',
Field('file','upload',uploadfield='file_data'),
Field('file_data','blob'))

'database administration' can't insert new record.

I don't know if this is issue or current limitation.

Regards

[mdipierro]

Please try

Field('file_data','blob',default=''))

[ab]

Thanks. Working fine.

I have one more question.

When I upload file by database administration, field file contains for
example following entry -
picture.file.975598ae58526cda.
46697265666f785f77616c6c70617065722a706a67.png

I want to upload files by REST. Is there function which I can use to
calucate file field value as above?

[mdipierro]

It depends on how you send the file. Can you send me an example?

[ab]

I don't know uploaded file name. There is only stream of bytes to save
in blob field.

[mdipierro]

def upload():
import cStringIO
data=request.body.read()
f=cStringIO.StringIO(data)
current_filename='bla.bla' # how to you know the file extension if
you do not pass the name?
new_filename=db.mytable.picture.store(f,current_filename)
# do something with new_filename and data

[yamandu]

I was almost blaming SQLite and almost changed it.
Why the need of the default attribute?
Is this a bug? I did not understand.

[mdipierro]

I do not understand the question

Massimo