Emmett Lazich wrote: > Thank you Jason. orderinglist looks like what I am after! > > Is your orderinglist plugin fully functional in 0.4.7p1?
Yep. > Before I attempt it, pls advise if there any technical reason preventing > the integration of orderinglist into the basic_tree.py (adjacency list) > example? > See > http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/examples/adjacencytree/basic_tree.py That example uses a dict-based collection, so it's not a drop in. But I don't see any obstacle to using the orderinglist on adjacency lists in general. > jason kirtland wrote: >> Yep, orderinglist handles that case. >> >> >> Michael Bayer wrote: >> >>> forwarded from pvt email.... >>> >>> orderinglist ? >>> >>> Begin forwarded message: >>> >>> >>>> *From: *Emmett <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> >>>> *Date: *September 22, 2008 9:51:31 AM EDT >>>> *To: *Michael Bayer <[EMAIL PROTECTED] >>>> <mailto:[EMAIL PROTECTED]>> >>>> *Subject: **Re: Support for ordered lists of child items* >>>> >>>> Hello Michael, 18 months later, would your answer to Aaron still be >>>> the same? >>>> >>>> I have a problem fitting what Aaron described. ie. save+restore of >>>> child order after re-ordering in the Python side. Re-ordering child >>>> list elements would obviously be ideal, but I could cope with updating >>>> an extra integer node attribute instead. >>>> >>>> I'm completely new to SA and at this stage skimming documentation and >>>> looking at the tree examples. Found this thread, so wondering if some >>>> newer SA magic can solve this, or if a custom collection class or >>>> something else is the best solution. >>>> >>>> I also looked at the ElementTree examples, but they don't appear to >>>> guarantee child order either - correct? >>>> >>>> Thanks in advance. I looked at your activity in this group. Amazing! >>>> >>>> >>>> On Apr 10 2007, 4:02 am, Michael Bayer <[EMAIL PROTECTED]> >>>> wrote: >>>> >>>>> we dont have the capability to automatically update ordering columns >>>>> when the elements of a list are moved around. if you move the >>>>> elements around, you need to execute some step that will update the >>>>> index columns (or create a custom collection class that does this for >>>>> you). >>>>> >>>>> On Apr 9, 2007, at 12:42 PM, Aaron Digulla wrote: >>>>> >>>>> >>>>> >>>>> >>>>>> Hello, >>>>>> >>>>>> I'm looking for a feature but couldn't find it in the docs. >>>>>> >>>>>> I have atreelike structure where the user can specify theorderof >>>>>> thechildrenof a node. In DB lingo, I have a parentId and an index >>>>>> column. When I loadchildren, they should be ordered by the index. >>>>>> This seems to be supported. >>>>>> >>>>>> Can SA also update the index column when I movechildrenin the list >>>>>> around? Like: >>>>>> >>>>>> # ... parent has threechildrenA, B C >>>>>> item = parent.children[0] >>>>>> del parent.children[0] >>>>>> parent.children.insert (1, item) >>>>>> # now, parent has threechildrenB, A, C >>>>>> >>>>>> Regards, >>>>>> >>> >> >> >> >> >> > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---