Quarta-feira, 30 de Maio de 2012 13:22:32 UTC+1, lcamara escreveu:
>
> Hey,
>
> I'm trying to validate some things on a self reference field, among them
> that a reference field on a table does not refer to the record where it is.
>
> For instance,
>
> db.define_table('person',
> Field('name', length=256, unique=True, requires=IS_NOT_EMPTY()),
> Field('gender', requires= IS_IN_SET([T('Male'), T('Female')],
> zero=T('choose one'))),
> Field('father', 'reference person'),
> Field('mother', 'reference person'),
> format = '%(name)s'
> )
>
> db.person.father.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Male'), db.person.id, '%(name)s', zero=T('choose one')))
> db.person.mother.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Female'), db.person.id, '%(name)s', zero=T('choose one')))
>
> So in addition to the gender restriction (yeah I know it's not always
> true, this is just an example), I'd like to add the restriction that a
> person cannot be it's own father or mother.
> Basically what I want is something like an IS_NOT_SELF or something.
>
> Any tips on how to go about this?
>
Quarta-feira, 30 de Maio de 2012 13:22:32 UTC+1, lcamara escreveu:
>
> Hey,
>
> I'm trying to validate some things on a self reference field, among them
> that a reference field on a table does not refer to the record where it is.
>
> For instance,
>
> db.define_table('person',
> Field('name', length=256, unique=True, requires=IS_NOT_EMPTY()),
> Field('gender', requires= IS_IN_SET([T('Male'), T('Female')],
> zero=T('choose one'))),
> Field('father', 'reference person'),
> Field('mother', 'reference person'),
> format = '%(name)s'
> )
>
> db.person.father.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Male'), db.person.id, '%(name)s', zero=T('choose one')))
> db.person.mother.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Female'), db.person.id, '%(name)s', zero=T('choose one')))
>
> So in addition to the gender restriction (yeah I know it's not always
> true, this is just an example), I'd like to add the restriction that a
> person cannot be it's own father or mother.
> Basically what I want is something like an IS_NOT_SELF or something.
>
> Any tips on how to go about this?
>
Quarta-feira, 30 de Maio de 2012 13:22:32 UTC+1, lcamara escreveu:
>
> Hey,
>
> I'm trying to validate some things on a self reference field, among them
> that a reference field on a table does not refer to the record where it is.
>
> For instance,
>
> db.define_table('person',
> Field('name', length=256, unique=True, requires=IS_NOT_EMPTY()),
> Field('gender', requires= IS_IN_SET([T('Male'), T('Female')],
> zero=T('choose one'))),
> Field('father', 'reference person'),
> Field('mother', 'reference person'),
> format = '%(name)s'
> )
>
> db.person.father.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Male'), db.person.id, '%(name)s', zero=T('choose one')))
> db.person.mother.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Female'), db.person.id, '%(name)s', zero=T('choose one')))
>
> So in addition to the gender restriction (yeah I know it's not always
> true, this is just an example), I'd like to add the restriction that a
> person cannot be it's own father or mother.
> Basically what I want is something like an IS_NOT_SELF or something.
>
> Any tips on how to go about this?
>
Quarta-feira, 30 de Maio de 2012 13:22:32 UTC+1, lcamara escreveu:
>
> Hey,
>
> I'm trying to validate some things on a self reference field, among them
> that a reference field on a table does not refer to the record where it is.
>
> For instance,
>
> db.define_table('person',
> Field('name', length=256, unique=True, requires=IS_NOT_EMPTY()),
> Field('gender', requires= IS_IN_SET([T('Male'), T('Female')],
> zero=T('choose one'))),
> Field('father', 'reference person'),
> Field('mother', 'reference person'),
> format = '%(name)s'
> )
>
> db.person.father.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Male'), db.person.id, '%(name)s', zero=T('choose one')))
> db.person.mother.requires = IS_EMPTY_OR(IS_IN_DB(db(db.person.gender ==
> 'Female'), db.person.id, '%(name)s', zero=T('choose one')))
>
> So in addition to the gender restriction (yeah I know it's not always
> true, this is just an example), I'd like to add the restriction that a
> person cannot be it's own father or mother.
> Basically what I want is something like an IS_NOT_SELF or something.
>
> Any tips on how to go about this?
>
