Multi column constraint in web2py

Question

I am trying to use the method posted by Anthony

db.define_table('ts_customer',
            Field('customer_name', 'string', length=80, required=True, unique=True))

db.define_table('ts_mileage_rate',
            Field('customer_id', 'reference ts_customer', required=True, notnull=True),
            Field('mileage_rate_year', 'integer', required=True, notnull=True,
                  requires=IS_NOT_IN_DB(
                      db(db.ts_mileage_rate.customer_id == request.vars.customer_id),
                      'ts_mileage_rate.mileage_rate_year')
            ))

I get the following error:

type 'exceptions.AttributeError'> 'DAL' object has no attribute 'ts_mileage_rate'

Any idea why?

score 0 · Answer 1 · answered Jul 24 '13 at 21:46

You have db.ts_mileage_rate.customer_id within the definition of the ts_mileage_rate table, so the table doesn't yet exist. Instead, define the requires attribute after the table definition:

db.ts_mileage_rate.mileage_rate_year.requires = IS_NOT_IN_DB(
    db(db.ts_mileage_rate.customer_id == request.vars.customer_id),
    'ts_mileage_rate.mileage_rate_year')

Multi column constraint in web2py

1 Answers1