2) YES, They need to be in db.py, or another model file, but preferably db.py.
1) will not work. controllers are not python modules, they cannot be imported. They are ment to be run in a pre-setup environment by web2py. The DAL does not know about any tables in the database, unless they are specified with "define_table"... Even for tables that exist. So you cannot split your db table statements up into separate controllers, that get called at separate times. -Thadeus On Sat, Oct 31, 2009 at 4:07 PM, Mengu <[email protected]> wrote: > > Hi everyone. > > I have db = DAL("sqlite://blog.db") in my db.py. I can define my > tables in my models with having that statement in the model however I > cannot create relationships. > > For example, this is post.py: > db = DAL("sqlite://blog.db") > db.define_table('post', > Field('title', 'string'), > Field('body', 'text') > ) > > and this is comment.py: > db = DAL("sqlite://blog.db") > db.define_table("comment", > Field('post_id', db.post), > Field('author', 'string'), > Field('comment', 'text') > ) > > I get the following error: > > Traceback (most recent call last): > File "/home/mengu/projects/web2py/gluon/restricted.py", line 184, in > restricted > exec ccode in environment > File "/home/mengu/projects/web2py/applications/blog/models/ > comment.py", line 5, in <module> > Field('post_id', db.post), > File "/home/mengu/projects/web2py/gluon/sql.py", line 1148, in > __getattr__ > return dict.__getitem__(self,key) > KeyError: 'post' > > I also should note that this works fine if post_id is not db.post but > an integer or another field. > > So my questions are: > > 1) Should I import db.post for this to work and how? > > 2) Must table definitions always be made on the db.py file? > > Thanks. > > Mengu > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
