Re: how to re-order a relationship

From: Joshua Pyle (joshua.t.pyl..mail.com)
Date: Wed Apr 27 2005 - 12:03:13 EDT

  • Next message: Mike Kienenberger: "Re: <cgen> Ant task and makepairs attribute"

    I don't know if there is another way to do it but...
     I overide the cayenne class accessor that returns the relationship and I do
    and in memoory sort. here is an example
      public List getRevInspections() {
    List toBeSorted = super.getRevInspections();
    Ordering comparator = new Ordering(Insp.INSP_DT_PROPERTY, Ordering.DESC);
    Collections.sort(toBeSorted, comparator);
    return toBeSorted;
    } 

    -- 
Joshua T. Pyle
Go has always existed. 
 On 4/27/05, Erik Hatcher <eri..hatchersolutions.com> wrote: 
> 
> Here's my model - a "page" has multiple "sections". Sections are user
> orderable, and I provide a user interface to move them around. My plan
> is to add an "order" integer column to the SECTION table.
> 
> Initially the sections table would look something like this:
> 
> id order
> 1 1
> 2 2
> 3 3
> 
> then a user chooses to move section 3 up one, so it'd look like this:
> 
> id order
> 1 1
> 2 3
> 3 2
> 
> How are folks handling this type of thing? I don't see a way to
> specify an order for a relationship join, so how could I get the List
> from a page.sections() call to come back in "order" order?
> 
> And how do you handle updating the database in this type of situation?
> I presume that I will simply swap "order" numbers on two different
> section objects when a move-up or move-down action happens.
> 
> Thanks for your help.
> 
> Erik
>

    This archive was generated by hypermail 2.0.0 : Wed Apr 27 2005 - 12:03:14 EDT