[web2py] Re: Dynamic Upload Uploadfolder
You cannot do this uploadfolder= lambda r:... But this is a chicken-egg problem. You want r to be the row but the row is not created until after the file is uploaded therefore you cannot specify the upload folder as function of something that happens after. Please explain to us in english of the folder should depend on the upload and perhaps we can suggest a way to do it. On Saturday, 29 November 2014 14:08:20 UTC-6, James Burke wrote: > > How do you create a dynamic uploadfolder for an upload Field? > > I tried using: > uploadfolder= lambda r: db.repository(r.repository_id).directory > > but i get the error message, I guess it doesn't have the same > functionality as compute: > cannot concatenate 'str' and 'function' objects > > I'm also using custom_store/retreive to maintain the files original > filename > > def store_file(file, filename=None, path=None): > path = path # "applications/init/uploads" > if not os.path.exists(path): > os.makedirs(path) > pathfilename = os.path.join(path, filename) > dest_file = open(pathfilename, 'wb') > try: > shutil.copyfileobj(file, dest_file) > finally: > dest_file.close() > return filename > > > If I can set the uploadfolder dynamically then it's passed to store_file > as path. > > I also tried: > path = db.repository(db.workbench(db.workbench.name==filename).repository > ).directory > > But it can't find a record, I guess because store_file is run before the > record is created in the db. > > Any suggestions? > > Thank you! > -- 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.
[web2py] Re: Dynamic Upload Uploadfolder
Thank you for your help Massimo.
My model is defined as follows:
## Repository
db.define_table('repository',
Field('name', type='string'),
Field('directory', default='applications/init/uploads'),
format='%(name)s')
## Workbench - workbenches stored in the repository
db.define_table('workbench',
Field('repository', 'reference repository'),
Field('name', compute=lambda r:
db.workbench.workbench.retrieve(r.workbench)[0]),
Field('workbench', type='upload', required=True,
custom_store=store_file, custom_retrieve=retrieve_file ),
Field('sequence', 'integer', required=True),
Field('created_date', 'datetime', default=request.now, readable=False,
writable=False),
Field('modified_date', 'datetime', update=request.now, readable=False,
writable=False),
format='%(name)s')
I have a Repository table which is joined to the Workbench table (1:M - a
repository can have many workbenches )
In my controller I have a smartgrid for Repository which has Workbenches as
a linked table. After a Repository has been created, the user can create
Workbenches linked to the Repository. When creating the Workbench I want
the workbench file to be uploaded to the directory in the Repository
location field.
I hope that makes it clear what I'm trying to achieve.
Thank you.
On Monday, December 1, 2014 11:46:57 AM UTC+13, Massimo Di Pierro wrote:
>
> You cannot do this uploadfolder= lambda r:...
> But this is a chicken-egg problem. You want r to be the row but the row is
> not created until after the file is uploaded therefore you cannot specify
> the upload folder as function of something that happens after.
>
> Please explain to us in english of the folder should depend on the upload
> and perhaps we can suggest a way to do it.
>
>
> On Saturday, 29 November 2014 14:08:20 UTC-6, James Burke wrote:
>>
>> How do you create a dynamic uploadfolder for an upload Field?
>>
>> I tried using:
>> uploadfolder= lambda r: db.repository(r.repository_id).directory
>>
>> but i get the error message, I guess it doesn't have the same
>> functionality as compute:
>> cannot concatenate 'str' and 'function' objects
>>
>> I'm also using custom_store/retreive to maintain the files original
>> filename
>>
>> def store_file(file, filename=None, path=None):
>> path = path # "applications/init/uploads"
>> if not os.path.exists(path):
>> os.makedirs(path)
>> pathfilename = os.path.join(path, filename)
>> dest_file = open(pathfilename, 'wb')
>> try:
>> shutil.copyfileobj(file, dest_file)
>> finally:
>> dest_file.close()
>> return filename
>>
>>
>> If I can set the uploadfolder dynamically then it's passed to store_file
>> as path.
>>
>> I also tried:
>> path = db.repository(db.workbench(db.workbench.name==filename).repository
>> ).directory
>>
>> But it can't find a record, I guess because store_file is run before the
>> record is created in the db.
>>
>> Any suggestions?
>>
>> Thank you!
>>
>
--
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.
[web2py] Re: Dynamic Upload Uploadfolder
Any ideas? Cheers On Monday, December 1, 2014 11:46:57 AM UTC+13, Massimo Di Pierro wrote: > > You cannot do this uploadfolder= lambda r:... > But this is a chicken-egg problem. You want r to be the row but the row is > not created until after the file is uploaded therefore you cannot specify > the upload folder as function of something that happens after. > > Please explain to us in english of the folder should depend on the upload > and perhaps we can suggest a way to do it. > > > On Saturday, 29 November 2014 14:08:20 UTC-6, James Burke wrote: >> >> How do you create a dynamic uploadfolder for an upload Field? >> >> I tried using: >> uploadfolder= lambda r: db.repository(r.repository_id).directory >> >> but i get the error message, I guess it doesn't have the same >> functionality as compute: >> cannot concatenate 'str' and 'function' objects >> >> I'm also using custom_store/retreive to maintain the files original >> filename >> >> def store_file(file, filename=None, path=None): >> path = path # "applications/init/uploads" >> if not os.path.exists(path): >> os.makedirs(path) >> pathfilename = os.path.join(path, filename) >> dest_file = open(pathfilename, 'wb') >> try: >> shutil.copyfileobj(file, dest_file) >> finally: >> dest_file.close() >> return filename >> >> >> If I can set the uploadfolder dynamically then it's passed to store_file >> as path. >> >> I also tried: >> path = db.repository(db.workbench(db.workbench.name==filename).repository >> ).directory >> >> But it can't find a record, I guess because store_file is run before the >> record is created in the db. >> >> Any suggestions? >> >> Thank you! >> > -- 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.
[web2py] Re: Dynamic Upload Uploadfolder
There are lots of ways to do this, the easiest is probably to just define the uploadfolder for the field in the controller for workbench creation/update instead of defining your custom store and retrieve. Something like this: def create_workbench(): """ Form to create a workbench in a given repository """ rep = db.repository[request.args(0)] if rep is None: raise HTTP(404) db.workbench.workbench.uploadfolder = rep.directory form = SQLFORM(db.workbench) if form.process().accepted: response.flash = 'Yay' elif form.errors: response.flash = 'Nay' def update_workbench(): """ Form to update a workbench """ wb = db.worbench[request.args(0)] db.workbench.workbench.uploadfolder = wb.repository.directory form = SQLFORM(db.workbench, wb) if form.process().accepted: response.flash = 'Yay' elif form.errors: response.flash = 'Nay' I haven't tried it, but this should work if you remove your custom store and retrieve. -- 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.
[web2py] Re: Dynamic Upload Uploadfolder
Thank you Leonel, great idea. Although I'll need to use oncreate/onupdate since I'm using a smartgrid Cheers, -James On Tuesday, December 2, 2014 10:28:49 PM UTC+13, Leonel Câmara wrote: > > There are lots of ways to do this, the easiest is probably to just define > the uploadfolder for the field in the controller for workbench > creation/update instead of defining your custom store and retrieve. > Something like this: > > > def create_workbench(): > """ Form to create a workbench in a given repository """ > rep = db.repository[request.args(0)] > if rep is None: > raise HTTP(404) > db.workbench.workbench.uploadfolder = rep.directory > form = SQLFORM(db.workbench) > if form.process().accepted: > response.flash = 'Yay' > elif form.errors: > response.flash = 'Nay' > > > def update_workbench(): > """ Form to update a workbench """ > wb = db.worbench[request.args(0)] > db.workbench.workbench.uploadfolder = wb.repository.directory > form = SQLFORM(db.workbench, wb) > if form.process().accepted: > response.flash = 'Yay' > elif form.errors: > response.flash = 'Nay' > > I haven't tried it, but this should work if you remove your custom store > and retrieve. > > > > -- 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.
[web2py] Re: Dynamic Upload Uploadfolder
Final solution was this:
_tables.py
def store_file(file, filename=None, path=None):
path = path #"applications/init/uploads"
if not os.path.exists(path):
os.makedirs(path)
pathfilename = os.path.join(path, filename)
dest_file = open(pathfilename, 'wb')
try:
shutil.copyfileobj(file, dest_file)
finally:
dest_file.close()
return filename
## Repository
db.define_table('repository',
Field('name', type='string'),
Field('directory', default='applications/init/uploads'),
Field('priority', 'integer', default=100),
format='%(name)s')
## File - Files stored in the repository
db.define_table('workbench',
Field('repository', 'reference repository'),
Field('name')
Field('workbench', type='upload', required=True, custom_store=store_file
, custom_retrieve=retrieve_file), #
Field('sequence', 'integer', required=True),
Field('created_date', 'datetime', default=request.now, readable=False,
writable=False),
Field('modified_date', 'datetime', update=request.now, readable=False,
writable=False),
format='%(name)s')
Repository.py
def onvalidation(form):
repository = db.repository(form.vars.repository)
if repository is None:
raise HTTP(404)
db.workbench.workbench.uploadfolder = repository.directory
def oncreate(form):
db(db.workbench.id==form.vars.id).update(name=form.vars.workbench)
def onupdate(form):
db(db.workbench.id==form.vars.id).update(name=form.vars.workbench)
def index():
"""
Additional code here
"""
form = SQLFORM.smartgrid(db.repository,
fields=fields,
orderby=orderby,
searchable=True,
details=details,
editable=editable,
deletable=deletable,
oncreate=oncreate,
onupdate=onupdate,
onvalidation=onvalidation,
links=links,
paginate=paginate,
linked_tables=linked_tables)
return dict(form=form)
Need to use onvalidation to set the upload directory, oncreate is executed
after the record is created.
--
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.
