How can I make the 'barcode' field in bursary_entries reference/depend upon
a 'barcode' entry in bursary_users? Do I just have to alter my field to:
type='text', requires=IS_IN_DB(db,'bursary_users.barcode)
I was trying to make sense of what was needed here and I thought 'requires'
was the best way of doing it, but does that only work for the primary key?
Thanks for your help.
On Friday, October 14, 2016 at 7:49:17 PM UTC+1, Val K wrote:
>
>
> 'reference bursary_users' and requires = [IS_IN_DB(db, 'bursary_users
> .barcode')] - I think, that it's mutually exclusive requirements
> 'reference bursary_users' == requires = IS_IN_DB(db, 'bursary_users.*id*')
>
>
>
>
>
>
>
> On Friday, October 14, 2016 at 6:21:38 PM UTC+3, James Booth wrote:
>>
>> Hey guys,
>>
>> Excuse me if I'm missing something (or a lot), but I'm pretty experienced
>> with web2py.
>>
>> I have the following defined in my model:
>>
>> db.define_table('bursary_users',
>>> Field('forename', type='string',
>>> requires=IS_NOT_EMPTY()),
>>> Field('surname', type='string', requires=IS_NOT_EMPTY()),
>>> Field('studentId', type='string',
>>> requires=IS_NOT_EMPTY(), unique=True),
>>> Field('barcode', type='string', requires=IS_NOT_EMPTY(),
>>> unique=True),
>>> Field('email', type='string', requires=IS_EMAIL(),
>>> unique=True),
>>> Field('bursary', requires=IS_IN_SET(['Free school
>>> meals','Bursary','Disabled'])),
>>> Field('notes', type='text'),
>>> format='%(studentId)s'
>>> )
>>> db.define_table('bursary_entries',
>>> Field('barcode', 'reference bursary_users', requires =
>>> [IS_IN_DB(db, 'bursary_users.barcode')]),
>>> Field('entry_date', type='datetime',
>>> default=request.now, readable=False, writable=False),
>>> format='%(barcode)s'
>>> )
>>
>>
>> When I use the SQLFORM on a page, I can enter a barcode and it validates
>> it (Fails if not in bursary_users, pass if it is). However, when I come to
>> check the database, I'm getting a '0' (Althought it is hyperlinked to
>> nothing) for the barcode value and a correct value for the entry_date.
>>
>> Any ideas why this is happening?
>>
>> Kind regards,
>> James.
>>
>
--
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.
