This article is a great resource as well--explains all you need to know very nicely I think (I especially like the trick of finding number of descendants (so number of comments associated with an item) just from inspecting the values for "right" and "left"--single row query). I found this a while back and had started rolling my own, then I discovered Django (so have started "porting" my site to Django), then I discovered the mptt app and thought I could just drop it in. Has not been that easy (probably in large part due to my Django-newbie status). http://www.sitepoint.com/article/hierarchical-data-database/2/
Keep us posted on your system. Would like to see it. On Sat, Oct 4, 2008 at 11:02 AM, Jonathan Nelson <[EMAIL PROTECTED]>wrote: > > I'm actually rolling my own threaded comments system using an MPTT > algorithm. Contrib.comments and the django-mptt aren't a really good > fit for what I need. > > It's taken me a while to get my head around the concept of traversing > the tree using the comment.left and comment.right values, but after > you understand it, it really seems to work well. > > I'll try and put some code up on Google code when I get mine > finished. > > I've found this article to be very helpful: > http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > > And, I've found this book to be invaluable: > > http://www.amazon.com/Hierarchies-Smarties-Kaufmann-Management-Systems/dp/1558609202/ref=sr_1_5?ie=UTF8&s=books&qid=1223136111&sr=8-5 > > J. > > > > > On Oct 1, 2:10 pm, "Chris Stromberger" <[EMAIL PROTECTED]> > wrote: > > If I can get something working, I'll share! Still fiddling around with > it. > > > > On Wed, Oct 1, 2008 at 2:48 PM, john Moylan <[EMAIL PROTECTED]> wrote: > > > Hi Chris, > > > > > I'd love to see your finished code - if you can/want to share? > > > > > J > > > > > 2008/9/30 Chris Stromberger <[EMAIL PROTECTED]> > > > > > OK, nevermind on the admin page issue. Was being caused > > >> by TEMPLATE_STRING_IF_INVALID being set to something other than ''. > > >> Would still love to see an example of contrib.comments + mptt! > > > > >> Thanks, > > >> Chris > > > > >> On Tue, Sep 30, 2008 at 4:25 PM, Chris Stromberger < > > >> [EMAIL PROTECTED]> wrote: > > > > >>> One specific issue I am having is that the admin screen for the > Comment > > >>> model is not "synched up" with the data. The admin list screen has a > table > > >>> of field names, and the columns do not match the data--the data is > shifted. > > >>> So for example, the "Is public" column is displaying the IP address. > Etc. > > >>> Any ideas on what would cause this? Mptt adds some fields to your > model > > >>> dynamically, so wondering if this is somehow related. > > >>> Any tips appreciated. > > > > >>> Thanks, > > >>> Chris > > > > >>> On Tue, Sep 30, 2008 at 2:31 PM, Chris Stromberger < > > >>> [EMAIL PROTECTED]> wrote: > > > > >>>> I'm trying to use mptt with contrib.commments and am not having much > > >>>> luck. Basically would like to allow nested comments. Pretty new to > Django, > > >>>> so that is contributing to the problem. Would love to see a simple > > >>>> example/summary of what needs to change in contrib.comments to > incorporate > > >>>> mptt. > > >>>> Thanks, > > >>>> Chris > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
