Hello Ian, Sorry we overlooked your email. You can easily add a UUID field
from gluon.util import web2py_uuid db.define_table('person',Field('name'),Field('uuid',compute=lambda:web2py_uuid())) You can also create table that reference that field: db.define_table('thing',Field('name'),Field('owner',requires=IS_IN_DB(db,'person.uuid','name')) Except the reference will not be enforced at the DB level, only at the web2py level. Massimo On Friday, 23 May 2014 23:04:10 UTC-5, Ian W. Scott wrote: > > After 10 days I've received no help on this. Is there something about the > question that is inappropriate? Is my question unclear? > > On Wednesday, May 14, 2014 11:44:43 AM UTC-4, Ian W. Scott wrote: >> >> I need to take an existing db and implement a UUID referencing system so >> that I can sync local db's with a central remote version. But I'm concerned >> that this will break reference fields that refer to the newly synced rows. >> >> My understanding is that the UUID field is necessary because a csv import >> will assign different row ids to the new entries in the target db than the >> ones they had in the source db (especially if new records have been added >> to the target db in the meantime). The UUID is supposed to overcome this, >> by allowing the db to recognize that rows are equivalent even if they have >> different ids. But in that case, won't reference fields in other tables >> often be pointing to the wrong ID number in the target db? (i.e., they'll >> keep the row ID of the db version in which they were created, and if this >> ID changes in the target db they will then be referencing a different >> record.) >> >> Sorry if this explanation is overly complicated. I'm just trying to get >> things clear in my own mind. >> >> Thanks >> >> -- 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.