The best way to do it is discussed here with code examples in web2pyL http://www.mail-archive.com/[email protected]/msg06396.html
On Oct 15, 12:44 am, Vasile Ermicioi <[email protected]> wrote: > "php examples use classes (but we don't have an ORM, so data doesn't map > that way"Thank you, now I understand... > sqlalchemy has ability to map class <--> table, so I thought web2py could > have this feature too, > and I was wondering why web2py doesnt have a built in tree like table class > > On Thu, Oct 15, 2009 at 8:21 AM, Yarko Tymciurak <[email protected]> wrote: > > I'm not sure I understand your question: it seems from the link you > > provided, that this article (for example) gives you all you need to do > > this: > > >http://articles.sitepoint.com/article/hierarchical-data-database/2 > > > Actually, several of the links seem to be of similar usefulness... > > > The php examples use classes (but we don't have an ORM, so data doesn't map > > that way - the DAL is closer to the data model, so the links provide you > > fairly direct ways to implement all you want, I think). > > > On Thu, Oct 15, 2009 at 12:01 AM, Vasile Ermicioi <[email protected]>wrote: > > >> Hi, > >> But what about a more efficient tree implementation (at least for > >> retrieving ) like nested sets or materialized paths. > >> PhpDoctrine has an implementation > >>http://www.doctrine-project.org/documentation/manual/1_1/en/hierarchi... > >> <http://www.doctrine-project.org/documentation/manual/1_1/en/hierarchi...>This > >> was why I used doctrine in a few projects. > >> Even for implementing by myself I don't know how to do that, is there a > >> method to extend default table behavior, are there some events like > >> before_insert, or something like that? (sorry if it is a basic question, I > >> am still new to web2py, but was interested by this question) > > >> On Thu, Oct 15, 2009 at 1:05 AM, Yarko Tymciurak <[email protected]>wrote: > > >>> On Wed, Oct 14, 2009 at 4:44 PM, Giedrius <[email protected]> wrote: > > >>>> How i can make recursive one to many relation? I want to have > >>>> generalized categories like: Programing langauge / High level / > >>>> Python, Programing langauge / Low level / C, Programing langauge / > >>>> High level / PHP, Programing langauge / Low level / ASM and so on.. > >>>> I tried to like this, but got an error: > > >>>> db.define_table('category', > >>>> Field('name'), > >>>> Field('parent_id', db.category), > >>>> Field('info')) > > >>> To do self-reference or forward reference, use this form: > > >>> Field('parent_id', 'reference category'), > > >>> You can find more about this in section 6.13 of the Manual, > >>> "Self-Reference and Aliases" > >>> (http://www.web2py.com/examples/default/docs) > > >>> - Yarko > > >>>> Traceback (most recent call last): > >>>> File "/home/giedrius/web2py/gluon/restricted.py", line 178, in > >>>> restricted > >>>> exec ccode in environment > >>>> File "/home/giedrius/web2py/applications/shop/models/db.py", line > >>>> 74, in <module> > >>>> Field('parent_id', db.category), > >>>> File "/home/giedrius/web2py/gluon/sql.py", line 537, in __getattr__ > >>>> return dict.__getitem__(self,key) > >>>> KeyError: 'category' --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
