Massimo - I tried this approach and it didn't work for me.
Unfortunately, it seems to do absolutely nothing. No file uploaded to
the uploads folder. No database update. No error message. Nada. Argh.
On Jun 16, 2:58 am, mdipierro <mdipie...@cs.depaul.edu> 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 <richard_gor...@verizon.net> 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 <mdipie...@cs.depaul.edu> 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 <richard_gor...@verizon.net> 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 <mdipie...@cs.depaul.edu> 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 <mdipie...@cs.depaul.edu> 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 <richard_gor...@verizon.net> 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?
