ah, yes - that is very clean... On Thu, Oct 15, 2009 at 1:17 AM, mdipierro <[email protected]> wrote:
> > 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 -~----------~----~----~----~------~----~------~--~---
