Thank you Jason. orderinglist looks like what I am after! Is your orderinglist plugin fully functional in 0.4.7p1?
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 E. 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 -~----------~----~----~----~------~----~------~--~---