please no more links in code. :-(
On Dec 24, 11:19 am, "Arun K.Rajeevan" <[email protected]> wrote: > Following are my tables. > > I need a form with an image upload (that's for table pictures), a disabled > input with content (that's words.word) and a languages selection box(for > word.lang). Upon form submission, I'll populate all other fields required for > both tables. > > Is there a simple way to do this? > > If not, > > How to insert a picture manually.(with proper renaming etc., that's default) > > I'm running on GAE. > > db.define_table('languages', > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('full', 'string', > length=30, notnull=True, required=True), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('short', 'string', > length=10 , notnull=True, required=True), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('natural', 'string', > length=30), > format='%(full)s - %(short)s') > > db.define_table('words', > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('word', 'string', > notnull=True, required=True), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('lang', db.languages, > notnull=True, writable=False), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('entry_by', db.auth_user, > notnull=True, readable=False, writable=False)) > > db.define_table('pictures', > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('image', 'upload', > notnull=True, required=True, label='Visual Lingua'), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('word', 'list:reference > words', readable=False, writable=False, required=True), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('total', 'integer', > readable=False, writable=False, default=2), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('clicks', 'integer', > readable=False, writable=False, default=1), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('rating', 'double', > readable=False, writable=False, compute=lambda row: > row['total']/row['clicks']), > Field > <http://127.0.0.1:8000/examples/global/vars/Field>('entry_by', db.auth_user, > notnull=True, readable=False, writable=False)) > > db.languages.full.requires = [IS_NOT_EMPTY > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>(), IS_NOT_IN_DB > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_IN_DB>(db, > 'languages.full')] > db.languages.short.requires = [IS_NOT_EMPTY > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>(), IS_NOT_IN_DB > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_IN_DB>(db, > 'languages.short')] > db.languages.natural.requires = [IS_NOT_IN_DB > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_IN_DB>(db, > 'languages.natural')] > > db.words.word.requires = IS_NOT_EMPTY > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>() > db.words.lang.requires = IS_IN_DB > <http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db, 'languages.id') > db.words.entry_by.requires = [IS_IN_DB > <http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db, 'auth_user.id')] > > db.pictures.image.requires = [IS_NOT_EMPTY > <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY>(), IS_LENGTH > <http://127.0.0.1:8000/examples/global/vars/IS_LENGTH>(262144, 4096), > IS_IMAGE > <http://127.0.0.1:8000/examples/global/vars/IS_IMAGE>(minsize=(60, 60))] > #min_size 4kb, max_size 256kb; min_width 60px min_height 60px > db.pictures.entry_by.requires = [IS_IN_DB > <http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db, 'auth_user.id')]
