I have two tables, *t_image2* and *t_image1*, and I would like to copy an image (type: 'upload') from* t_image2* to *t_image1*.The tables are something like the following:
db.define_table('t_image2', ... Field('name', requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 't_image2.name' )], unique=True, notnull=True), Field('image', 'upload', uploadseparate=True, autodelete=True, uploadfolder=os_path_join(request.folder,'uploads/temp_images'), requires=[IS_NOT_EMPTY(), IS_IMAGE()]), ... ) db.define_table('t_image1', ... Field('name', requires=[IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 't_image1.name' )], unique=True, notnull=True), Field('image', 'upload', uploadseparate=True, autodelete=True, uploadfolder=os_path_join(request.folder,'uploads/images'), requires=[IS_NOT_EMPTY(), IS_IMAGE()]), Field('thumbnail','upload', uploadseparate=True, readable=True, writable=False, autodelete= True, uploadfolder=os_path_join(request.folder,'uploads/thumbnails'), compute=lambda row: SMARTHUMB('t_image_user_submit', row.image, ( 200, 150), upload_folder = 'uploads/thumbnails', request = request)), ...) It's possible to do this: db.t_image1.insert(name = [some name], image = [image_from_t_image2.image]) But this merely copies the entries that are in one table to the other, without making a copy of the file in question. It also doesn't trigger the *t_image1* 'thumbnail' field's 'compute' function, which would create the thumbnail file. Is there a better way to perform this sort of file copy from one table to another, such that the copy of the file is automatically made (and if necessary, the new folder is created), and which triggers the creation of the thumbnail? Or is it necessary to perform the folder creation and file copy operation, as well as the creation of the thumbnail, manually? 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.