The file is in request.vars[fieldname].file the only issue is that if you read from it, you need to rewind it with
request.vars[fieldname].file.seek(0) On Jun 16, 9:17 am, weheh <[email protected]> wrote: > I will try this. How about how to open the upload file during > validation (see my previous post)? > > On Jun 16, 2:58 am, mdipierro <[email protected]> wrote: > > > Try this: > > > file_form=SQLFORM.factory(db.auth_user,db.othertable,db.srcfile) > > ... > > if FORM.accepts(file_form,request.vars,formname='file_form'): # no > > upload > > > check_file_in(file_form) # same as onvalidation > > > if not file_form.errors: > > db.srcfile.insert( > > name=db.srcfile.name.store( > > request.vars.name.file,request.vars.name.filename), > > ) > > > On Jun 16, 1:29 am, weheh <[email protected]> wrote: > > > > 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?
