Re: [SQLObject] Problem with re-ordering rows.

2007-07-16 Thread Oleg Broytmann
On Thu, Jul 12, 2007 at 11:47:33AM +0100, Nick Murdoch wrote: > class Line(SQLObject): > owner = ForeignKey('Scene') > text = UnicodeCol() > prev = SingleJoin('Line', addRemoveName='Prev') > next = SingleJoin('Line', addRemoveName='Next') > created = DateTimeCol(default=dat

Re: [SQLObject] Problem with re-ordering rows.

2007-07-12 Thread TiNo
Just an idea: make a column 'order_number' in lines (and in scenes), and methods 'moveUp', 'moveDown'. Which take care of changing the 'order_numbers'. Generally new lines are added with the highest ordernumber + 1, or could be 'inserted' by giving an order number. Seems easier to me than the prev