CODEWITHSUNDEEP
pythonforeign-keysweb2py
enthusiastic
enthusiastic

Reputation: 742

Foreign keys in web2py database

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

Upvotes: 6

Views: 6447

Answers (2)

mwolfe02
mwolfe02

Reputation: 24227

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.

Upvotes: 8

Anthony
Anthony

Reputation: 25536

See The Database Abstraction Layer chapter of the book, in particular, the section on One to Many Relations. If you're working with a pre-existing/legacy database, see Legacy Databases and Keyed Tables. Also, here's an example.

Upvotes: 1

Related Questions