Sorry I had to guess. Now that I know the tables:
items = db(db.posts.id==db.relations.post)
(db.relations.category==db.categories.id).select()
On Oct 6, 9:36 pm, Mengu <whalb...@gmail.com> wrote:
> i got this error for the query:
>
> >>> items = db(db.posts.relations.category==db.categories.id).select()
>
> Traceback (most recent call last):
> File "<console>", line 1, in <module>
> File "/home/mengu/web2py/gluon/sql.py", line 1265, in __getattr__
> return dict.__getitem__(self,key)
> KeyError: 'relations'
>
> here is my table definitions:
> db.define_table('posts',
> Field('title', 'string', length=200),
> Field('slug', 'string', length=200),
> Field('body', 'text'),
> Field('html', 'text'),
> Field('dateline', 'datetime', default=request.now,
> writable=False),
> Field('user', db.auth_user)
> )
>
> db.define_table('comments',
> Field('post', db.posts),
> Field('author', 'string'),
> Field('body', 'string', length=500),
> Field('dateline', 'datetime', default=request.now, writable=False)
> )
>
> db.define_table('categories',
> Field('title', 'string'),
> Field('slug', 'string', length=200),
> Field('postcount', 'integer')
> )
>
> db.define_table('relations',
> Field('post', db.posts),
> Field('category', db.categories)
> )
>
> On Oct 7, 4:43 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > items = db(dd.posts.relations.category==db.categories.id).select()
> > for item in items:
> > print item.posts.id,'belongs',item.categories.title
>
> > On Oct 6, 8:23 pm, Mengu <whalb...@gmail.com> wrote:
>
> > > massimo,
>
> > > actually this wasn't what i am asking, but thank you for showing
> > > another way for it. i have my controller named as "post" and i have
> > > the action "view". i currently have my routes_in like the
> > > following:http://mengu.pastebin.com/m698f1726thisisworking very well
> > > however
> > > please let me know if this is not necessary or a proper way.
>
> > > any recommendations on the query?http://mengu.pastebin.com/m111e1a47
> > > i could make something like:
> > > posts = db().select(db.posts.ALL)
> > > postcategories = {}
> > > for post in posts:
> > > postcategories[post.id] = {}
> > > for relation in post.relations.select():
> > > category = db.categories[relation.category]
> > > postcategories[post.id][category.id] = category.title
>
> > > however this makes tons of queries for each post which is something i
> > > really don't want.
>
> > > ----
>
> > > dear alvaro,
>
> > > i ofcourse would like to produce the software with you, i'd enjoy
> > > that. however i currently have my time very lack so i'm not working on
> > > the product all the time.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
