forwarded from pvt email.... orderinglist ?
Begin forwarded message: > From: Emmett <[EMAIL PROTECTED]> > Date: September 22, 2008 9:51:31 AM EDT > To: Michael Bayer <[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 -~----------~----~----~----~------~----~------~--~---