I don't think this will work since my factory is using multiple tables. I don't mean to digress, but another question is, how to open the file during the onvalidation? I need to open the file and read it in to check the contents for stuff that will determine whether it's valid or not. I've tried:
text=URL(r=request,c='default',f='download',args=form.vars.name) I've also tried text=open(os.path.join(request.folder,'uploads',form.vars.name),'rb').read() and other variations, but so far, can't seem to get it to work. On Jun 16, 2:17 am, mdipierro <[email protected]> wrote: > aha, you can do this > > file_form=SQLFORM.factory(....,table_name='srcfile') > file_form.accepts(request.vars,formname='file_form',onvalidation=check_file_in): > db.srcfile.insert(name=form.vars.name) > > On Jun 16, 12:34 am, weheh <[email protected]> wrote: > > > Nice and simple. Thanks Massimo. > > > But FWIW, this doesn't rename the no_table.name.blahblah.txt file to > > srcfile_table.name.blahblah.txt, which may or may not be the right > > thing to do -- I'm not sure. Since I am uploading everything through > > the factory form, all fields are no_table fields. Since I eventually > > store them in their respective tables, it seems logical that they go > > into the corresponding (correctly named) folder/filenames -- > > srcfile_table/ab/srcfile_table.name.blahblah.txt. What do you think? > > > On Jun 15, 11:46 pm, mdipierro <[email protected]> wrote: > > > > Actually this would work but it is not the best way, ... the problem > > > is that the storage is already performed by accepts so you must do > > > simply > > > > file_form.accepts(request.vars,formname='file_form',onvalidation=check_file_in): > > > db.srcfile.insert(name=form.vars.name) > > > > On Jun 15, 10:44 pm, mdipierro <[email protected]> wrote: > > > > > May be a bug. can you try? > > > > > file_form.accepts(request.vars,formname='file_form',onvalidation=check_file_in): > > > > request.vars.name.file.seek(0) ### add this line > > > > db.srcfile.insert( > > > > name=db.srcfile.name.store( > > > > request.vars.name.file,request.vars.name.filename), > > > > ) > > > > > On Jun 15, 11:02 am, weheh <[email protected]> wrote: > > > > > > # model > > > > > db.define_table('srcfile', > > > > > Field('name','upload',length=50,label=T('Upload > > > > > file'),autodelete=True, > > > > > uploadseparate=True, > > > > > requires=( > > > > > IS_UPLOAD_FILENAME(extension='pdf|txt|doc|htm|html|xml|ppt'), > > > > > IS_LENGTH(5000000,10)) > > > > > ), > > > > > ) > > > > > > # controller > > > > > ... > > > > > file_form=SQLFORM.factory(db.auth_user,db.othertable,db.srcfile) > > > > > ... > > > > > if > > > > > file_form.accepts(request.vars,formname='file_form',onvalidation=check_file_in): > > > > > db.srcfile.insert( > > > > > name=db.srcfile.name.store( > > > > > request.vars.name.file,request.vars.name.filename), > > > > > ) > > > > > ... > > > > > > Problem is, file gets uploaded into > > > > > no_table.name/a2/ > > > > > no_table.name.a24060930d31d0c1.313234363931322e747874.txt > > > > > prior to the insert. After the insert, there is a folder > > > > > srcfile.name/b1/srcfile.name.b192a5e35dc5081e. > > > > > 313234363931322e747874.txt > > > > > except that the file is empty. > > > > > > Question: is this a bug, or do I need to explicitly copy from the > > > > > source to the destination? If the latter, what would the rationale be > > > > > for creating the destination file without copying the contents from > > > > > the source?
