Ok, models are executed in alphabetical order. And you only need to define the DAL once, if you do it again, you lose all tables defined.
so this is the order they would get executed in. comment.py <<< db.py <<< post.py <<< -Thadeus On Sat, Oct 31, 2009 at 6:56 PM, Mengu <[email protected]> wrote: > > Thadeus, thanks for the reply. By the way, these are not controllers, > these are models. > > Mengu > > On Nov 1, 1:53 am, Thadeus Burgess <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
