Without the whole model it is difficult to clearly understand what you are
trying to acheive...
You add those line to auth_user that you have customized??
Field('student', db.student), # = one to many
Field('contact', db.contact), # idem
It could depend of your backend database if it support FK...
If you had customized the auth_user table... Before add you FK field (the
ones above), try to make sure your custom auth_user is correct then add your
custom field one after one...
Richard
On Mon, Aug 8, 2011 at 4:33 PM, Eric Scott <[email protected]> wrote:
> Thanks for your response, Richard and Jim. Richard, the traceback is
> in my original message, as is the problematic part of the model code.
> The error occurs with any view/controller -- I can't access the app at
> all. The problem is definitely in the model and not the controller.
> The problem occurs when I insert any code into a model with the
> following syntax:
>
> field('fieldname", db.referenced_table)
>
> The error is revealed at the end of the traceback included in my
> original message:
>
> KeyError: 'student'
>
> One thing that confused me when reading the web2py book was the
> relatively brief time spend discussing foreign key relationships.
> Every other framework I've used (CakePHP and symfony) has spent at
> least a full chapter describing how to set up these relationships in
> the models. This makes me feel like I'm missing something really
> obvious. web2py has surprised me by letting me finish tasks that were
> very time consuming in other frameworks in a few lines of code, so I'm
> wondering if there's a really simple way to describe one-to-many and
> many-to-many relationships in web2py that I'm missing in the
> documentation.
>
> This is the syntax used for referencing many-to-one relationships in
> Chapter 7 of the latest web2py book, so I'm not entirely sure what I'm
> doing wrong.
>
> Jim, there is a many-to-one relationship between both students:users
> and contacts:users. I'm not sure if that's what you're asking. I've
> not seen the code you use anywhere in the web2py book (at least not
> that I recall), so I will give it a try to see if it works.
>
> Thanks again,
>
> Eric
>
> On Aug 8, 3:58 pm, Richard Vézina <[email protected]> wrote:
> > If you send you controller and model code at least with trace back it
> could
> > help to troobleshoot...
> >
> > Richard
> >
> >
> >
> >
> >
> >
> >
> > On Mon, Aug 8, 2011 at 3:51 PM, Eric Scott <[email protected]>
> wrote:
> > > I'm having problems getting tables linked in web2py using reference
> > > fields. For example, I have a model with table student and table
> > > contact. Table auth_user contains my app's users. In db.py, under
> > > db.define_table('auth_user') I have the following code to reference a
> > > one-to-many relationship between users:students and users:contacts:
> >
> > > Field('student', db.student),
> > > Field('contact', db.contact),
> >
> > > But I keep getting the following error:
> >
> > > Traceback (most recent call last):
> > > File "/home/www-data/web2py/gluon/restricted.py", line 192, in
> > > restricted
> > > exec ccode in environment
> > > File "/home/www-data/web2py/applications/teachertext/models/db.py",
> > > line 61, in <module>
> > > Field('student', db.student,
> > > File "/home/www-data/web2py/gluon/dal.py", line 4331, in __getattr__
> > > return self[key]
> > > File "/home/www-data/web2py/gluon/dal.py", line 4325, in __getitem__
> > > return dict.__getitem__(self, str(key))
> > > KeyError: 'student'
> >
> > > I'm new to web2py (but not to frameworks) and this is my first time
> > > referencing foreign keys in a web2py app. I'm sure I'm missing
> > > something obvious but I'd be grateful if someone could point it out
> > > for me.
> >
> > > Thank you,
> >
> > > Eric
>
