Search code examples
pythonforeign-keysweb2py

Foreign keys in web2py database

I use web2py framework with two tables. How can I refer one field from first table into second table?

Solution

  • Here's the section on table relationships and JOINs from the web2py chapter on databases

    To illustrate how to implement one to many relations with the web2py DAL, define another table "dog" that refers to the table "person" which we redefine here:

    >>> db.define_table('person',
                    Field('name'),
                    format='%(name)s')
>>> db.define_table('dog',
                    Field('name'),
                    Field('owner', db.person),
                    format='%(name)s')

    You'll need to provide more information if you are looking for something that's not covered in that reference.