In a table I defined a field:
Field('customLabel', length=128, requires=[IS_LENGTH(32), IS_NOT_EMPTY()]),
When the user updates this field I need the update to cascade to a field
label
in another table:
Field('label', length=128, default='', requires=IS_IN_DB(db,
'ntw_edge_label_set.customLabel',
'%(customLabel)s', orderby='ntw_edge_label_set.customLabel')),
The problem is that it should not cascade to all the label fields
containing the customLabels
just to the ones related to this specific user.
My first thought was to query the db
rows = db((table.outID==user_id) &
(table.label==form.vars.customLabel)).select()
for row in rows:
row.update_record(label=form.vars.customLabel)
I am wondering wether this is the most efficient way to update the records
or whether
there is a better way to do this.
Kind regards,
Annet
--
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.
